| SchemaSpy Analysis of idempiere9.adempiereService Management | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:56 +0100 | |
| Database Type: PostgreSQL - 9.6.24 |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| c_bpartner | 4 | 3 | 74 | 17 | 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 | 3 | 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 | 38 | 4 | Time and Expense Report Line | |
| 19 Tables | 544 | 192 | |||
| 0 Views | 0 |