| SchemaSpy Analysis of idempiere9.adempiereProduct BOM | 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 / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| m_attributesetinstance | 2 | 15 | 4 | Product Attribute Set Instance | |
| m_bom | 2 | 2 | 17 | 1 | Bill of Material |
| m_bomalternative | 1 | 1 | 12 | 1 | Product BOM Alternative Group |
| m_bomproduct | 6 | 23 | 0 | Bill of Material Component (Product) | |
| m_changenotice | 6 | 16 | 1 | Change Notice | |
| m_changerequest | 1 | 2 | 19 | 0 | Change Request |
| m_operationresource | 1 | 18 | 0 | Product Operation Resource | |
| m_product | 8 | 1 | 72 | 55 | Product Service Item |
| m_product_acct | 1 | 34 | 110 | Product Acct | |
| m_product_bom | 15 | view | BOM Line | ||
| m_productoperation | 2 | 1 | 16 | 0 | Product Operation |
| r_category | 1 | 1 | 13 | 3 | Request Category |
| r_group | 1 | 2 | 15 | 2 | Request Group |
| r_request | 1 | 8 | 65 | 1 | Request from a Business Partner or Prospect |
| r_requesttype | 1 | 25 | 3 | Type of request (e.g. Inquiry, Complaint, ..) | |
| 14 Tables | 360 | 181 | |||
| 1 View | 15 |