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_evidence_id_seq'::regclass)
userid int8 19 null
competencyid int8 19 null
positionid int8 19 null
organisationid int8 19 null
assessorid int8 19 null
assessorname varchar 100 null
assessmenttype varchar 100 null
proficiency 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_compevid_id_pk Primary key Asc id
app_compevid_com_ix Performance Asc competencyid
app_compevid_man_ix Performance Asc manual
app_compevid_rea_ix Performance Asc reaggregate
app_compevid_use_ix Performance Asc userid
app_compevid_usecom_uix Must be unique Asc/Asc userid + competencyid

Diagram producer might be missing

No diagrams were produced please see application output for any errors