Table erp.COMPIERE.AD_USER

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_USER_ID number 10 AD_ALERTPROCESSOR SUPERVISOR_ID ADUSER_CALERTPROCESSOR AD_ALERTRECIPIENT AD_USER_ID ADUSER_ADALERTRECIPIENT AD_ATTACHMENTNOTE AD_USER_ID ADUSER_ADATTACHMENTNOTE AD_NOTE AD_USER_ID ADUSER_ADNOTE AD_ORGINFO SUPERVISOR_ID ADUSER_ADORGINFO AD_PINSTANCE AD_USER_ID ADUSER_PINSTANCE AD_PREFERENCE AD_USER_ID AD_USER_PREFERENCE AD_PRIVATE_ACCESS AD_USER_ID ADUSER_ADPRIVATEACCESS AD_ROLE SUPERVISOR_ID ADUSERSUPERVISOR_ADROLE AD_SCHEDULER SUPERVISOR_ID ADUSER_ADSCHEDULER AD_SCHEDULERRECIPIENT AD_USER_ID ADUSER_ADSCHEDULERRECIPIENT AD_TREEBAR AD_USER_ID ADUSER_ADTREEBAR AD_USER SUPERVISOR_ID ADUSER_SUPERVISOR AD_USERBPACCESS AD_USER_ID ADUSER_ADUSERBPACCESS AD_USERDEF_WIN AD_USER_ID ADUSER_ADUSERDEFWIN AD_USERMAIL AD_USER_ID ADUSER_ADUSERMAIL AD_USERQUERY AD_USER_ID ADUSER_ADUSERQUERY AD_USER_ORGACCESS AD_USER_ID ADUSER_ADUSERORGACCESS AD_USER_ROLES AD_USER_ID ADUSER_USERROLES AD_USER_SUBSTITUTE AD_USER_ID ADUSER_ADUSERSUB AD_USER_SUBSTITUTE SUBSTITUTE_ID ADUSERSUB_AD_USERSUB AD_WF_ACTIVITY AD_USER_ID ADUSER_ADWFACTIVITY AD_WF_EVENTAUDIT AD_USER_ID ADUSER_ADWFEVENTAUDIT AD_WF_PROCESS AD_USER_ID ADUSER_ADWFPROCESS AD_WF_RESPONSIBLE AD_USER_ID ADUSER_ADWFRESPONSIBLE AD_WORKFLOWPROCESSOR SUPERVISOR_ID ADUSER_ADWORKFLOWPROCESSOR A_ASSET AD_USER_ID ADUSER_AASSET A_ASSET_DELIVERY AD_USER_ID ADUSER_AASSETDELIVERY A_REGISTRATION AD_USER_ID ADUSER_AREGISTRATION B_BIDCOMMENT AD_USER_ID ADUSER_BIDCOMMENT B_BUYER AD_USER_ID ADUSER_BBUYER B_SELLER AD_USER_ID ADUSER_BSELLER C_ACCTPROCESSOR SUPERVISOR_ID ADUSER_CACCTPROCESSOR C_BPARTNER SALESREP_ID ADUSERSALESREP_CBPARTNER C_BP_BANKACCOUNT AD_USER_ID ADUSER_CBPBANKACCOUNT C_DUNNINGRUNENTRY AD_USER_ID Implied Constraint C_INVOICE AD_USER_ID ADUSER_CINVOICE C_INVOICE SALESREP_ID ADUSER_SR_CINVOICE C_INVOICEBATCH SALESREP_ID ADUSER_CINVOICEBATCH C_INVOICEBATCHLINE AD_USER_ID ADUSER_CINVOICEBATCHLINE C_INVOICE_V AD_USER_ID Implied Constraint C_JOBASSIGNMENT AD_USER_ID ADUSER_CJOBASSIGNMENT C_ORDER AD_USER_ID ADUSER_CORDER C_ORDER BILL_USER_ID ADUSERBILL_CORDER C_ORDER SALESREP_ID ADUSER_SR_CORDER C_ORGASSIGNMENT AD_USER_ID ADUSER_CORGASSIGNMENT C_POS SALESREP_ID ADUSER_CPOS C_PROJECT AD_USER_ID ADUSER_CPROJECT C_PROJECT SALESREP_ID ADUSER_SR_CPROJECT C_RFQ AD_USER_ID ADUSER_CRFQ C_RFQ SALESREP_ID ADUSERSALESREP_CRFQ C_RFQRESPONSE AD_USER_ID ADUSER_CRFQRESPONSE C_RFQRESPONSE_V AD_USER_ID Implied Constraint C_RFQRESPONSE_VT AD_USER_ID Implied Constraint C_RFQ_TOPICSUBSCRIBER AD_USER_ID ADUSER_ARFQTOPICSUBCR C_USERREMUNERATION AD_USER_ID ADUSER_CUSERREMUNERATION I_BPARTNER AD_USER_ID ADUSER_IBPARTNER I_INVOICE AD_USER_ID ADUSER_IINVOICE I_INVOICE SALESREP_ID ADUSERSALESREP_IINVOICE I_ORDER AD_USER_ID ADUSER_IORDER I_ORDER SALESREP_ID ADUSERSALESREP_IORDER M_INOUT AD_USER_ID ADUSER_MINOUT M_INOUT SALESREP_ID ADUSER_SR_MINOUT M_INOUTCONFIRM_V AD_USER_ID Implied Constraint M_INOUTCONFIRM_VT AD_USER_ID Implied Constraint M_REQUISITION AD_USER_ID ADUSER_MREQUISITION PA_GOAL AD_USER_ID ADUSER_PAGOAL RV_ASSET_CUSTOMER AD_USER_ID Implied Constraint RV_ASSET_DELIVERY AD_USER_ID Implied Constraint RV_BPARTNER AD_USER_ID Implied Constraint RV_CLICK_UNPROCESSED AD_USER_ID Implied Constraint RV_C_RFQRESPONSE AD_USER_ID Implied Constraint RV_C_RFQ_UNANSWERED AD_USER_ID Implied Constraint RV_M_REQUISITION AD_USER_ID Implied Constraint RV_REQUESTUPDATES AD_USER_ID Implied Constraint R_CATEGORYUPDATES AD_USER_ID ADUSER_RCATEGORYUPDATES R_CONTACTINTEREST AD_USER_ID ADUSER_RCONTACTINTEREST R_GROUPUPDATES AD_USER_ID ADUSER_RUSERUPDATES R_ISSUEUSER AD_USER_ID ADUSER_RISSUEUSER R_REQUEST AD_USER_ID ADUSER_RREQUEST R_REQUEST SALESREP_ID ADUSERSR_RREQUEST R_REQUESTACTION AD_USER_ID ADUSER_RREQUESTACTION R_REQUESTACTION SALESREP_ID ADUSERSR_RREQUESTACTION R_REQUESTPROCESSOR SUPERVISOR_ID ADUSER_RREQUESTPROCESSOR R_REQUESTPROCESSOR_ROUTE AD_USER_ID ADUSER_RREQUESTPROCESSORROUTE R_REQUESTTYPEUPDATES AD_USER_ID ADUSER_RREQUESTTYPEUPDATES R_REQUESTUPDATES AD_USER_ID ADUSER_RREQUESTUPDATES S_RESOURCE AD_USER_ID ADUSER_SRESOURCE TIRE_STORAGE AD_USER_ID ADUSER_TIRESTORAGE T_INVOICEGL_V AD_USER_ID Implied Constraint T_INVOICEGL_VT AD_USER_ID Implied Constraint W_ADVERTISEMENT AD_USER_ID ADUSER_WADVERTISEMENT W_BASKET AD_USER_ID ADUSER_WBASKET W_CLICK AD_USER_ID ADUSER_WCLICK W_COUNTER AD_USER_ID ADUSER_WCOUNTER AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID AD_USER_CLIENT AD_ORG_ID number 10 AD_ORG AD_ORG_ID AD_USER_ORG 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 PASSWORD nvarchar2 80  √  null EMAIL nvarchar2 120  √  null SUPERVISOR_ID number 10  √  null AD_USER AD_USER_ID ADUSER_SUPERVISOR C_BPARTNER_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNER_ADUSER PROCESSING char 1  √  null EMAILUSER nvarchar2 120  √  null EMAILUSERPW nvarchar2 40  √  null C_BPARTNER_LOCATION_ID number 10  √  null C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID CBPLOCATION_ADUSER C_GREETING_ID number 10  √  null C_GREETING C_GREETING_ID CGREETING_ADUSER TITLE nvarchar2 80  √  null COMMENTS nvarchar2 4000  √  null PHONE nvarchar2 80  √  null PHONE2 nvarchar2 80  √  null FAX nvarchar2 80  √  null LASTCONTACT date 7  √  null LASTRESULT nvarchar2 510  √  null BIRTHDAY date 7  √  null AD_ORGTRX_ID number 10  √  null AD_ORG AD_ORG_ID ADORGTRX_ADUSER EMAILVERIFY nvarchar2 80  √  null EMAILVERIFYDATE date 7  √  null NOTIFICATIONTYPE char 1 'E' ISFULLBPACCESS char 1 'Y' C_JOB_ID number 10  √  null C_JOB C_JOB_ID Implied Constraint LDAPUSER nvarchar2 120  √  null CONNECTIONPROFILE char 1  √  null Table contained 7 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.