SchemaSpy Analysis of erp.COMPIERE

 Generated by
SchemaSpy
Generated by SchemaSpy on Wed Mar 15 18:14 SAST 2006
Database Type: Oracle - Oracle9i Release 9.2.0.1.0 - Production JServer Release 9.2.0.1.0 - Production SourceForge.net

Please support this project

Insertion Order Deletion Order (for database loading/purging scripts)

531 Tables and 108 Views:

Table Children Parents Rows
AD_ACCESSLOG 2 0
AD_ALERT 2 1 1
AD_ALERTPROCESSOR 2 1 1
AD_ALERTPROCESSORLOG 1 0
AD_ALERTRECIPIENT 3 1
AD_ALERTRULE 2 1
AD_ARCHIVE 2 0
AD_ATTACHMENT 1 1 2
AD_ATTACHMENTNOTE 2 0
AD_ATTRIBUTE 1 4 0
AD_ATTRIBUTE_VALUE 1 0
AD_CHANGELOG 3 0
AD_CHANGELOG_V view
AD_CLIENT 66 2
AD_CLIENTINFO 13 2
AD_CLIENTSHARE 3 0
AD_COLOR 3 1 0
AD_COLUMN 17 8 11,839
AD_COLUMN_ACCESS 3 0
AD_COLUMN_TRL 2 0
AD_DESKTOP 2 2 1
AD_DESKTOPWORKBENCH 2 1
AD_DESKTOP_TRL 2 0
AD_ELEMENT 3 2,155
AD_ELEMENT_TRL 2 0
AD_ERROR 0
AD_FIELD 2 5 10,683
AD_FIELDGROUP 2 35
AD_FIELDGROUP_TRL 2 0
AD_FIELD_TRL 2 0
AD_FIELD_V view
AD_FIELD_VT view
AD_FIND 1 0
AD_FORM 6 20
AD_FORM_ACCESS 2 38
AD_FORM_TRL 2 0
AD_IMAGE 6 8
AD_IMPFORMAT 1 1 10
AD_IMPFORMAT_ROW 2 61
AD_ISSUE 9 3
AD_LABELPRINTER 2 0
AD_LABELPRINTERFUNCTION 1 1 0
AD_LANGUAGE 37 2 95
AD_MENU 1 8 431
AD_MENU_TRL 2 0
AD_MESSAGE 4 2 762
AD_MESSAGE_TRL 2 0
AD_NOTE 4 0
AD_ORG 113 1 3
AD_ORGINFO 6 3
AD_ORGTYPE 1 3
AD_ORG_V view
AD_PINSTANCE 11 2 6
AD_PINSTANCE_LOG 1 0
AD_PINSTANCE_PARA 1 6
AD_PREFERENCE 4 13
AD_PRINTCOLOR 12 20
AD_PRINTFONT 4 66
AD_PRINTFORM 11 2
AD_PRINTFORMAT 15 6 39
AD_PRINTFORMATITEM 7 6 1,283
AD_PRINTFORMATITEM_TRL 2 0
AD_PRINTGRAPH 1 7 0
AD_PRINTLABEL 1 2 0
AD_PRINTLABELLINE 1 3 0
AD_PRINTLABELLINE_TRL 2 0
AD_PRINTPAPER 1 4
AD_PRINTTABLEFORMAT 1 8 2
AD_PRIVATE_ACCESS 2 0
AD_PROCESS 12 2 241
AD_PROCESS_ACCESS 4 444
AD_PROCESS_PARA 3 5 564
AD_PROCESS_PARA_TRL 2 0
AD_PROCESS_TRL 2 0
AD_RECORD_ACCESS 2 0
AD_REFERENCE 11 2 291
AD_REFERENCE_TRL 2 0
AD_REF_LIST 1 3 709
AD_REF_LIST_TRL 2 0
AD_REF_TABLE 6 113
AD_REGISTRATION 2 0
AD_REPLICATION 1 1 1
AD_REPLICATIONSTRATEGY 2 1
AD_REPLICATIONTABLE 1 2 474
AD_REPLICATION_LOG 2 0
AD_REPLICATION_RUN 1 1 0
AD_REPORTVIEW 3 1 67
AD_REPORTVIEW_COL 2 0
AD_ROLE 16 5 3
AD_ROLE_ORGACCESS 2 6
AD_SCHEDULER 3 2 1
AD_SCHEDULERLOG 1 0
AD_SCHEDULERRECIPIENT 3 0
AD_SCHEDULER_PARA 2 1
AD_SEQUENCE 5 2 810
AD_SEQUENCE_AUDIT 4 0
AD_SEQUENCE_NO 3 0
AD_SESSION 3 1
AD_SYSTEM 2 1
AD_TAB 4 10 624
AD_TABLE 30 5 591
AD_TABLE_ACCESS 4 1
AD_TABLE_TRL 2 0
AD_TAB_TRL 2 0
AD_TAB_V view
AD_TAB_VT view
AD_TASK 6 2 3
AD_TASKINSTANCE 3 0
AD_TASK_ACCESS 4 3
AD_TASK_TRL 2 0
AD_TREE 21 15
AD_TREEBAR 2 19
AD_TREENODE 1 383
AD_TREENODEBP 1 8
AD_TREENODEMM 1 434
AD_TREENODEPR 1 27
AD_USER 79 7 7
AD_USERBPACCESS 2 0
AD_USERDEF_FIELD 2 0
AD_USERDEF_TAB 1 2 0
AD_USERDEF_WIN 1 3 0
AD_USERMAIL 3 1
AD_USERQUERY 2 0
AD_USER_ORGACCESS 2 0
AD_USER_ROLES 4 7
AD_USER_ROLES_V view
AD_USER_SUBSTITUTE 2 0
AD_VAL_RULE 4 2 149
AD_WF_ACTIVITY 2 5 0
AD_WF_ACTIVITYRESULT 1 0
AD_WF_BLOCK 1 1 0
AD_WF_EVENTAUDIT 5 0
AD_WF_NEXTCONDITION 2 1
AD_WF_NODE 6 11 140
AD_WF_NODENEXT 1 4 112
AD_WF_NODE_PARA 2 1
AD_WF_NODE_TRL 2 0
AD_WF_PROCESS 3 6 0
AD_WF_PROCESSDATA 1 0
AD_WF_RESPONSIBLE 5 3 2
AD_WINDOW 11 4 247
AD_WINDOW_ACCESS 4 448
AD_WINDOW_TRL 2 0
AD_WINDOW_VT view
AD_WORKBENCH 4 2 1
AD_WORKBENCHWINDOW 5 2
AD_WORKBENCH_TRL 2 0
AD_WORKFLOW 7 4 30
AD_WORKFLOWPROCESSOR 2 1 1
AD_WORKFLOWPROCESSORLOG 1 0
AD_WORKFLOW_ACCESS 4 60
AD_WORKFLOW_TRL 2 0
A_ASSET 14 8 0
A_ASSET_ACCT 3 0
A_ASSET_ADDITION 1 2 0
A_ASSET_CHANGE 1 3 0
A_ASSET_CHANGE_AMT 2 0
A_ASSET_DELIVERY 4 0
A_ASSET_GROUP 3 1
A_ASSET_GROUP_ACCT 3 0
A_ASSET_RETIREMENT 1 2 0
A_ASSET_USE 1 0
A_DEPRECIATION 2 0
A_REGISTRATION 1 4 0
A_REGISTRATIONATTRIBUTE 2 2 0
A_REGISTRATIONPRODUCT 2 0
A_REGISTRATIONVALUE 2 0
B_BID 3 0
B_BIDCOMMENT 2 0
B_BUYER 2 1 0
B_BUYERFUNDS 1 3 0
B_OFFER 3 0
B_SELLER 2 1 0
B_SELLERFUNDS 1 3 0
B_TOPIC 3 2 0
B_TOPICCATEGORY 1 1 0
B_TOPICTYPE 2 3 0
CREATE$JAVA$LOB$TABLE 8
C_ACCTPROCESSOR 1 1 1
C_ACCTPROCESSORLOG 1 0
C_ACCTSCHEMA 38 5 1
C_ACCTSCHEMA_DEFAULT 58 1
C_ACCTSCHEMA_ELEMENT 13 6
C_ACCTSCHEMA_GL 9 1
C_ACTIVITY 23 0
C_ALLOCATIONHDR 1 1 3
C_ALLOCATIONLINE 2 6 3
C_BANK 2 1 1
C_BANKACCOUNT 11 2 2
C_BANKACCOUNTDOC 2 1
C_BANKACCOUNT_ACCT 14 2
C_BANKSTATEMENT 2 1 1
C_BANKSTATEMENTLINE 1 6 2
C_BANKSTATEMENTLOADER 1 0
C_BANKSTATEMENTMATCHER 0
C_BPARTNER 67 17 8
C_BPARTNER_LOCATION 22 5 8
C_BPARTNER_PRODUCT 2 1
C_BP_BANKACCOUNT 1 3 1
C_BP_CUSTOMER_ACCT 4 8
C_BP_EDI 1 3 0
C_BP_EMPLOYEE_ACCT 4 8
C_BP_GROUP 6 4 3
C_BP_GROUP_ACCT 14 3
C_BP_RELATION 4 1
C_BP_VENDOR_ACCT 5 8
C_BP_WITHHOLDING 2 0
C_CALENDAR 6 2 1
C_CAMPAIGN 22 1 2
C_CASH 1 8 3
C_CASHBOOK 3 1 2
C_CASHBOOK_ACCT 7 2
C_CASHLINE 3 5 5
C_CHANNEL 1 2
C_CHARGE 14 1 2
C_CHARGE_ACCT 4 2
C_CITY 1 4 1
C_COMMISSION 2 3 1
C_COMMISSIONAMT 1 2 0
C_COMMISSIONDETAIL 4 0
C_COMMISSIONLINE 1 7 1
C_COMMISSIONRUN 1 1 0
C_CONVERSIONTYPE 11 4
C_CONVERSION_RATE 1 5 7
C_COUNTRY 11 4 239
C_COUNTRY_TRL 2 0
C_CURRENCY 46 2 173
C_CURRENCY_ACCT 6 0
C_CURRENCY_TRL 2 0
C_CYCLE 1 1 2
C_CYCLEPHASE 2 10
C_CYCLESTEP 1 1 4
C_DOCTYPE 22 6 36
C_DOCTYPECOUNTER 2 1
C_DOCTYPE_TRL 2 0
C_DUNNING 2 2
C_DUNNINGLEVEL 2 2 2
C_DUNNINGLEVEL_TRL 2 0
C_DUNNINGRUN 1 1 0
C_DUNNINGRUNENTRY 1 3 0
C_DUNNINGRUNLINE 3 0
C_DUNNING_HEADER_V view
C_DUNNING_HEADER_VT view
C_DUNNING_LINE_V view
C_DUNNING_LINE_VT view
C_ELEMENT 3 3 1
C_ELEMENTVALUE 46 5 363
C_ELEMENTVALUE_TRL 2 0
C_GREETING 4 1
C_GREETING_TRL 2 0
C_INTERORG_ACCT 5 0
C_INVOICE 21 22 14
C_INVOICEBATCH 1 3 0
C_INVOICEBATCHLINE 15 0
C_INVOICELINE 14 11 30
C_INVOICELINE_V view
C_INVOICEPAYSCHEDULE 2 2
C_INVOICESCHEDULE 1 1
C_INVOICETAX 2 12
C_INVOICE_CANDIDATE_V view
C_INVOICE_HEADER_V view
C_INVOICE_HEADER_VT view
C_INVOICE_LINETAX_V view
C_INVOICE_LINETAX_VT view
C_INVOICE_V view
C_INVOICE_V1 view
C_JOB 3 1 4
C_JOBASSIGNMENT 2 0
C_JOBCATEGORY 1 4
C_JOBREMUNERATION 2 0
C_LANDEDCOST 5 0
C_LANDEDCOSTALLOCATION 4 0
C_LOCATION 22 5 13
C_NONBUSINESSDAY 3 1
C_ORDER 18 28 7
C_ORDERLINE 9 13 25
C_ORDERTAX 2 7
C_ORDER_HEADER_V view
C_ORDER_HEADER_VT view
C_ORDER_LINETAX_V view
C_ORDER_LINETAX_VT view
C_ORGASSIGNMENT 2 0
C_PAYMENT 15 15 2
C_PAYMENTALLOCATE 3 0
C_PAYMENTBATCH 1 1 0
C_PAYMENTPROCESSOR 1 3 2
C_PAYMENTTERM 10 5
C_PAYMENTTERM_TRL 2 0
C_PAYMENT_V view
C_PAYSCHEDULE 1 1 2
C_PAYSELECTION 2 1 1
C_PAYSELECTIONCHECK 1 3 1
C_PAYSELECTIONLINE 3 1
C_PAYSELECTION_CHECK_V view
C_PAYSELECTION_CHECK_VT view
C_PAYSELECTION_REMITTANCE_V view
C_PAYSELECTION_REMITTANCE_VT view
C_PERIOD 8 3 72
C_PERIODCONTROL 1 1,800
C_PHASE 4 2 13
C_POS 5 1
C_POSKEY 2 3
C_POSKEYLAYOUT 2 1
C_PROJECT 30 13 2
C_PROJECTISSUE 5 6 0
C_PROJECTISSUEMA 2 0
C_PROJECTLINE 6 1
C_PROJECTPHASE 2 4 0
C_PROJECTTASK 1 3 0
C_PROJECTTYPE 2 4
C_PROJECT_ACCT 4 2
C_PROJECT_DETAILS_V view
C_PROJECT_DETAILS_VT view
C_PROJECT_HEADER_V view
C_PROJECT_HEADER_VT view
C_RECURRING 1 5 1
C_RECURRING_RUN 6 0
C_REGION 9 3 228
C_REMUNERATION 2 0
C_REVENUERECOGNITION 2 2
C_REVENUERECOGNITION_PLAN 2 6 0
C_REVENUERECOGNITION_RUN 2 0
C_RFQ 2 7 1
C_RFQLINE 2 3 2
C_RFQLINEQTY 1 2 2
C_RFQRESPONSE 1 6 0
C_RFQRESPONSELINE 1 2 0
C_RFQRESPONSELINEQTY 2 0
C_RFQRESPONSELINEQTY_V view
C_RFQRESPONSELINEQTY_VT view
C_RFQRESPONSELINE_V view
C_RFQRESPONSELINE_VT view
C_RFQRESPONSE_V view
C_RFQRESPONSE_VT view
C_RFQ_TOPIC 2 1 1
C_RFQ_TOPICSUBSCRIBER 1 4 2
C_RFQ_TOPICSUBSCRIBERONLY 3 0
C_SALESREGION 11 2
C_SERVICELEVEL 1 2 0
C_SERVICELEVELLINE 1 0
C_SUBACCT 1 0
C_SUBSCRIPTION 1 3 0
C_SUBSCRIPTIONTYPE 2 0
C_SUBSCRIPTION_DELIVERY 1 0
C_TASK 1 2 9
C_TAX 13 6 6
C_TAXCATEGORY 7 1
C_TAXCATEGORY_TRL 2 0
C_TAXDECLARATION 2 0
C_TAXDECLARATIONACCT 3 0
C_TAXDECLARATIONLINE 7 0
C_TAXPOSTAL 1 0
C_TAX_ACCT 7 6
C_TAX_TRL 2 0
C_UOM 21 2 10
C_UOM_CONVERSION 4 1
C_UOM_TRL 2 0
C_USERREMUNERATION 2 0
C_VALIDCOMBINATION 142 15 76
C_WITHHOLDING 2 1 0
C_WITHHOLDING_ACCT 3 0
C_YEAR 3 3 6
FACT_ACCT 2 24 0
FACT_ACCT_BALANCE 16 0
GL_BUDGET 7 1
GL_BUDGETCONTROL 2 0
GL_CATEGORY 5 7
GL_DISTRIBUTION 1 16 1
GL_DISTRIBUTIONLINE 15 2
GL_FUND 1 1 0
GL_FUNDRESTRICTION 2 0
GL_JOURNAL 3 8 1
GL_JOURNALBATCH 4 4 1
GL_JOURNALLINE 1 7 2
GL_JOURNALLINE_ACCT_V view
I_BANKSTATEMENT 8 0
I_BPARTNER 7 0
I_CONVERSION_RATE 4 2
I_ELEMENTVALUE 4 0
I_GLJOURNAL 25 0
I_INOUTLINECONFIRM 1 0
I_INVENTORY 5 0
I_INVOICE 20 0
I_ORDER 24 0
I_PAYMENT 6 0
I_PRODUCT 5 0
I_REPORTLINE 4 0
JAVA$CLASS$MD5$TABLE 9
K_CATEGORY 2 1
K_CATEGORYVALUE 1 1 0
K_COMMENT 2 0
K_ENTRY 4 3 0
K_ENTRYCATEGORY 3 0
K_ENTRYRELATED 2 0
K_SOURCE 1 1
K_SYNONYM 0
K_TOPIC 1 1 1
K_TYPE 1 2
M_ATTRIBUTE 3 1 4
M_ATTRIBUTEINSTANCE 3 5
M_ATTRIBUTESEARCH 1 1
M_ATTRIBUTESET 4 2 4
M_ATTRIBUTESETEXCLUDE 2 0
M_ATTRIBUTESETINSTANCE 26 2 4
M_ATTRIBUTEUSE 2 5
M_ATTRIBUTEVALUE 1 1 9
M_BOM 2 2 1
M_BOMALTERNATIVE 1 1 1
M_BOMPRODUCT 6 0
M_CHANGENOTICE 4 1
M_CHANGEREQUEST 2 0
M_COST 7 27
M_COSTDETAIL 13 0
M_COSTELEMENT 6 6
M_COSTQUEUE 5 0
M_COSTTYPE 3 1
M_DEMAND 1 2 0
M_DEMANDDETAIL 4 0
M_DEMANDLINE 1 3 0
M_DISCOUNTSCHEMA 7 3
M_DISCOUNTSCHEMABREAK 3 1
M_DISCOUNTSCHEMALINE 5 11
M_DISTRIBUTIONLIST 3 1
M_DISTRIBUTIONLISTLINE 1 3 3
M_DISTRIBUTIONRUN 2 2 1
M_DISTRIBUTIONRUNLINE 1 3 1
M_EDI 1 3 0
M_EDI_INFO 1 0
M_FORECAST 1 2 0
M_FORECASTLINE 1 3 0
M_FREIGHT 7 1
M_FREIGHTCATEGORY 2 2
M_INOUT 8 17 9
M_INOUTCONFIRM 1 1 1
M_INOUTCONFIRM_V view
M_INOUTCONFIRM_VT view
M_INOUTLINE 16 7 27
M_INOUTLINECONFIRM 1 2 1
M_INOUTLINEMA 2 0
M_INOUTLINEMA_V view
M_INOUTLINEMA_VT view
M_INOUT_CANDIDATE_V view
M_INOUT_HEADER_V view
M_INOUT_HEADER_VT view
M_INOUT_LINECONFIRM_V view
M_INOUT_LINECONFIRM_VT view
M_INOUT_LINE_V view
M_INOUT_LINE_VT view
M_INVENTORY 3 9 1
M_INVENTORYLINE 8 5 1
M_INVENTORYLINEMA 2 0
M_LOCATOR 15 3 2
M_LOT 1 2 0
M_LOTCTL 3 1
M_LOTCTLEXCLUDE 2 0
M_MATCHINV 3 18
M_MATCHPO 4 35
M_MOVEMENT 2 7 1
M_MOVEMENTCONFIRM 1 2 0
M_MOVEMENTLINE 5 5 1
M_MOVEMENTLINECONFIRM 3 0
M_MOVEMENTLINEMA 2 0
M_MOVEMENTLINEMA_V view
M_MOVEMENTLINEMA_VT view
M_OPERATIONRESOURCE 3 0
M_PACKAGE 1 2 1
M_PACKAGELINE 2 1
M_PERPETUALINV 1 2 0
M_PRICELIST 15 2 3
M_PRICELIST_VERSION 3 2 5
M_PRODUCT 84 14 27
M_PRODUCTDOWNLOAD 1 1 1
M_PRODUCTION 1 7 0
M_PRODUCTIONLINE 6 4 0
M_PRODUCTIONLINEMA 2 0
M_PRODUCTIONPLAN 1 3 0
M_PRODUCTOPERATION 2 1 0
M_PRODUCTPRICE 2 85
M_PRODUCT_ACCT 10 27
M_PRODUCT_BOM 2 3
M_PRODUCT_CATEGORY 13 1 8
M_PRODUCT_CATEGORY_ACCT 10 8
M_PRODUCT_COSTING 2 27
M_PRODUCT_PO 6 21
M_PRODUCT_TRL 2 0
M_RELATEDPRODUCT 2 1
M_REPLENISH 2 19
M_REQUISITION 1 3 1
M_REQUISITIONLINE 1 2 1
M_RMA 3 1 1
M_RMALINE 2 1
M_RMATYPE 1
M_SERNOCTL 2 1
M_SERNOCTLEXCLUDE 2 0
M_SHIPPER 6 1 1
M_STORAGE 5 20
M_SUBSTITUTE 4 0
M_TRANSACTION 3 8 28
M_TRANSACTIONALLOCATION 10 0
M_TRANSACTION_V view
M_WAREHOUSE 21 3 2
M_WAREHOUSE_ACCT 6 2
PA_ACHIEVEMENT 1 0
PA_BENCHMARK 2 0
PA_BENCHMARKDATA 1 0
PA_COLORSCHEMA 1 4 2
PA_GOAL 2 4 4
PA_GOALRESTRICTION 7 0
PA_HIERARCHY 1 8 0
PA_MEASURE 2 4 4
PA_MEASURECALC 2 6
PA_RATIO 3 1 1
PA_RATIOELEMENT 4 3
PA_REPORT 6 3
PA_REPORTCOLUMN 2 14 17
PA_REPORTCOLUMNSET 2 3
PA_REPORTLINE 6 5 113
PA_REPORTLINESET 3 3
PA_REPORTSOURCE 1 10 93
PA_SLA_CRITERIA 1 2
PA_SLA_GOAL 1 2 1
PA_SLA_MEASURE 2 1
RV_ALLOCATION view
RV_ASSET_CUSTOMER view
RV_ASSET_DELIVERY view
RV_ASSET_SUMMONTH view
RV_BPARTNER view
RV_BPARTNEROPEN view
RV_CASH_DETAIL view
RV_CLICK_MONTH view
RV_CLICK_UNPROCESSED view
RV_COMMISSIONRUNDETAIL view
RV_COST view
RV_COSTDETAIL view
RV_COSTSUMMARY view
RV_C_INVOICE view
RV_C_INVOICELINE view
RV_C_INVOICETAX view
RV_C_INVOICE_CUSTOMERPRODQTR view
RV_C_INVOICE_CUSTOMERVENDQTR view
RV_C_INVOICE_DAY view
RV_C_INVOICE_MONTH view
RV_C_INVOICE_PRODMONTH view
RV_C_INVOICE_PRODUCTMONTH view
RV_C_INVOICE_PRODUCTQTR view
RV_C_INVOICE_PRODWEEK view
RV_C_INVOICE_VENDORMONTH view
RV_C_INVOICE_WEEK view
RV_C_RFQRESPONSE view
RV_C_RFQ_UNANSWERED view
RV_FACT_ACCT view
RV_FACT_ACCT_DAY view
RV_FACT_ACCT_PERIOD view
RV_INOUTCONFIRM view
RV_INOUTDETAILS view
RV_INOUTLINECONFIRM