Table erp.COMPIERE.PA_COLORSCHEMA

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 PA_COLORSCHEMA_ID number 10 PA_GOAL PA_COLORSCHEMA_ID PACOLORSCHEMA_PAGOAL 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 DESCRIPTION nvarchar2 510  √  null MARK1PERCENT number 10 0 AD_PRINTCOLOR1_ID number 10 AD_PRINTCOLOR AD_PRINTCOLOR_ID ADPRINTCOLOR1_PACOLORSCHEMA MARK2PERCENT number 10 0 AD_PRINTCOLOR2_ID number 10 AD_PRINTCOLOR AD_PRINTCOLOR_ID ADPRINTCOLOR2_PACOLORSCHEMA MARK3PERCENT number 10  √  0 AD_PRINTCOLOR3_ID number 10  √  null AD_PRINTCOLOR AD_PRINTCOLOR_ID ADPRINTCOLOR3_PACOLORSCHEMA MARK4PERCENT number 10  √  0 AD_PRINTCOLOR4_ID number 10  √  null AD_PRINTCOLOR AD_PRINTCOLOR_ID ADPRINTCOLOR4_PACOLORSCHEMA Table contained 2 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.