dp_plan_evidence_relation table columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| evidenceid | BIGINT | 19 | null |
|
|
Evidence ID from dp_plan_evidence |
||||
| planid | BIGINT | 19 | null |
|
|
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
Close relationships within degrees of separation
