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 |