Dp Plan Evidence Relation table / dp_plan_evidence_relation - Totara Learn 11 Database schema / Zoola Analytics

dp_plan_evidence_relation table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

evidenceid

BIGINT

19

null

dp_plan_evidence.id

dpplanevidrela_evi2_fk R

Evidence ID from dp_plan_evidence

planid

BIGINT

19

null

dp_plan.id

dpplanevidrela_pla2_fk R

Plan ID from dp_plan

component

VARCHAR

255

component name - competency, objective, course

itemid

BIGINT

19

null

Component ID

Showing 1 to 5 of 5 entries

Table contained -1 rows

dp_plan_evidence_relation table indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
dpplanevidrela_evi_ix	Performance	Asc	evidenceid
dpplanevidrela_pla_ix	Performance	Asc	planid
dpplanevidrela_placomite_ix	Performance	Asc/Asc/Asc	planid + component + itemid

Showing 1 to 4 of 4 entries

dp_plan_evidence_relation table relationships

Close relationships within degrees of separation

One
Two degrees

Dp Plan Evidence Relation Table Schema (dp_plan_evidence_relation)

Description

dp_plan_evidence_relation table columns

dp_plan_evidence_relation table indexes

dp_plan_evidence_relation table relationships

Close relationships within degrees of separation