Dp Plan Evidence Info Data Table Schema (dp_plan_evidence_info_data)


Description

Stores custom field data related to evidence

dp_plan_evidence_info_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
dp_plan_evidence_info_data_param.dataid dpplanevidinfodatapara_dat2_fk R
fieldid BIGINT 19 null
dp_plan_evidence_info_field.id dpplanevidinfodata_fie2_fk R
evidenceid BIGINT 19 null
dp_plan_evidence.id dpplanevidinfodata_evi2_fk R
data LONGTEXT 2147483647 √ null

Table contained -1 rows

dp_plan_evidence_info_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpplanevidinfodata_evi_ix Performance Asc evidenceid
dpplanevidinfodata_fie_ix Performance Asc fieldid
dpplanevidinfodata_fieevi_uix Must be unique Asc/Asc fieldid + evidenceid

dp_plan_evidence_info_data table relationships

Close relationships within degrees of separation