SchemaSpy Analysis of idempiere9.adempiereProject 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 Children Parents Columns Rows Comments
a_asset 2 8 69 0 Asset used internally or by customers
c_activity 9 14 0 Business Activity
c_bpartner 16 3 74 17 Identifies a Business Partner
c_cycle 1 12 2 Identifier for this Project Reporting Cycle
c_cyclephase 2 10 10 C_CyclePhase
c_cyclestep 1 1 13 4 The step for this Cycle
c_invoice 5 8 71 8 Invoice Identifier
c_invoiceline 2 10 51 24 Invoice Detail Line
c_order 9 11 92 8 Order
c_orderline 5 10 59 27 Sales Order Line
c_paymentterm 5 30 5 The terms for Payment of this transaction
c_phase 4 2 16 13 Standard Phase of the Project Type
c_project 11 8 48 2 Financial Project
c_projectissue 3 5 27 0 Project Issues (Material, Labor)
c_projectline 7 31 1 Task or step in a project
c_projectphase 6 4 27 0 Phase of a Project
c_projecttask 5 3 20 0 Actual Project Task in a Phase
c_projecttype 2 13 4 Type of the project
c_task 1 2 16 9 Standard Project Type Task
m_inout 3 10 77 9 Material Shipment Document
m_inoutline 6 9 40 27 Line on Shipment or Receipt document
m_pricelist_version 2 1 16 5 Identifies a unique instance of a Price List
m_product 12 1 72 55 Product Service Item
m_transaction 3 21 28 Inventory Transaction
m_warehouse 6 1 19 11 Storage Warehouse and Service Point
s_resource 1 1 24 11 Resource
s_timeexpenseline 1 8 38 4 Time and Expense Report Line
           
27 Tables     1,000 284  
0 Views     0