Table erp.COMPIERE.AD_COLUMN

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_COLUMN_ID number 10 AD_ACCESSLOG AD_COLUMN_ID ADCOLUMN_ADACCESSLOG AD_CHANGELOG AD_COLUMN_ID ADCOLUMN_ADCHANGELOG AD_COLUMN_ACCESS AD_COLUMN_ID ADCOLUMN_ADCOLUMNACCESS AD_COLUMN_TRL AD_COLUMN_ID ADCOLUMN_ADCOLUMNTRL AD_FIELD AD_COLUMN_ID AD_COLUMN_FIELD AD_FIELD_V AD_COLUMN_ID Implied Constraint AD_FIELD_VT AD_COLUMN_ID Implied Constraint AD_FIND AD_COLUMN_ID ADCOLUMN_ADFIND AD_IMPFORMAT_ROW AD_COLUMN_ID ADCOLUMN_ADIMPFORMATROW AD_PRINTFORMATITEM AD_COLUMN_ID ADCOLUMN_ADPRINTFORMATITEM AD_PRINTLABELLINE AD_COLUMN_ID ADCOLUMN_ADPRINTLABELLINE AD_REF_TABLE AD_DISPLAY AD_COLUMN_REFTABLE_DISPLAY AD_REF_TABLE AD_KEY AD_COLUMN_REFTABLE_ID AD_REPORTVIEW_COL AD_COLUMN_ID ADCOLUMN_ADREPORTVIEWCOL AD_TAB AD_COLUMNSORTORDER_ID ADCOLUMN_ADTABSORTORDER AD_TAB AD_COLUMNSORTYESNO_ID ADCOLUMN_ADTABSORTYESNO AD_TAB AD_COLUMN_ID AD_COLUMN_AD_TAB AD_TAB_V AD_COLUMN_ID Implied Constraint AD_TAB_VT AD_COLUMN_ID Implied Constraint AD_WF_NEXTCONDITION AD_COLUMN_ID ADCOLUMN_ADWFNEXTCONDITION AD_WF_NODE AD_COLUMN_ID Implied Constraint AD_WORKBENCH AD_COLUMN_ID Implied Constraint C_ACCTSCHEMA_ELEMENT AD_COLUMN_ID Implied Constraint I_ELEMENTVALUE AD_COLUMN_ID ADCOLUMN_IELEMENTVALUE RV_PRINTFORMATDETAIL AD_COLUMN_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID COLUMNCLIENT AD_ORG_ID number 10 AD_ORG AD_ORG_ID COLUMNORG ISACTIVE char 1 'Y' CREATED date 7 now UPDATED date 7 now CREATEDBY number 10 UPDATEDBY number 10 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null HELP nvarchar2 4000  √  null VERSION number 22 ENTITYTYPE varchar2 4 'D' COLUMNNAME varchar2 40 AD_TABLE_ID number 10 AD_TABLE AD_TABLE_ID AD_TABLE_COLUMN AD_REFERENCE_ID number 10 AD_REFERENCE AD_REFERENCE_ID AD_REFERENCE_COLUMNDATATYPE AD_REFERENCE_VALUE_ID number 10  √  null AD_REFERENCE AD_REFERENCE_ID AD_REFERENCE_COLUMNVALUE AD_VAL_RULE_ID number 10  √  null AD_VAL_RULE AD_VAL_RULE_ID AD_VALRULE_COLUMN FIELDLENGTH number 10  √  null DEFAULTVALUE nvarchar2 4000  √  null ISKEY char 1 'N' ISPARENT char 1 'N' ISMANDATORY char 1 'N' ISUPDATEABLE char 1 'Y' READONLYLOGIC nvarchar2 4000  √  null ISIDENTIFIER char 1 'N' SEQNO number 10  √  null ISTRANSLATED char 1 'N' ISENCRYPTED char 1 'N' CALLOUT nvarchar2 510  √  null VFORMAT nvarchar2 120  √  null VALUEMIN nvarchar2 40  √  null VALUEMAX nvarchar2 40  √  null ISSELECTIONCOLUMN char 1 'N' AD_ELEMENT_ID number 10  √  null AD_ELEMENT AD_ELEMENT_ID AD_ELEMENT_AD_COLUMN AD_PROCESS_ID number 10  √  null AD_PROCESS AD_PROCESS_ID ADPROCESS_ADCOLUMN ISSYNCDATABASE char 1  √  'N' ISALWAYSUPDATEABLE char 1 'N' COLUMNSQL nvarchar2 510  √  null Table contained 11,839 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.