ad_statuslineusedin

41 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_statuslineusedin_id numeric 10 null
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_adstatuslineusedin R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_adstatuslineusedin R
ad_statuslineusedin_uu varchar 36 √ NULL::character varying
ad_statusline_id numeric 10 null
ad_statusline.ad_statusline_id adstatusline_adstatuslineusedi R
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_adstatuslineusedin R
isactive bpchar 1 'Y'::bpchar
updated timestamp 29,6 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_adstatuslineusedin R
ad_window_id numeric 10 √ NULL::numeric
ad_window.ad_window_id adwindow_adstatuslineusedin R
ad_tab_id numeric 10 √ NULL::numeric
ad_tab.ad_tab_id adtab_adstatuslineusedin R
isstatusline bpchar 1 'Y'::bpchar
seqno numeric 10 √ NULL::numeric
ad_table_id numeric 10 √ NULL::numeric
ad_table.ad_table_id adtable_adstatuslineusedin R
entitytype varchar 40 √ 'U'::character varying
ad_entitytype.entitytype entitytype_adstatuslineusedin R

Indexes

Constraint Name Type Sort Column(s)
ad_statuslineusedin_key Primary key Asc ad_statuslineusedin_id
ad_statuslineusedin_uu_idx Must be unique Asc ad_statuslineusedin_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation