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