ad_printformatitem

19392 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_printformatitem_id numeric 10 null
ad_printformatitem_trl.ad_printformatitem_id adprintformatitem_trl C
ad_printgraph.data1_printformatitem_id adprintformatitem_graphdata1 R
ad_printgraph.data2_printformatitem_id adprintformatitem_graphdata2 R
ad_printgraph.data3_printformatitem_id adprintformatitem_graphdata3 R
ad_printgraph.data4_printformatitem_id adprintformatitem_graphdata4 R
ad_printgraph.data_printformatitem_id adprintformatitem_graphdata R
ad_printgraph.description_printformatitem_id adprintformatitem_graphdescr R
rv_printformatdetail.ad_printformatitem_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
ad_printformat_id numeric 10 null
ad_printformat.ad_printformat_id adprintformat_printformatitem C
name varchar 60 null
printname varchar 2000 √ null
isprinted bpchar 1 'Y'::bpchar
printareatype bpchar 1 null
seqno numeric 10 null
printformattype bpchar 1 null
ad_column_id numeric 10 √ null
ad_column.ad_column_id adcolumn_adprintformatitem R
ad_printformatchild_id numeric 10 √ null
ad_printformat.ad_printformat_id adprintformat_printformatchild N
isrelativeposition bpchar 1 'Y'::bpchar
isnextline bpchar 1 'Y'::bpchar
xspace numeric 10 null
yspace numeric 10 null
xposition numeric 10 null
yposition numeric 10 null
maxwidth numeric 10 null
isheightoneline bpchar 1 'Y'::bpchar
maxheight numeric 10 null
fieldalignmenttype bpchar 1 null
linealignmenttype bpchar 1 null
ad_printcolor_id numeric 10 √ null
ad_printcolor.ad_printcolor_id adprintcolor_adprintformatitem R
ad_printfont_id numeric 10 √ null
ad_printfont.ad_printfont_id adprintfont_adprintformatitem R
isorderby bpchar 1 'N'::bpchar
sortno numeric 10 null
isgroupby bpchar 1 'N'::bpchar
ispagebreak bpchar 1 'N'::bpchar
issummarized bpchar 1 'N'::bpchar
imageisattached bpchar 1 'N'::bpchar
imageurl varchar 120 √ null
isaveraged bpchar 1 'N'::bpchar
iscounted bpchar 1 'N'::bpchar
issetnlposition bpchar 1 'N'::bpchar
issuppressnull bpchar 1 'N'::bpchar
belowcolumn numeric 10 √ null
ad_printgraph_id numeric 10 √ null
ad_printgraph.ad_printgraph_id adprintgraph_printformatitem R
isfixedwidth bpchar 1 'N'::bpchar
isnextpage bpchar 1 'N'::bpchar
printnamesuffix varchar 60 √ null
ismincalc bpchar 1 'N'::bpchar
ismaxcalc bpchar 1 'N'::bpchar
isrunningtotal bpchar 1 'N'::bpchar
runningtotallines numeric 10 √ null
isvariancecalc bpchar 1 'N'::bpchar
isdeviationcalc bpchar 1 'N'::bpchar
isfilledrectangle bpchar 1 'N'::bpchar
linewidth numeric 10 √ null
arcdiameter numeric 10 √ null
shapetype bpchar 1 √ null
iscentrallymaintained bpchar 1 'Y'::bpchar
isimagefield bpchar 1 'N'::bpchar
barcodetype bpchar 3 √ null
formatpattern varchar 60 √ null
issuppressrepeats bpchar 1 'N'::bpchar
ad_printformatitem_uu varchar 36 √ NULL::character varying
isdesc bpchar 1 'N'::bpchar
isprintbarcodetext bpchar 1 'Y'::bpchar
displaylogic varchar 2000 √ NULL::character varying
script varchar 2000 √ NULL::character varying
isprintinstanceattributes bpchar 1 'N'::bpchar
ad_fieldstyle_id numeric 10 √ NULL::numeric
ad_style.ad_style_id adfieldstyle_adprintformatitem R

Indexes

Constraint Name Type Sort Column(s)
ad_printformatitem_pkey Primary key Asc ad_printformatitem_id
ad_printformatitem_format Performance Asc ad_printformat_id
ad_printformatitem_uu_idx Must be unique Asc ad_printformatitem_uu

Check Constraints

Constraint Name Constraint
ad_printformatitem_issummarized_check ((issummarized = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformatitem_ispagebreak_check ((ispagebreak = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformatitem_isgroupby_check ((isgroupby = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformatitem_isprintbarcodetext_check ((isprintbarcodetext = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformatitem_isprinted_check ((isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformatitem_isrelativeposition_check ((isrelativeposition = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformatitem_isheightoneline_check ((isheightoneline = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformatitem_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformatitem_isprintinstanceattributes_check ((isprintinstanceattributes = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformatitem_isnextline_check ((isnextline = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformatitem_isorderby_check ((isorderby = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformatitem_issuppressrepeats_check ((issuppressrepeats = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_printformatitem_isdesc_check ((isdesc = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation