| SchemaSpy Analysis of idempiere11.adempiereProduct BOM | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:54 +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 |
|---|---|---|---|---|---|
| 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 | 66 | 1 | Request from a Business Partner or Prospect |
| r_requesttype | 1 | 25 | 3 | Type of request (e.g. Inquiry, Complaint, ..) | |
| 14 Tables | 361 | 181 | |||
| 1 View | 15 |