Table erp.COMPIERE.AD_PRINTFORMATITEM

Generated by SchemaSpy

Implied relationships Related columns Constraint names Legend

Legend: Primary key columns Columns with indexes Implied relationships Excluded column relationships Dashed lines show implied relationships < n > number of related tables Please support this project

Column Type Size Nulls Auto Default Children Parents AD_PRINTFORMATITEM_ID number 10 AD_PRINTFORMATITEM_TRL AD_PRINTFORMATITEM_ID ADPRINTFORMATITEM_TRL AD_PRINTGRAPH DATA1_PRINTFORMATITEM_ID ADPRINTFORMATITEM_GRAPHDATA1 AD_PRINTGRAPH DATA2_PRINTFORMATITEM_ID ADPRINTFORMATITEM_GRAPHDATA2 AD_PRINTGRAPH DATA3_PRINTFORMATITEM_ID ADPRINTFORMATITEM_GRAPHDATA3 AD_PRINTGRAPH DATA4_PRINTFORMATITEM_ID ADPRINTFORMATITEM_GRAPHDATA4 AD_PRINTGRAPH DATA_PRINTFORMATITEM_ID ADPRINTFORMATITEM_GRAPHDATA AD_PRINTGRAPH DESCRIPTION_PRINTFORMATITEM_ID ADPRINTFORMATITEM_GRAPHDESCR RV_PRINTFORMATDETAIL AD_PRINTFORMATITEM_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENTINFO AD_CLIENT_ID Implied Constraint AD_ORG_ID number 10 AD_ORGINFO AD_ORG_ID Implied Constraint ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 AD_PRINTFORMAT_ID number 10 AD_PRINTFORMAT AD_PRINTFORMAT_ID ADPRINTFORMAT_PRINTFORMATITEM NAME nvarchar2 120 PRINTNAME nvarchar2 4000  √  null ISPRINTED char 1 'Y' PRINTAREATYPE char 1 SEQNO number 10 PRINTFORMATTYPE char 1 AD_COLUMN_ID number 10  √  null AD_COLUMN AD_COLUMN_ID ADCOLUMN_ADPRINTFORMATITEM AD_PRINTFORMATCHILD_ID number 10  √  null AD_PRINTFORMAT AD_PRINTFORMAT_ID ADPRINTFORMAT_PRINTFORMATCHILD ISRELATIVEPOSITION char 1 'Y' ISNEXTLINE char 1 'Y' XSPACE number 10 YSPACE number 10 XPOSITION number 10 YPOSITION number 10 MAXWIDTH number 10 ISHEIGHTONELINE char 1 'Y' MAXHEIGHT number 10 FIELDALIGNMENTTYPE char 1 LINEALIGNMENTTYPE char 1 AD_PRINTCOLOR_ID number 10  √  null AD_PRINTCOLOR AD_PRINTCOLOR_ID ADPRINTCOLOR_ADPRINTFORMATITEM AD_PRINTFONT_ID number 10  √  null AD_PRINTFONT AD_PRINTFONT_ID ADPRINTFONT_ADPRINTFORMATITEM ISORDERBY char 1 'N' SORTNO number 10 ISGROUPBY char 1 'N' ISPAGEBREAK char 1 'N' ISSUMMARIZED char 1 'N' IMAGEISATTACHED char 1 'N' IMAGEURL nvarchar2 240  √  null ISAVERAGED char 1 'N' ISCOUNTED char 1 'N' ISSETNLPOSITION char 1 'N' ISSUPPRESSNULL char 1 'N' BELOWCOLUMN number 10  √  null AD_PRINTGRAPH_ID number 10  √  null AD_PRINTGRAPH AD_PRINTGRAPH_ID ADPRINTGRAPH_PRINTFORMATITEM ISFIXEDWIDTH char 1 'N' ISNEXTPAGE char 1 'N' PRINTNAMESUFFIX nvarchar2 120  √  null ISMINCALC char 1 'N' ISMAXCALC char 1 'N' ISRUNNINGTOTAL char 1 'N' RUNNINGTOTALLINES number 10  √  null ISVARIANCECALC char 1 'N' ISDEVIATIONCALC char 1 'N' ISFILLEDRECTANGLE char 1 'N' LINEWIDTH number 10  √  null ARCDIAMETER number 10  √  null SHAPETYPE char 1  √  null ISCENTRALLYMAINTAINED char 1 'Y' ISIMAGEFIELD char 1 'N' Table contained 1,283 rows at Wed Mar 15 18:14 SAST 2006

SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.