app_dp_plan_competency_value

0 rows


Description

Competency values set via the learning plan

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_dp_plan_competency_value_id_seq'::regclass)
competency_id int8 19 null
app_comp.id Defined in XML R
user_id int8 19 null
app_user.id Defined in XML R
scale_value_id int8 19 √ null
app_comp_scale_values.id Defined in XML R
date_assigned int8 19 null
positionid int8 19 √ null
app_pos.id Defined in XML R
organisationid int8 19 √ null
app_org.id Defined in XML R
assessorid int8 19 √ null
app_user.id Defined in XML R
assessorname varchar 100 √ null
assessmenttype varchar 100 √ null
timeproficient int8 19 √ null
manual int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_dpplancompvalu_id_pk Primary key Asc id
app_dpplancompvalu_ass_ix Performance Asc assessorid
app_dpplancompvalu_com_ix Performance Asc competency_id
app_dpplancompvalu_comuse_uix Must be unique Asc/Asc competency_id + user_id
app_dpplancompvalu_org_ix Performance Asc organisationid
app_dpplancompvalu_pos_ix Performance Asc positionid
app_dpplancompvalu_sca_ix Performance Asc scale_value_id
app_dpplancompvalu_use_ix Performance Asc user_id

Relationships

Close relationships within degrees of separation