SchemaSpy Analysis of idempiere9.adempiereProduct Attribute 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
a_asset 2 7 69 0 Asset used internally or by customers
ad_table 3 32 1,029 Table for the Fields
c_bpartner 6 1 74 17 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     797 1,268  
1 View     16