| 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 |