| SchemaSpy Analysis of idempiere11.adempiereWebStore | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:57 +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_client | 7 | 1 | 42 | 2 | Tenant for this installation. |
| ad_clientinfo | 3 | 37 | 2 | AD_ClientInfo | |
| ad_language | 4 | 1 | 22 | 109 | Language ID |
| ad_user | 12 | 5 | 69 | 9 | User within the system - Internal or Business Partner Contact |
| ad_usermail | 3 | 21 | 1 | Mail sent to the user | |
| c_bpartner | 8 | 8 | 74 | 18 | Identifies a Business Partner |
| c_paymentterm | 3 | 30 | 5 | The terms for Payment of this transaction | |
| m_pricelist | 5 | 1 | 20 | 4 | Unique identifier of a Price List |
| m_product | 4 | 3 | 72 | 55 | Product Service Item |
| m_warehouse | 2 | 2 | 19 | 11 | Storage Warehouse and Service Point |
| r_mailtext | 4 | 15 | 3 | Text templates for mailings | |
| r_request | 1 | 7 | 66 | 1 | Request from a Business Partner or Prospect |
| w_advertisement | 4 | 28 | 1 | Web Advertisement | |
| w_basket | 1 | 3 | 14 | 0 | Web Basket |
| w_basketline | 2 | 16 | 0 | Web Basket Line | |
| w_click | 2 | 19 | 0 | Individual Web Click | |
| w_clickcount | 2 | 1 | 13 | 1 | Web Click Management |
| w_counter | 2 | 19 | 0 | Individual Count hit | |
| w_countercount | 2 | 1 | 13 | 1 | Web Counter Count Management |
| w_mailmsg | 2 | 1 | 17 | 0 | Web Store Mail Message Template |
| w_mailmsg_trl | 2 | 15 | 0 | Web Store Mail Message Template | |
| w_store | 2 | 5 | 43 | 1 | A Web Store of the Client |
| w_store_trl | 2 | 20 | 1 | A Web Store of the Tenant | |
| 23 Tables | 704 | 225 | |||
| 0 Views | 0 |