| SchemaSpy Analysis of idempiere9.adempierePerformance Analysis | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:53 +0100 | |
| Database Type: PostgreSQL - 9.6.24 |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| ad_alert | 2 | 18 | 1 | iDempiere Alert | |
| ad_alertrecipient | 3 | 12 | 1 | Recipient of the Alert Notification | |
| ad_alertrule | 2 | 20 | 1 | Definition of the alert element | |
| ad_chart | 2 | 21 | 4 | Chart definition | |
| ad_chartdatasource | 2 | 22 | 6 | Chart data definition | |
| ad_org | 13 | 13 | 10 | Organizational entity within client | |
| ad_printcolor | 8 | 12 | 20 | Color used for printing and display | |
| ad_role | 7 | 2 | 54 | 5 | Responsibility Role |
| ad_table | 5 | 1 | 32 | 1,029 | Table for the Fields |
| ad_user | 14 | 5 | 68 | 8 | User within the system - Internal or Business Partner Contact |
| c_acctschema | 1 | 2 | 35 | 2 | Rules for accounting |
| c_bp_group | 2 | 1 | 23 | 3 | Business Partner Group |
| c_bpartner | 4 | 5 | 74 | 17 | Identifies a Business Partner |
| c_elementvalue | 1 | 1 | 30 | 379 | Account Element |
| c_phase | 2 | 16 | 13 | Standard Phase of the Project Type | |
| c_projecttype | 2 | 13 | 4 | Type of the project | |
| m_product | 2 | 3 | 72 | 55 | Product Service Item |
| m_product_category | 3 | 2 | 19 | 14 | Category of a Product |
| pa_achievement | 1 | 17 | 0 | Performance Achievement | |
| pa_benchmark | 2 | 13 | 0 | Performance Benchmark | |
| pa_benchmarkdata | 1 | 14 | 0 | Performance Benchmark Data Point | |
| pa_colorschema | 1 | 4 | 20 | 2 | Performance Color Schema |
| pa_dashboardcontent | 2 | 4 | 28 | 10 | Dashboard Content |
| pa_dashboardcontent_access | 6 | 12 | 2 | PA_DashboardContent_Access_ID | |
| pa_dashboardpreference | 3 | 16 | 0 | Dashboard Preference | |
| pa_documentstatus | 1 | 5 | 24 | 6 | Document Status |
| pa_documentstatusaccess | 3 | 12 | 0 | Document Status Access | |
| pa_goal | 3 | 5 | 29 | 4 | Performance Goal |
| pa_goalrestriction | 7 | 17 | 0 | Performance Goal Restriction | |
| pa_hierarchy | 1 | 20 | 0 | Reporting Hierarchy | |
| pa_measure | 2 | 6 | 22 | 4 | Concrete Performance Measurement |
| pa_measurecalc | 2 | 1 | 20 | 6 | Calculation method for measuring performance |
| pa_ratio | 3 | 1 | 13 | 1 | Performace Ratio |
| pa_ratioelement | 4 | 20 | 3 | Performance Ratio Element | |
| pa_reportcube | 31 | 0 | Define reporting cube for pre-calculation of summary accounting data. | ||
| pa_sla_criteria | 1 | 14 | 2 | Service Level Agreement Criteria | |
| pa_sla_goal | 1 | 2 | 21 | 1 | Service Level Agreement Goal |
| pa_sla_measure | 2 | 17 | 1 | Service Level Agreement Measure | |
| r_requesttype | 1 | 25 | 3 | Type of request (e.g. Inquiry, Complaint, ..) | |
| r_status | 2 | 2 | 23 | 4 | Request Status |
| 40 Tables | 982 | 1,621 | |||
| 0 Views | 0 |