pa_documentstatus

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pa_documentstatus_id numeric 10 null
pa_documentstatus_trl.pa_documentstatus_id padocumentstatus_padocumentstatustrl R
pa_documentstatusaccess.pa_documentstatus_id padocumentstatus_padocstataccs R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
c_project_id numeric 10 √ null
c_project.c_project_id cproject_padocumentstatus R
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
isactive bpchar 1 'Y'::bpchar
seqno numeric 10 null
name_printcolor_id numeric 10 √ null
ad_printcolor.ad_printcolor_id nameprintcolor_padocumentstatu R
name_printfont_id numeric 10 √ null
ad_printfont.ad_printfont_id nameprintfont_padocumentstatus R
number_printcolor_id numeric 10 √ null
ad_printcolor.ad_printcolor_id numberprintcolor_padocumentsta R
number_printfont_id numeric 10 √ null
ad_printfont.ad_printfont_id numberprintfont_padocumentstat R
ad_table_id numeric 10 null
ad_table.ad_table_id adtable_padocumentstatus R
whereclause varchar 2000 √ null
ad_window_id numeric 10 √ null
ad_window.ad_window_id adwindow_padocumentstatus R
ad_form_id numeric 10 √ null
ad_form.ad_form_id adform_padocumentstatus R
pa_documentstatus_uu varchar 36 √ NULL::character varying
entitytype varchar 40 'U'::character varying
ad_entitytype.entitytype entitytype_padocumentstatus R
isshowinlogin bpchar 1 √ 'Y'::bpchar

Indexes

Constraint Name Type Sort Column(s)
pa_documentstatus_key Primary key Asc pa_documentstatus_id
pa_documentstatus_uu_idx Must be unique Asc pa_documentstatus_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation