Table erp.COMPIERE.AD_TAB

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_TAB_ID number 10 AD_FIELD AD_TAB_ID AD_TAB_FIELD AD_FIELD_V AD_TAB_ID Implied Constraint AD_FIELD_VT AD_TAB_ID Implied Constraint AD_TAB INCLUDED_TAB_ID ADTAB_INCLUDED AD_TAB_TRL AD_TAB_ID AD_TABTRL AD_TAB_V AD_TAB_ID Implied Constraint AD_TAB_VT AD_TAB_ID Implied Constraint AD_USERDEF_TAB AD_TAB_ID ADTAB_ADUSERDEFTAB AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID TABCLIENT AD_ORG_ID number 10 AD_ORG AD_ORG_ID TABORG 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 HELP nvarchar2 4000  √  null AD_TABLE_ID number 10 AD_TABLE AD_TABLE_ID AD_TABLE_TAB AD_WINDOW_ID number 10 AD_WINDOW AD_WINDOW_ID AD_WINDOW_TAB SEQNO number 10 TABLEVEL number 10 ISSINGLEROW char 1 'Y' ISINFOTAB char 1  √  'N' ISTRANSLATIONTAB char 1 'N' ISREADONLY char 1 'N' AD_COLUMN_ID number 10  √  null AD_COLUMN AD_COLUMN_ID AD_COLUMN_AD_TAB HASTREE char 1 'N' WHERECLAUSE nvarchar2 4000  √  null ORDERBYCLAUSE nvarchar2 4000  √  null COMMITWARNING nvarchar2 4000  √  null AD_PROCESS_ID number 10  √  null AD_PROCESS AD_PROCESS_ID ADPROCESS_ADTAB PROCESSING char 1  √  null AD_IMAGE_ID number 10  √  null AD_IMAGE AD_IMAGE_ID ADIMAGE_ADTAB IMPORTFIELDS char 1  √  null AD_COLUMNSORTORDER_ID number 10  √  null AD_COLUMN AD_COLUMN_ID ADCOLUMN_ADTABSORTORDER AD_COLUMNSORTYESNO_ID number 10  √  null AD_COLUMN AD_COLUMN_ID ADCOLUMN_ADTABSORTYESNO ISSORTTAB char 1 'N' ENTITYTYPE varchar2 4 'D' INCLUDED_TAB_ID number 10  √  null AD_TAB AD_TAB_ID ADTAB_INCLUDED READONLYLOGIC nvarchar2 4000  √  null DISPLAYLOGIC nvarchar2 4000  √  null ISINSERTRECORD char 1 'Y' ISADVANCEDTAB char 1 'N' Table contained 624 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.