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 0 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