Table almasdd.COMPIERE.AD_REF_TABLE

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_REFERENCE_ID number 10 AD_FIELD_V AD_REFERENCE_ID Implied Constraint AD_FIELD_VT AD_REFERENCE_ID Implied Constraint AD_REFERENCE AD_REFERENCE_ID AD_REFERENCE_REFTABLE AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID REF_TABLECLIENT AD_ORG_ID number 10 AD_ORG AD_ORG_ID REF_TABLEORG ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 AD_TABLE_ID number 10 AD_TABLE AD_TABLE_ID ADD_TABLE_REFTABLE AD_KEY number 10 AD_COLUMN AD_COLUMN_ID AD_COLUMN_REFTABLE_ID AD_DISPLAY number 10 AD_COLUMN AD_COLUMN_ID AD_COLUMN_REFTABLE_DISPLAY ISVALUEDISPLAYED char 1 'N' WHERECLAUSE nvarchar2 4000  √  null ORDERBYCLAUSE nvarchar2 4000  √  null ENTITYTYPE varchar2 4 'D' Table contained 113 rows at ‰Î 3 07 12:14 JST 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.