ad_printcolor

23 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_printcolor_id numeric 10 null
ad_orgtype.ad_printcolor_id adprintcolor_adorgtype R
ad_printcolor_trl.ad_printcolor_id adprintcolor_adprintcolortrl C
ad_printformat.ad_printcolor_id adprintcolor_adprintformat R
ad_printformatitem.ad_printcolor_id adprintcolor_adprintformatitem R
ad_printtableformat.functbg_printcolor_id adprintcolor_tablefunctbg R
ad_printtableformat.functfg_printcolor_id adprintcolor_tablefunctfg R
ad_printtableformat.hdrline_printcolor_id adprintcolor_tablehdrline R
ad_printtableformat.hdrtextbg_printcolor_id adprintcolor_tablehdrtextbg R
ad_printtableformat.hdrtextfg_printcolor_id adprintcolor_tablehdrtextfg R
ad_printtableformat.line_printcolor_id adprintcolor_tableline R
c_bp_group.ad_printcolor_id adprintcolor_cbpgroup R
c_channel.ad_printcolor_id adprintcolor_cchannel R
c_poskey.ad_printcolor_id adprintcolor_cposkey R
c_poskeylayout.ad_printcolor_id adprintcolor_cposkeylayout R
m_product_category.ad_printcolor_id adprintcolor_mproductcategory R
pa_colorschema.ad_printcolor1_id adprintcolor1_pacolorschema R
pa_colorschema.ad_printcolor2_id adprintcolor2_pacolorschema R
pa_colorschema.ad_printcolor3_id adprintcolor3_pacolorschema R
pa_colorschema.ad_printcolor4_id adprintcolor4_pacolorschema R
pa_documentstatus.name_printcolor_id nameprintcolor_padocumentstatu R
pa_documentstatus.number_printcolor_id numberprintcolor_padocumentsta R
rv_printformatdetail.ad_printcolor_id Implied Constraint R
rv_printformatdetail.default_ad_printcolor_id Implied Constraint 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
isdefault bpchar 1 'N'::bpchar
code varchar 2000 null
ad_printcolor_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_printcolor_pkey Primary key Asc ad_printcolor_id
ad_printcolor_name Must be unique Asc/Asc ad_client_id + name
ad_printcolor_uu_idx Must be unique Asc ad_printcolor_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation