0 rows


Track current proficiency of a user in each competency


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


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