Competency Plancomp table / competency_plancomp - Totara Learn 12 Database schema / Zoola Analytics

competency_plancomp table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

planid

BIGINT

19

null

competencyid

BIGINT

19

null

competency.id

compplan_com_fk R

sortorder

BIGINT

19

√

null

Relative sort order

timecreated

BIGINT

19

null

timemodified

BIGINT

19

√

null

usermodified

BIGINT

19

null

Showing 1 to 7 of 7 entries

Table contained -1 rows

competency_plancomp table indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
compplan_com_fk	Performance	Asc	competencyid
compplan_placom_uix	Must be unique	Asc/Asc	planid + competencyid

Showing 1 to 3 of 3 entries

Competency Plancomp Table Schema (competency_plancomp)

Description

competency_plancomp table columns

competency_plancomp table indexes

competency_plancomp table relationships

Close relationships within degrees of separation