Org Competencies table / org_competencies - Totara Learn 11 Database schema / Zoola Analytics

org_competencies table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

organisationid

BIGINT

19

null

org.id

orgcomp_org2_fk R

competencyid

BIGINT

19

√

null

comp.id

orgcomp_com2_fk R

templateid

BIGINT

19

√

null

timecreated

BIGINT

19

null

usermodified

BIGINT

19

null

linktype

TINYINT

3

0

Showing 1 to 7 of 7 entries

Table contained -1 rows

org_competencies table indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
orgcomp_com_ix	Performance	Asc	competencyid
orgcomp_org_ix	Performance	Asc	organisationid

Showing 1 to 3 of 3 entries

Org Competencies Table Schema (org_competencies)

Description

org_competencies table columns

org_competencies table indexes

org_competencies table relationships

Close relationships within degrees of separation