Table almasdd.COMPIERE.AD_PRINTCOLOR

Generated by
SchemaSpy
Implied relationships Related columns Constraint names Legend
Legend: SourceForge.net
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_PRINTCOLOR_ID number 10
AD_ORGTYPE AD_PRINTCOLOR_ID Implied Constraint
AD_PRINTFORMAT AD_PRINTCOLOR_ID ADPRINTCOLOR_ADPRINTFORMAT
AD_PRINTFORMATITEM AD_PRINTCOLOR_ID ADPRINTCOLOR_ADPRINTFORMATITEM
AD_PRINTTABLEFORMAT FUNCTBG_PRINTCOLOR_ID ADPRINTCOLOR_TABLEFUNCTBG
AD_PRINTTABLEFORMAT FUNCTFG_PRINTCOLOR_ID ADPRINTCOLOR_TABLEFUNCTFG
AD_PRINTTABLEFORMAT HDRLINE_PRINTCOLOR_ID ADPRINTCOLOR_TABLEHDRLINE
AD_PRINTTABLEFORMAT HDRTEXTBG_PRINTCOLOR_ID ADPRINTCOLOR_TABLEHDRTEXTBG
AD_PRINTTABLEFORMAT HDRTEXTFG_PRINTCOLOR_ID ADPRINTCOLOR_TABLEHDRTEXTFG
AD_PRINTTABLEFORMAT LINE_PRINTCOLOR_ID ADPRINTCOLOR_TABLELINE
C_BP_GROUP AD_PRINTCOLOR_ID Implied Constraint
C_CHANNEL AD_PRINTCOLOR_ID Implied Constraint
C_POSKEY AD_PRINTCOLOR_ID Implied Constraint
M_PRODUCT_CATEGORY AD_PRINTCOLOR_ID Implied Constraint
PA_COLORSCHEMA AD_PRINTCOLOR1_ID ADPRINTCOLOR1_PACOLORSCHEMA
PA_COLORSCHEMA AD_PRINTCOLOR2_ID ADPRINTCOLOR2_PACOLORSCHEMA
PA_COLORSCHEMA AD_PRINTCOLOR3_ID ADPRINTCOLOR3_PACOLORSCHEMA
PA_COLORSCHEMA AD_PRINTCOLOR4_ID ADPRINTCOLOR4_PACOLORSCHEMA
RV_PRINTFORMATDETAIL AD_PRINTCOLOR_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
NAME nvarchar2 120
ISDEFAULT char 1 'N'
CODE nvarchar2 4000

Table contained 20 rows at ‰Î 3 07 12:14 JST 2006

Indexes:
Column(s) Type Sort Constraint Name
AD_PRINTCOLOR_ID Primary key Asc AD_PRINTCOLOR_KEY
AD_CLIENT_ID + NAME Must be unique Asc/Asc AD_PRINTCOLOR_NAME


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.