app_comp_record

0 rows


Description

Track current proficiency of a user in each competency

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_comp_record_id_seq'::regclass)
userid int8 19 null
app_user.id Defined in XMLR
competencyid int8 19 null
app_comp.id Defined in XMLR
positionid int8 19 null
app_pos.id Defined in XMLR
organisationid int8 19 null
app_org.id Defined in XMLR
assessorid int8 19 null
app_user.id Defined in XMLR
assessorname varchar 100 null
assessmenttype varchar 100 null
proficiency int8 19 null
app_comp_scale_values.id Defined in XMLR
timeproficient int8 19 null
timecreated int8 19 null
timemodified int8 19 null
reaggregate int8 19 0
manual int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_compreco_id_pk Primary key Asc id
app_compreco_ass_ix Performance Asc assessorid
app_compreco_com_ix Performance Asc competencyid
app_compreco_man_ix Performance Asc manual
app_compreco_org_ix Performance Asc organisationid
app_compreco_pos_ix Performance Asc positionid
app_compreco_pro_ix Performance Asc proficiency
app_compreco_rea_ix Performance Asc reaggregate
app_compreco_use_ix Performance Asc userid
app_compreco_usecom_uix Must be unique Asc/Asc userid + competencyid

Relationships