Comp Record Table Schema (comp_record)


Description

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
user.id compreco_use2_fk R
competencyid BIGINT 19 null
comp.id compreco_com2_fk R
positionid BIGINT 19 √ null
pos.id compreco_pos2_fk R
organisationid BIGINT 19 √ null
org.id compreco_org2_fk R
assessorid BIGINT 19 √ null
user.id compreco_ass2_fk R
assessorname VARCHAR 100 √ null
assessmenttype VARCHAR 100 √ null
proficiency BIGINT 19 √ null
comp_scale_values.id 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

Close relationships within degrees of separation