competency_plan

0 rows

Description

Learning plans

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

name

VARCHAR

100

description

LONGTEXT

2147483647

√

null

descriptionformat

SMALLINT

5

0

userid

BIGINT

19

null

Implied ConstraintR

templateid

BIGINT

19

√

null

competency_template.id

competency_plan_erd_competency_templateR

origtemplateid

BIGINT

19

√

null

The template ID this plan was based on originally

status

BIT

1

null

duedate

BIGINT

19

√

0

reviewerid

BIGINT

19

√

null

Showing 1 to 10 of 13 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
compplan_stadue2_ix	Performance	Asc/Asc	status + duedate
compplan_tem2_ix	Performance	Asc	templateid
compplan_usesta2_ix	Performance	Asc/Asc	userid + status

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation