app_org_competencies

0 rows


Description

Track competencies assigned to a particular organisation

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_org_competencies_id_seq'::regclass)
organisationid int8 19 null
app_org.id Defined in XMLR
competencyid int8 19 null
app_comp.id Defined in XMLR
templateid int8 19 null
timecreated int8 19 null
usermodified int8 19 null
linktype int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_orgcomp_id_pk Primary key Asc id
app_orgcomp_com_ix Performance Asc competencyid
app_orgcomp_org_ix Performance Asc organisationid

Relationships