SchemaSpy Analysis of idempiere11.adempiereResource 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 |
---|---|---|---|---|---|
ad_org | 7 | 13 | 10 | Organizational entity within client | |
ad_user | 5 | 4 | 69 | 9 | User within the system - Internal or Business Partner Contact |
c_acctschema | 1 | 2 | 35 | 2 | Rules for accounting |
c_nonbusinessday | 1 | 13 | 1 | Day on which business is not transacted | |
c_orgassignment | 2 | 13 | 0 | Assigment to (transaction) Organization | |
m_product | 2 | 3 | 72 | 55 | Product Service Item |
m_product_acct | 2 | 34 | 110 | Product Acct | |
s_resource | 3 | 2 | 24 | 11 | Resource |
s_resourceassignment | 1 | 1 | 16 | 2 | Resource Assignment |
s_resourcetype | 1 | 29 | 3 | Resource Type | |
s_resourceunavailable | 1 | 13 | 2 | Resource Unavailability | |
s_timeexpenseline | 3 | 39 | 4 | Time and Expense Report Line | |
s_timetype | 1 | 12 | 0 | Type of time recorded | |
13 Tables | 382 | 209 | |||
0 Views | 0 |