app_comp_record_history

0 rows


Description

Store changes to proficiency in comp_record.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_comp_record_history_id_seq'::regclass)
userid int8 19 null
app_user.id Defined in XMLR
competencyid int8 19 null
app_comp.id Defined in XMLR
proficiency int8 19 √ null
app_comp_scale_values.id Defined in XMLR
timeproficient int8 19 √ null
timemodified int8 19 null
usermodified int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_comprecohist_id_pk Primary key Asc id
app_comprecohist_com_ix Performance Asc competencyid
app_comprecohist_pro_ix Performance Asc proficiency
app_comprecohist_use_ix Performance Asc userid
app_comprecohist_usecom_ix Performance Asc/Asc userid + competencyid

Relationships

Close relationships within degrees of separation