ad_style

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_style_id numeric 10 null
ad_field.ad_fieldstyle_id adfieldstyle_adfield R
ad_field.ad_labelstyle_id adlabelstyle_adfield R
ad_infocolumn.ad_fieldstyle_id adfieldstyle_adinfocolumn R
ad_label.ad_labelstyle_id adlabelstyle_adlabel R
ad_labelcategory.ad_labelstyle_id adlabelstyle_clabelcategory R
ad_printformatitem.ad_fieldstyle_id adfieldstyle_adprintformatitem R
ad_styleline.ad_style_id adstyle_adstyleline R
ad_userdef_field.ad_fieldstyle_id adfieldstyle_aduserdeffield R
ad_userdef_field.ad_labelstyle_id adlabelstyle_aduserdeffield R
ad_userdef_info_column.ad_fieldstyle_id adfieldstyle_aduserdefinfocolu R
ad_style_uu varchar 36 null
created timestamp 29,6 √ statement_timestamp()
createdby numeric 10 null
description varchar 255 √ NULL::character varying
isactive bpchar 1 'Y'::bpchar
name varchar 60 null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
entitytype varchar 40 'U'::character varying
ad_entitytype.entitytype entitytype_adstyle R

Indexes

Constraint Name Type Sort Column(s)
ad_style_key Primary key Asc ad_style_id
ad_style_uu_idx Must be unique Asc ad_style_uu

Check Constraints

Constraint Name Constraint
ad_style_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation