| SchemaSpy Analysis of idempiere9.adempiereClient & Organization | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:46 +0100 | |
| Database Type: PostgreSQL - 9.6.24 |
|
XML Representation Insertion Order Deletion Order |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| ad_client | 11 | 1 | 40 | 2 | Client/Tenant for this installation. |
| ad_clientinfo | 2 | 36 | 2 | AD_ClientInfo | |
| ad_clientshare | 3 | 13 | 0 | Client Share | |
| 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 | 26 | 10 | Organization Info | |
| ad_orgtype | 1 | 12 | 3 | Organization Type allows you to categorize your organizations | |
| ad_preference | 3 | 16 | 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 | 32 | 1,029 | Table for the Fields |
| ad_user | 5 | 6 | 68 | 8 | User within the system - Internal or Business Partner Contact |
| c_bpartner | 3 | 8 | 74 | 17 | Identifies a Business Partner |
| c_country | 1 | 4 | 43 | 251 | Country |
| m_pricelist | 3 | 1 | 20 | 3 | Unique identifier of a Price List |
| m_warehouse | 3 | 3 | 19 | 11 | Storage Warehouse and Service Point |
| 17 Tables | 528 | 1,475 | |||
| 1 View | 19 |