SchemaSpy Analysis of idempiere9.adempiereCRM Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:47 +0100
Database Type: PostgreSQL - 9.6.24

XML Representation
Insertion Order Deletion Order

Table / View Children Parents Columns Rows Comments
c_bpartner_location 1 23 13 Identifies the (ship to) address for this Business Partner
c_campaign 2 17 2 Marketing Campaign
c_contactactivity 1 18 0 Events, tasks, communications related to a contact
c_cycle 1 12 2 Identifier for this Project Reporting Cycle
c_cyclestep 1 13 4 The step for this Cycle
c_opportunity 1 2 24 0 Sales Opportunity
c_paymentterm 1 30 5 The terms for Payment of this transaction
c_phase 1 16 13 Standard Phase of the Project Type
c_project 1 4 48 2 Financial Project
c_projectline 1 31 1 Task or step in a project
c_salesdashboard 10 view Sales Dashboard
c_salesstage 1 15 0 Stages of the sales process
m_bp_price 22 0 Business Partner specific pricing that will override the price list
r_contactinterest 1 12 1 R_ContactInterest
r_interestarea 1 13 2 Interest Area or Topic
           
14 Tables     294 45  
1 View     10