Dp Evidence Type Table Schema (dp_evidence_type)


Description

Table to store evidence type menu

dp_evidence_type table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
dp_plan_evidence.evidencetypeid dpplanevid_evi2_fk R
name VARCHAR 255
description LONGTEXT 2147483647 √ null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
user.id dpevidtype_use2_fk R
sortorder BIGINT 19 null

Table contained -1 rows

dp_evidence_type table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpevidtype_use_ix Performance Asc usermodified

dp_evidence_type table relationships

Close relationships within degrees of separation