Dp Plan Evidence Table Schema (dp_plan_evidence)


Description

Contains user evidence in the record of learning

dp_plan_evidence table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
dp_plan_evidence_info_data.evidenceid dpplanevidinfodata_evi2_fk R
dp_plan_evidence_relation.evidenceid dpplanevidrela_evi2_fk R
name VARCHAR 255

Name for this item of evidence
timecreated BIGINT 19 √ null

Timestamp indicating when this evidence item was created
timemodified BIGINT 19 √ null

Timestamp indicating when this evidence item was last modified
usermodified BIGINT 19 √ null
user.id dpplanevid_use3_fk R

Identifies the user who last modified this item of evidence
evidencetypeid BIGINT 19 √ null
dp_evidence_type.id dpplanevid_evi2_fk R

Integer representing the type of this evidence item
userid BIGINT 19 √ null
user.id dpplanevid_use4_fk R

User whose evidence this is
readonly BIT 1 0

Table contained -1 rows

dp_plan_evidence table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpplanevid_evi_ix Performance Asc evidencetypeid
dpplanevid_use2_ix Performance Asc userid
dpplanevid_use_ix Performance Asc usermodified

dp_plan_evidence table relationships

Close relationships within degrees of separation