| SchemaSpy Analysis of idempiere9.adempiereResource Management | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:55 +0100 | |
| Database Type: PostgreSQL - 9.6.24 |
|
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 | 68 | 8 | 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 | 38 | 4 | Time and Expense Report Line | |
| s_timetype | 1 | 12 | 0 | Type of time recorded | |
| 13 Tables | 380 | 208 | |||
| 0 Views | 0 |