SchemaSpy Analysis of idempiere11.adempierePerformance Analysis | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:53 +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 | 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 | 1 | 2 | 22 | 6 | Chart data definition |
ad_chartdatasource_trl | 1 | 12 | 6 | Chart Datasource Trl | |
ad_org | 13 | 13 | 10 | Organizational entity within client | |
ad_printcolor | 8 | 12 | 23 | Color used for printing and display | |
ad_role | 7 | 2 | 56 | 5 | Responsibility Role |
ad_table | 5 | 1 | 35 | 1.052 | Table for the Fields |
ad_user | 14 | 5 | 69 | 9 | 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 | 18 | 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 | 32 | 10 | Dashboard Content |
pa_dashboardcontent_access | 6 | 12 | 2 | PA_DashboardContent_Access_ID | |
pa_dashboardpreference | 3 | 17 | 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 |
41 Tables | 1.005 | 1.655 | |||
0 Views | 0 |