app_dp_plan_evidence_info_data

0 rows


Description

Stores custom field data related to evidence

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_dp_plan_evidence_info_data_id_seq'::regclass)
app_dp_plan_evidence_info_data_param.dataid Defined in XMLR
fieldid int8 19 null
app_dp_plan_evidence_info_field.id Defined in XMLR
evidenceid int8 19 null
app_dp_plan_evidence.id Defined in XMLR
data text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
app_dpplanevidinfodata_id_pk Primary key Asc id
app_dpplanevidinfodata_evi_ix Performance Asc evidenceid
app_dpplanevidinfodata_fie_ix Performance Asc fieldid
app_dpplanevidinfodata_fie_uix Must be unique Asc/Asc fieldid + evidenceid

Relationships

Close relationships within degrees of separation