| SchemaSpy Analysis of idempiere11.adempiereTrees | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:56 +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_clientinfo | 10 | 37 | 2 | AD_ClientInfo | |
| ad_menu | 1 | 25 | 805 | Identifies a Menu | |
| ad_orginfo | 27 | 10 | Organization Info | ||
| ad_tree | 18 | 20 | 23 | Identifies a Tree | |
| ad_tree_favorite | 1 | 10 | 4 | Show user favorite menu on dashboard | |
| ad_tree_favorite_node | 1 | 3 | 18 | 24 | Favorite Node Tree |
| ad_treebar | 1 | 13 | 24 | User Selected tree nodes | |
| ad_treenode | 1 | 12 | 406 | Tree Node | |
| ad_treenodebp | 1 | 12 | 18 | Tree Node BP | |
| ad_treenodemm | 1 | 12 | 806 | Tree Node MM | |
| ad_treenodepr | 1 | 12 | 55 | Tree Node PR | |
| ad_treenodeu1 | 1 | 12 | 0 | User defined tree 1 | |
| ad_treenodeu2 | 1 | 12 | 0 | User defined tree 2 | |
| ad_treenodeu3 | 1 | 12 | 0 | User defined tree 3 | |
| ad_treenodeu4 | 1 | 12 | 0 | User defined tree 4 | |
| c_activity | 1 | 14 | 0 | Business Activity | |
| c_bpartner | 4 | 1 | 74 | 18 | Identifies a Business Partner |
| c_element | 1 | 1 | 16 | 1 | Accounting Element |
| c_elementvalue | 1 | 30 | 379 | Account Element | |
| c_project | 3 | 48 | 2 | Financial Project | |
| c_salesregion | 15 | 2 | Sales coverage region | ||
| m_product | 1 | 1 | 72 | 55 | Product Service Item |
| m_product_category | 2 | 1 | 19 | 14 | Category of a Product |
| 23 Tables | 534 | 2.648 | |||
| 0 Views | 0 |