| SchemaSpy Analysis of idempiere11.adempiereService Management | 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 |
|---|---|---|---|---|---|
| c_bpartner | 4 | 3 | 74 | 18 | Identifies a Business Partner |
| c_invoiceline | 2 | 5 | 51 | 24 | Invoice Detail Line |
| c_nonbusinessday | 13 | 1 | Day on which business is not transacted | ||
| c_orderline | 4 | 7 | 59 | 27 | Sales Order Line |
| c_servicelevel | 1 | 1 | 16 | 0 | Product Revenue Recognition Service Level |
| c_servicelevelline | 1 | 14 | 0 | Product Revenue Recognition Service Level Line | |
| c_taxcategory | 3 | 13 | 1 | Tax Category | |
| c_uom | 6 | 17 | 15 | Unit of Measure | |
| m_pricelist | 4 | 1 | 20 | 4 | Unique identifier of a Price List |
| m_product | 4 | 5 | 72 | 55 | Product Service Item |
| m_product_category | 4 | 1 | 19 | 14 | Category of a Product |
| m_warehouse | 4 | 1 | 19 | 11 | Storage Warehouse and Service Point |
| s_expensetype | 1 | 3 | 16 | 1 | Expense report type |
| s_resource | 3 | 2 | 24 | 11 | Resource |
| s_resourceassignment | 3 | 1 | 16 | 2 | Resource Assignment |
| s_resourcetype | 1 | 3 | 29 | 3 | Resource Type |
| s_resourceunavailable | 1 | 13 | 2 | Resource Unavailability | |
| s_timeexpense | 1 | 3 | 21 | 1 | Time and Expense Report |
| s_timeexpenseline | 7 | 39 | 4 | Time and Expense Report Line | |
| 19 Tables | 545 | 194 | |||
| 0 Views | 0 |