app_dp_plan_evidence

0 rows


Description

Contains user evidence in the record of learning

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_dp_plan_evidence_id_seq'::regclass)
app_dp_plan_evidence_relation.evidenceid Defined in XMLR
name varchar 255 ''::character varying
description text 2147483647 √ null
timecreated int8 19 √ null
timemodified int8 19 √ null
usermodified int8 19 √ null
app_user.id Defined in XMLR
evidencetypeid int8 19 √ null
app_dp_evidence_type.id Defined in XMLR
evidencelink varchar 255 √ null
institution varchar 255 √ null
datecompleted int8 19 √ null
userid int8 19 √ null
app_user.id Defined in XMLR
readonly int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_dpplanevid_id_pk Primary key Asc id
app_dpplanevid_evi_ix Performance Asc evidencetypeid
app_dpplanevid_use2_ix Performance Asc userid
app_dpplanevid_use_ix Performance Asc usermodified

Relationships

Close relationships within degrees of separation