app_prog_info_data

0 rows


Description

Stores custom field data related to programs

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_prog_info_data_id_seq'::regclass)
app_prog_info_data_param.dataid Defined in XML R
data text 2147483647 √ null
fieldid int8 19 null
app_prog_info_field.id Defined in XML R
programid int8 19 null
app_prog.id Defined in XML R

Indexes

Constraint Name Type Sort Column(s)
app_proginfodata_id_pk Primary key Asc id
app_proginfodata_fie_ix Performance Asc fieldid
app_proginfodata_fiepro_uix Must be unique Asc/Asc fieldid + programid
app_proginfodata_pro_ix Performance Asc programid

Relationships

Close relationships within degrees of separation