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