SchemaSpy Analysis of idempiere11.adempiereServer | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:55 +0100 | |
Database Type: PostgreSQL - 15.5 (Ubuntu 15.5-1.pgdg22.04+1) |
|
XML Representation Insertion Order Deletion Order |
Table | Children | Parents | Columns | Rows | Comments |
---|---|---|---|---|---|
ad_alert | 2 | 1 | 18 | 1 | iDempiere Alert |
ad_alertprocessor | 2 | 2 | 19 | 1 | Alert Processor/Server Parameter |
ad_alertprocessorlog | 1 | 16 | 0 | Result of the execution of the Alert Processor | |
ad_alertrecipient | 3 | 12 | 1 | Recipient of the Alert Notification | |
ad_alertrule | 2 | 20 | 1 | Definition of the alert element | |
ad_broadcastmessage | 1 | 3 | 25 | 0 | Broadcast Messages for system users |
ad_client | 9 | 42 | 2 | Tenant for this installation. | |
ad_clientinfo | 2 | 37 | 2 | AD_ClientInfo | |
ad_housekeeping | 1 | 22 | 9 | House Keeping Configuration | |
ad_issue | 1 | 50 | 0 | System Issue | |
ad_ldapprocessor | 1 | 17 | 1 | LDAP Server | |
ad_message | 2 | 1 | 14 | 2.012 | System Message |
ad_note | 4 | 20 | 0 | System Notice | |
ad_pinstance | 2 | 3 | 25 | 0 | Instance of the process |
ad_pinstance_log | 2 | 10 | 0 | (Non Standard Table) | |
ad_pinstance_para | 1 | 20 | 0 | AD_PInstance_Para | |
ad_process | 4 | 1 | 35 | 469 | Process or Report |
ad_process_para | 1 | 1 | 40 | 1.186 | Process Parameter |
ad_role | 3 | 2 | 56 | 5 | Responsibility Role |
ad_schedule | 5 | 20 | 5 | Times for the Scheduler | |
ad_scheduler | 3 | 4 | 30 | 12 | Schedule Processes |
ad_scheduler_para | 2 | 13 | 14 | AD_Scheduler_Para | |
ad_schedulerlog | 1 | 16 | 0 | Result of the execution of the Scheduler | |
ad_schedulerrecipient | 3 | 15 | 1 | Recipient of the Scheduler Notification | |
ad_table | 9 | 1 | 35 | 1.052 | Table for the Fields |
ad_user | 15 | 3 | 69 | 9 | User within the system - Internal or Business Partner Contact |
ad_wf_process | 1 | 6 | 20 | 11 | Actual Workflow Process Instance |
ad_workflow | 2 | 3 | 48 | 57 | Workflow or combination of tasks |
ad_workflowprocessor | 2 | 2 | 22 | 1 | Workflow Processor Server |
ad_workflowprocessorlog | 1 | 16 | 0 | Result of the execution of the Workflow Processor | |
c_acctprocessor | 1 | 4 | 21 | 1 | Accounting Processor/Server Parameters |
c_acctprocessorlog | 1 | 16 | 0 | Result of the execution of the Accounting Processor | |
c_acctschema | 2 | 1 | 35 | 2 | Rules for accounting |
exp_processor | 18 | 2 | Export Processor | ||
imp_processor | 24 | 2 | Import Processor | ||
r_requestprocessor | 1 | 2 | 24 | 1 | Request Processor |
r_requestprocessorlog | 1 | 16 | 0 | Request Processor Log | |
37 Tables | 956 | 4.860 | |||
0 Views | 0 |