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