ad_printtableformat

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_printtableformat_id numeric 10 null
ad_printformat.ad_printtableformat_id adprintformattable_format R
rv_printformatdetail.ad_printtableformat_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
hdr_printfont_id numeric 10 √ null
ad_printfont.ad_printfont_id adprintfont_tablehdr R
hdrtextfg_printcolor_id numeric 10 √ null
ad_printcolor.ad_printcolor_id adprintcolor_tablehdrtextfg R
hdrtextbg_printcolor_id numeric 10 √ null
ad_printcolor.ad_printcolor_id adprintcolor_tablehdrtextbg R
hdrline_printcolor_id numeric 10 √ null
ad_printcolor.ad_printcolor_id adprintcolor_tablehdrline R
funct_printfont_id numeric 10 √ null
ad_printfont.ad_printfont_id adprintfont_tableformatfunc R
functbg_printcolor_id numeric 10 √ null
ad_printcolor.ad_printcolor_id adprintcolor_tablefunctbg R
functfg_printcolor_id numeric 10 √ null
ad_printcolor.ad_printcolor_id adprintcolor_tablefunctfg R
line_printcolor_id numeric 10 √ null
ad_printcolor.ad_printcolor_id adprintcolor_tableline R
description varchar 255 √ null
ispaintboundarylines bpchar 1 'N'::bpchar
ispainthlines bpchar 1 'N'::bpchar
ispaintvlines bpchar 1 'N'::bpchar
isprintfunctionsymbols bpchar 1 'Y'::bpchar
name varchar 60 null
isdefault bpchar 1 'N'::bpchar
imageurl varchar 120 √ null
headerleft varchar 255 √ null
headercenter varchar 255 √ null
headerright varchar 255 √ null
footerleft varchar 255 √ null
footercenter varchar 255 √ null
footerright varchar 255 √ null
imageisattached bpchar 1 √ 'N'::bpchar
hdrstroke numeric 0 √ null
linestroke numeric 0 √ null
hdrstroketype bpchar 1 √ null
linestroketype bpchar 1 √ null
ispaintheaderlines bpchar 1 'Y'::bpchar
ad_image_id numeric 10 √ null
ad_image.ad_image_id adimage_adprinttableformat R
ismultilineheader bpchar 1 'N'::bpchar
ad_printtableformat_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_printtableformat_pkey Primary key Asc ad_printtableformat_id
ad_printtableformat_uu_idx Must be unique Asc ad_printtableformat_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation