Table erp.COMPIERE.AD_CLIENT

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_CLIENT_ID number 10 AD_CLIENTINFO AD_CLIENT_ID ADCLIENT_ADCLIENTINFO AD_CLIENTSHARE AD_CLIENT_ID ADCLIENT_ADCLIENTSHARE AD_COLUMN AD_CLIENT_ID COLUMNCLIENT AD_FIELD AD_CLIENT_ID FIELDCLIENT AD_LANGUAGE AD_CLIENT_ID LANGUAGECLIENT AD_MENU AD_CLIENT_ID ADCLIENT_ADMENU AD_MESSAGE AD_CLIENT_ID MESSAGECLIENT AD_ORG AD_CLIENT_ID ADCLIENT_ADORG AD_PREFERENCE AD_CLIENT_ID AD_PREFERENCE_CLIENT AD_PRINTFORM AD_CLIENT_ID ADCLIENT_ADPRINTFORM AD_PROCESS_ACCESS AD_CLIENT_ID AD_PROCESSACCESS_CLIENT AD_REFERENCE AD_CLIENT_ID REFERENCECLIENT AD_REF_LIST AD_CLIENT_ID AD_REFLIST_CLIENT AD_REF_TABLE AD_CLIENT_ID REF_TABLECLIENT AD_ROLE AD_CLIENT_ID AD_ROLECLIENT AD_SEQUENCE AD_CLIENT_ID SEQUENCECLIENT AD_SEQUENCE_AUDIT AD_CLIENT_ID SEQUENCE_AUDITCLIENT AD_SEQUENCE_NO AD_CLIENT_ID SEQUENCE_NOCLIENT AD_TAB AD_CLIENT_ID TABCLIENT AD_TABLE AD_CLIENT_ID TABLECLIENT AD_TABLE_ACCESS AD_CLIENT_ID AD_DATAACCESSCLIENT AD_TASK AD_CLIENT_ID TASKCLIENT AD_TASKINSTANCE AD_CLIENT_ID TASKINSTANCECLIENT AD_TASK_ACCESS AD_CLIENT_ID AD_TASKACCESS_CLIENT AD_USER AD_CLIENT_ID AD_USER_CLIENT AD_USER_ROLES AD_CLIENT_ID AD_USERROLESCLIENT AD_VAL_RULE AD_CLIENT_ID VAL_RULECLIENT AD_WF_NODE AD_CLIENT_ID WF_NODECLIENT AD_WF_NODENEXT AD_CLIENT_ID WF_NODENEXTCLIENT AD_WF_PROCESS AD_CLIENT_ID WF_INSTANCECLIENT AD_WINDOW AD_CLIENT_ID WINDOWCLIENT AD_WINDOW_ACCESS AD_CLIENT_ID AD_FUNCTACCESS_CLIENT AD_WORKFLOW AD_CLIENT_ID WORKFLOWCLIENT AD_WORKFLOW_ACCESS AD_CLIENT_ID AD_WORKFLOWACCESS_CLIENT C_ACCTSCHEMA AD_CLIENT_ID AD_CLIENT_C_ACCTSCHEMA C_ACCTSCHEMA_ELEMENT AD_CLIENT_ID ADCLIENT_CASCHEMAELEMENT C_BPARTNER AD_CLIENT_ID ADCLIENT_CBPARTNER C_BPARTNER_LOCATION AD_CLIENT_ID C_BUSPARTNER_LOCATIONCLIENT C_CALENDAR AD_CLIENT_ID C_CALENDARCLIENT C_CITY AD_CLIENT_ID C_CITYCLIENT C_CONVERSION_RATE AD_CLIENT_ID C_CONVERSION_RATECLIENT C_COUNTRY AD_CLIENT_ID C_COUNTRYCLIENT C_CURRENCY AD_CLIENT_ID C_CURRENCYCLIENT C_ELEMENT AD_CLIENT_ID ADCLIENT_CELEMENT C_ELEMENTVALUE AD_CLIENT_ID ADCLIENT_CELEMENTVALUE C_LOCATION AD_CLIENT_ID ADCLIENT_CLOCATION C_NONBUSINESSDAY AD_CLIENT_ID C_NONBUSINESDAYSCLIENT C_PERIOD AD_CLIENT_ID C_PERIODCLIENT C_PROJECT AD_CLIENT_ID ADCLIENT_CPROJECT C_REGION AD_CLIENT_ID C_REGIONCLIENT C_UOM AD_CLIENT_ID C_UOMCLIENT C_UOM_CONVERSION AD_CLIENT_ID C_UOM_CONVERSIONCLIENT C_VALIDCOMBINATION AD_CLIENT_ID ADCLIENT_VC C_YEAR AD_CLIENT_ID C_YEARCLIENT FACT_ACCT AD_CLIENT_ID AC_CLIENT_FACT_ACCT FACT_ACCT_BALANCE AD_CLIENT_ID ADCLIENT_FACTACCTBAL GL_JOURNALLINE AD_CLIENT_ID ADCLIENT_GLJOURNALLINE M_COST AD_CLIENT_ID ADCLIENT_MCOST M_COSTDETAIL AD_CLIENT_ID ADCLIENT_MCOSTDETAIL M_LOCATOR AD_CLIENT_ID M_WH_LOCATOR_CLIENT M_PRODUCT AD_CLIENT_ID ADCLIENT_MPRODUCT M_PRODUCT_PO AD_CLIENT_ID M_PRODUCTPO_CLIENT M_STORAGE AD_CLIENT_ID M_ITEM_STORAGE_CLIENT M_SUBSTITUTE AD_CLIENT_ID M_SUBSTITUTE_CLIENT M_WAREHOUSE AD_CLIENT_ID M_WAREHOUSE_CLIENT W_STORE AD_CLIENT_ID ADCLIENT_WSTORE 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 VALUE nvarchar2 80 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null SMTPHOST nvarchar2 120  √  null REQUESTEMAIL nvarchar2 120  √  null REQUESTUSER nvarchar2 120  √  null REQUESTUSERPW nvarchar2 40  √  null REQUESTFOLDER nvarchar2 40  √  null AD_LANGUAGE varchar2 6  √  null AD_LANGUAGE AD_LANGUAGE Implied Constraint ISMULTILINGUALDOCUMENT char 1 'N' ISSMTPAUTHORIZATION char 1 'N' ISUSEBETAFUNCTIONS char 1 'N' LDAPQUERY nvarchar2 510  √  null MODELVALIDATIONCLASSES nvarchar2 510  √  null AUTOARCHIVE char 1 'N' MMPOLICY char 1 'F' EMAILTEST char 1  √  null ISSERVEREMAIL char 1 'N' DOCUMENTDIR nvarchar2 120  √  null ISPOSTIMMEDIATE char 1 'N' ISCOSTIMMEDIATE char 1 'N' 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.