Comp Record Table Schema (comp_record)


Track current proficiency of a user in each competency

comp_record table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 null compreco_use2_fk R
competencyid BIGINT 19 null compreco_com2_fk R
positionid BIGINT 19 null compreco_pos2_fk R
organisationid BIGINT 19 null compreco_org2_fk R
assessorid BIGINT 19 null compreco_ass2_fk R
assessorname VARCHAR 100 null
assessmenttype VARCHAR 100 null
proficiency BIGINT 19 null compreco_pro2_fk R
timeproficient BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
reaggregate BIGINT 19 0
manual TINYINT 3 0

Table contained -1 rows

comp_record table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compreco_ass_ix Performance Asc assessorid
compreco_com_ix Performance Asc competencyid
compreco_man_ix Performance Asc manual
compreco_org_ix Performance Asc organisationid
compreco_pos_ix Performance Asc positionid
compreco_pro_ix Performance Asc proficiency
compreco_rea_ix Performance Asc reaggregate
compreco_use_ix Performance Asc userid
compreco_usecom_uix Must be unique Asc/Asc userid + competencyid

comp_record table relationships