| SchemaSpy Analysis of idempiere11.adempiereOrg / User | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:52 +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 | 11 | 13 | 10 | Organizational entity within client | |
| ad_orginfo | 3 | 27 | 10 | Organization Info | |
| ad_role | 5 | 2 | 56 | 5 | Responsibility Role |
| ad_role_included | 2 | 11 | 0 | Included Role | |
| ad_role_orgaccess | 2 | 10 | 18 | AD_Role_OrgAccess | |
| ad_user | 12 | 6 | 69 | 9 | User within the system - Internal or Business Partner Contact |
| ad_user_roles | 3 | 10 | 11 | AD_User_Roles | |
| ad_user_substitute | 2 | 15 | 0 | Substitute of the user | |
| ad_wf_responsible | 3 | 15 | 2 | Responsible for Workflow Execution | |
| c_bpartner | 2 | 4 | 74 | 18 | Identifies a Business Partner |
| c_job | 3 | 1 | 14 | 4 | Position |
| c_jobassignment | 2 | 14 | 0 | Position Assignment | |
| c_jobcategory | 1 | 12 | 4 | Position Category | |
| c_jobremuneration | 2 | 14 | 0 | Position Remuneration | |
| c_orgassignment | 2 | 13 | 0 | Assigment to (transaction) Organization | |
| c_remuneration | 2 | 18 | 0 | Remuneration | |
| c_userremuneration | 2 | 18 | 0 | Employee Wage or Salary Overwrite | |
| 17 Tables | 403 | 91 | |||
| 0 Views | 0 |