ad_infocolumn

903 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_infocolumn_id numeric 10 null
ad_infocolumn_backup.ad_infocolumn_id Implied Constraint R
ad_infocolumn_trl.ad_infocolumn_id adinfocolumn_adinfocolumntrl C
ad_infoprocess.ad_infocolumn_id adinfocolumn_adinfoprocess R
ad_inforelated.parentrelatedcolumn_id parentrelatedcolumn_adinforela R
ad_inforelated.relatedcolumn_id relatedcolumn_adinforelated R
ad_userdef_info_column.ad_infocolumn_id adinfocolumn_aduserdefinfocolu R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
ad_infowindow_id numeric 10 null
ad_infowindow.ad_infowindow_id adinfowindow_adinfocolumn C
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adinfocolumn R
selectclause varchar 2000 null
seqno numeric 10 0
isdisplayed bpchar 1 'Y'::bpchar
isquerycriteria bpchar 1 'N'::bpchar
ad_element_id numeric 10 √ null
ad_element.ad_element_id adelement_adinfocolumn R
ad_reference_id numeric 10 null
ad_reference.ad_reference_id adreference_adinfocolumn R
ad_infocolumn_uu varchar 36 √ NULL::character varying
ad_reference_value_id numeric 10 √ NULL::numeric
ad_reference.ad_reference_id adreferencevalue_adinfocolumn R
ad_val_rule_id numeric 10 √ NULL::numeric
ad_val_rule.ad_val_rule_id advalrule_adinfocolumn R
iscentrallymaintained bpchar 1 'Y'::bpchar
displaylogic varchar 2000 √ NULL::character varying
columnname varchar 40 null
queryoperator varchar 10 √ NULL::character varying
queryfunction varchar 255 √ NULL::character varying
isidentifier bpchar 1 'N'::bpchar
seqnoselection numeric 10 √ (0)::numeric
defaultvalue varchar 2000 √ NULL::character varying
ismandatory bpchar 1 'N'::bpchar
cof_multicolumnsearch varchar 2000 √ null
iskey bpchar 1 √ NULL::bpchar
isreadonly bpchar 1 'Y'::bpchar
placeholder varchar 255 √ NULL::character varying
issummarized bpchar 1 'N'::bpchar
inputfieldvalidation varchar 2000 √ NULL::character varying
cof_parameterfunction varchar 200 √ NULL::character varying
ad_fieldstyle_id numeric 10 √ NULL::numeric
ad_style.ad_style_id adfieldstyle_adinfocolumn R
isautocomplete bpchar 1 'N'::bpchar
isqueryafterchange bpchar 1 'N'::bpchar
isrange bpchar 1 'N'::bpchar
defaultvalue2 varchar 2000 √ NULL::character varying
placeholder2 varchar 255 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_infocolumn_pkey Primary key Asc ad_infocolumn_id
ad_infocolumn_uu_idx Must be unique Asc ad_infocolumn_uu

Check Constraints

Constraint Name Constraint
ad_infocolumn_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infocolumn_ismandatory_check ((ismandatory = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infocolumn_isqueryafterchange_check ((isqueryafterchange = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infocolumn_isdisplayed_check ((isdisplayed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infocolumn_isquerycriteria_check ((isquerycriteria = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infocolumn_issummarized_check ((issummarized = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infocolumn_isidentifier_check ((isidentifier = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infocolumn_isautocomplete_check ((isautocomplete = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infocolumn_iscentrallymaintained_check ((iscentrallymaintained = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infocolumn_iskey_check ((iskey = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infocolumn_isreadonly_check ((isreadonly = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_infocolumn_isrange_check ((isrange = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation