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