Comp Record History Table Schema (comp_record_history)


Description

Store changes to proficiency in comp_record.

comp_record_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 null
user.id comprecohist_use2_fk R
competencyid BIGINT 19 null
comp.id comprecohist_com2_fk R
proficiency BIGINT 19 √ null
comp_scale_values.id comprecohist_pro2_fk R
timeproficient BIGINT 19 √ null
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Table contained -1 rows

comp_record_history table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
comprecohist_com_ix Performance Asc competencyid
comprecohist_pro_ix Performance Asc proficiency
comprecohist_use_ix Performance Asc userid
comprecohist_usecom_ix Performance Asc/Asc userid + competencyid

comp_record_history table relationships

Close relationships within degrees of separation