| SchemaSpy Analysis of idempiere11.adempiereClient & Organization | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:47 +0100 | |
| Database Type: PostgreSQL - 15.5 (Ubuntu 15.5-1.pgdg22.04+1) |
|
XML Representation Insertion Order Deletion Order |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| ad_client | 11 | 1 | 42 | 2 | Tenant for this installation. |
| ad_clientinfo | 2 | 37 | 2 | AD_ClientInfo | |
| ad_clientshare | 3 | 13 | 0 | Force (not) sharing of tenant/org entities | |
| ad_language | 3 | 2 | 22 | 109 | Language ID |
| ad_org | 12 | 1 | 13 | 10 | Organizational entity within client |
| ad_org_v | 19 | view | AD_Org_v | ||
| ad_orginfo | 6 | 27 | 10 | Organization Info | |
| ad_orgtype | 1 | 12 | 3 | Organization Type allows you to categorize your organizations | |
| ad_preference | 3 | 17 | 17 | Personal Preference | |
| ad_printform | 1 | 25 | 2 | Form | |
| ad_registration | 2 | 26 | 0 | System Registration | |
| ad_system | 2 | 43 | 1 | System Definition | |
| ad_table | 1 | 2 | 35 | 1.052 | Table for the Fields |
| ad_user | 5 | 6 | 69 | 9 | User within the system - Internal or Business Partner Contact |
| c_bpartner | 3 | 8 | 74 | 18 | Identifies a Business Partner |
| c_country | 1 | 4 | 43 | 251 | Country |
| m_pricelist | 3 | 1 | 20 | 4 | Unique identifier of a Price List |
| m_warehouse | 3 | 3 | 19 | 11 | Storage Warehouse and Service Point |
| 17 Tables | 537 | 1.501 | |||
| 1 View | 19 |