ad_userdef_field

29 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_userdef_field_id numeric 10 null
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
ad_userdef_tab_id numeric 10 null
ad_userdef_tab.ad_userdef_tab_id aduserdeftab_aduserdeffield C
ad_field_id numeric 10 null
ad_field.ad_field_id adfield_aduserdeffield R
name varchar 60 √ null
description varchar 255 √ null
help varchar 2000 √ null
isdisplayed bpchar 1 √ null
isreadonly bpchar 1 √ null
issameline bpchar 1 √ null
isupdateable bpchar 1 √ null
displaylength numeric 10 0
displaylogic varchar 2000 √ null
defaultvalue varchar 2000 √ null
sortno numeric 10 0
seqno numeric 10 (0)::numeric
ad_userdef_field_uu varchar 36 √ NULL::character varying
isalwaysupdateable bpchar 1 √ NULL::bpchar
mandatorylogic varchar 2000 √ NULL::character varying
readonlylogic varchar 2000 √ NULL::character varying
ad_reference_value_id numeric 10 √ NULL::numeric
ad_reference.ad_reference_id adreferencevalue_aduserdeffiel R
ismandatory bpchar 1 √ NULL::bpchar
xposition numeric 10 √ NULL::numeric
numlines numeric 10 √ NULL::numeric
columnspan numeric 10 √ NULL::numeric
istoolbarbutton bpchar 1 √ null
ad_reference_id numeric 10 √ NULL::numeric
ad_reference.ad_reference_id adreference_aduserdeffield R
ad_val_rule_id numeric 10 √ NULL::numeric
ad_val_rule.ad_val_rule_id advalrule_aduserdeffield R
cof_comments varchar 255 √ NULL::character varying
vformat varchar 255 √ NULL::character varying
ad_labelstyle_id numeric 10 √ NULL::numeric
ad_style.ad_style_id adlabelstyle_aduserdeffield R
ad_fieldstyle_id numeric 10 √ NULL::numeric
ad_style.ad_style_id adfieldstyle_aduserdeffield R
pa_dashboardcontent_id numeric 10 √ NULL::numeric
pa_dashboardcontent.pa_dashboardcontent_id padashboardcontent_aduserdeffi R
placeholder varchar 255 √ NULL::character varying
ad_fieldgroup_id numeric 10 √ NULL::numeric
ad_fieldgroup.ad_fieldgroup_id adfieldgroup_aduserdeffield R
ad_val_rule_lookup_id numeric 10 √ NULL::numeric
ad_val_rule.ad_val_rule_id advalrulefind_aduserdeffield R
isautocomplete bpchar 1 √ NULL::bpchar
seqnogrid numeric 10 '0'::numeric
isdisplayedgrid bpchar 1 √ NULL::bpchar
ad_chart_id numeric 10 √ NULL::numeric
ad_chart.ad_chart_id adchart_aduserdeffield R
alwaysupdatablelogic varchar 2000 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_userdef_field_pkey Primary key Asc ad_userdef_field_id
ad_userdef_field_unique Must be unique Asc/Asc ad_userdef_tab_id + ad_field_id
ad_userdef_field_uu_idx Must be unique Asc ad_userdef_field_uu

Check Constraints

Constraint Name Constraint
ad_userdef_field_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_userdef_field_isupdateable_check ((isupdateable = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_userdef_field_isreadonly_check ((isreadonly = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_userdef_field_isdisplayed_check ((isdisplayed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_userdef_field_isautocomplete_check ((isautocomplete = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_userdef_field_issameline_check ((issameline = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation