SchemaSpy - idempiere11.adempiere

Project

Generated on 2024-01-03 13:54 +0100
Database Type: PostgreSQL - 15.5 (Ubuntu 15.5-1.pgdg22.04+1)
XML Representation Insertion Order Deletion Order

Comments

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	18	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	72	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	78	9	Material Shipment Document
m_inoutline	6	9	40	27	Line on Shipment or Receipt document
m_pricelist_version	2	1	16	6	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	39	4	Time and Expense Report Line

27 Tables			1.003	286
0 Views			0