Dp Plan Evidence Relation Table Schema (dp_plan_evidence_relation)


Description

Related courses / objectives / competencies

dp_plan_evidence_relation table columns

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

Table contained -1 rows

dp_plan_evidence_relation table indexes

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

dp_plan_evidence_relation table relationships