| SchemaSpy Analysis of idempiere9.adempiereServer | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:55 +0100 | |
| Database Type: PostgreSQL - 9.6.24 |
|
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 | 24 | 0 | Broadcast Messages for system users |
| ad_client | 9 | 40 | 2 | Client/Tenant for this installation. | |
| ad_clientinfo | 2 | 36 | 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 | 1,886 | System Message |
| ad_note | 4 | 20 | 0 | System Notice | |
| ad_pinstance | 2 | 2 | 22 | 0 | Instance of the process |
| ad_pinstance_log | 2 | 9 | 0 | (Non Standard Table) | |
| ad_pinstance_para | 1 | 19 | 0 | AD_PInstance_Para | |
| ad_process | 4 | 1 | 34 | 454 | Process or Report |
| ad_process_para | 1 | 1 | 38 | 1,145 | Process Parameter |
| ad_role | 3 | 2 | 54 | 5 | Responsibility Role |
| ad_schedule | 5 | 20 | 5 | Times for the Scheduler | |
| ad_scheduler | 3 | 4 | 30 | 10 | Schedule Processes |
| ad_scheduler_para | 2 | 13 | 11 | 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 | 8 | 1 | 32 | 1,029 | Table for the Fields |
| ad_user | 15 | 3 | 68 | 8 | User within the system - Internal or Business Partner Contact |
| ad_wf_process | 1 | 6 | 20 | 10 | Actual Workflow Process Instance |
| ad_workflow | 2 | 3 | 48 | 56 | 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 | 938 | 4,647 | |||
| 0 Views | 0 |