| SchemaSpy Analysis of idempiere11.adempiereCRM | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:48 +0100 | |
| Database Type: PostgreSQL - 15.5 (Ubuntu 15.5-1.pgdg22.04+1) |
|
XML Representation Insertion Order Deletion Order |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| c_bpartner_location | 1 | 23 | 16 | 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 | 48 | |||
| 1 View | 10 |