| SchemaSpy Analysis of idempiere11.adempiereProduct Attribute | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:53 +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 |
|---|---|---|---|---|---|
| a_asset | 2 | 7 | 69 | 0 | Asset used internally or by customers |
| ad_table | 3 | 35 | 1.052 | Table for the Fields | |
| c_bpartner | 6 | 1 | 74 | 18 | Identifies a Business Partner |
| c_bpartner_product | 2 | 18 | 1 | Product Business Partner | |
| c_invoiceline | 1 | 6 | 51 | 24 | Invoice Detail Line |
| c_orderline | 4 | 5 | 59 | 27 | Sales Order Line |
| c_projectissue | 2 | 4 | 27 | 0 | Project Issues (Material, Labor) |
| c_rfqline | 2 | 18 | 2 | Request for Quotation Line | |
| m_attribute | 3 | 1 | 19 | 4 | Product Attribute |
| m_attributeinstance | 3 | 14 | 5 | M_AttributeInstance | |
| m_attributesearch | 1 | 11 | 1 | Common Search Attribute | |
| m_attributeset | 4 | 2 | 29 | 4 | Product Attribute Set |
| m_attributesetexclude | 2 | 12 | 0 | Exclude the ability to enter Attribute Sets | |
| m_attributesetinstance | 16 | 2 | 15 | 4 | Product Attribute Set Instance |
| m_attributeuse | 2 | 11 | 5 | M_AttributeUse | |
| m_attributevalue | 1 | 1 | 13 | 9 | Product Attribute Value |
| m_inoutline | 8 | 5 | 40 | 27 | Line on Shipment or Receipt document |
| m_inventoryline | 4 | 3 | 25 | 1 | Unique line in an Inventory document |
| m_lot | 1 | 2 | 16 | 0 | Product Lot Definition |
| m_lotctl | 3 | 16 | 1 | Product Lot Control | |
| m_lotctlexclude | 2 | 12 | 0 | Exclude the ability to create Lots in Attribute Sets | |
| m_movementline | 2 | 4 | 24 | 1 | Inventory Move document Line |
| m_product | 15 | 2 | 72 | 55 | Product Service Item |
| m_productionline | 3 | 2 | 21 | 0 | Document Line representing a production |
| m_sernoctl | 2 | 16 | 1 | Product Serial Number Control | |
| m_sernoctlexclude | 2 | 12 | 0 | Exclude the ability to create Serial Numbers in Attribute Sets | |
| m_storage | 16 | view | M_Storage | ||
| m_storageonhand | 2 | 14 | 20 | M_StorageOnHand | |
| m_storagereservation | 2 | 14 | 2 | M_StorageReservation | |
| m_transaction | 2 | 7 | 21 | 28 | Inventory Transaction |
| m_transactionallocation | 10 | 22 | 0 | M_TransactionAllocation | |
| 30 Tables | 800 | 1.292 | |||
| 1 View | 16 |