SchemaSpy Analysis of idempiere9.adempiereRfQ Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:55 +0100
Database Type: PostgreSQL - 9.6.24

XML Representation
Insertion Order Deletion Order

Table Children Parents Columns Rows Comments
ad_printformat 2 31 89 Data Print Format
ad_user 13 4 68 8 User within the system - Internal or Business Partner Contact
c_bpartner 11 5 74 17 Identifies a Business Partner
c_bpartner_location 8 1 23 13 Identifies the (ship to) address for this Business Partner
c_bpartner_product 2 18 1 Product Business Partner
c_currency 4 19 175 The Currency for this record
c_order 5 17 92 8 Order
c_rfq 2 7 38 1 Request for Quotation
c_rfq_topic 2 1 13 1 Topic for Request for Quotations
c_rfq_topicsubscriber 1 4 15 2 Request for Quotation Topic Subscriber
c_rfq_topicsubscriberonly 3 13 0 Include Subscriber only for certain products or product categories
c_rfqline 2 3 18 2 Request for Quotation Line
c_rfqlineqty 1 2 19 2 Request for Quotation Line Quantity
c_rfqresponse 1 6 31 0 Request for Quotation Response from a potential Vendor
c_rfqresponseline 1 2 18 0 Request for Quotation Response Line
c_rfqresponselineqty 2 14 0 Request for Quotation Response Line Quantity
c_uom 2 17 15 Unit of Measure
m_attributesetinstance 2 15 4 Product Attribute Set Instance
m_pricelist 5 2 20 3 Unique identifier of a Price List
m_pricelist_version 1 2 16 5 Identifies a unique instance of a Price List
m_product 3 4 72 55 Product Service Item
m_product_category 3 1 19 14 Category of a Product
r_contactinterest 1 12 1 R_ContactInterest
           
23 Tables     675 416  
0 Views     0