| SchemaSpy Analysis of idempiere9.adempiereProduct Price | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:54 +0100 | |
| Database Type: PostgreSQL - 9.6.24 |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| c_bpartner | 6 | 5 | 74 | 17 | Identifies a Business Partner |
| c_bpartner_product | 2 | 18 | 1 | Product Business Partner | |
| m_discountschema | 5 | 19 | 3 | Schema to calculate the trade discount percentage | |
| m_discountschemabreak | 3 | 16 | 1 | Trade Discount Break | |
| m_discountschemaline | 4 | 43 | 11 | Line of the pricelist trade discount schema | |
| m_pricelist | 5 | 1 | 20 | 3 | Unique identifier of a Price List |
| m_pricelist_version | 3 | 3 | 16 | 5 | Identifies a unique instance of a Price List |
| m_product | 7 | 1 | 72 | 55 | Product Service Item |
| m_product_category | 4 | 1 | 19 | 14 | Category of a Product |
| m_product_po | 2 | 32 | 29 | Product Purchasing | |
| m_productprice | 2 | 14 | 86 | Product Price | |
| m_productpricevendorbreak | 3 | 16 | 0 | Product Price Break | |
| m_promotion | 4 | 13 | 0 | Promotion setup | |
| m_promotiondistribution | 2 | 2 | 16 | 0 | Distribute order line items into multiple bucket for reward calculation |
| m_promotiongroup | 2 | 11 | 0 | Grouping of product for promotion setup | |
| m_promotiongroupline | 2 | 11 | 0 | Line items of a promotion group | |
| m_promotionline | 1 | 2 | 13 | 0 | Promotion line items |
| m_promotionprecondition | 3 | 21 | 0 | Pre condition for promotion | |
| m_promotionreward | 3 | 20 | 0 | Setup reward for the promotion | |
| 19 Tables | 464 | 225 | |||
| 0 Views | 0 |