| SchemaSpy Analysis of idempiere11.adempiereRequest Management | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:55 +0100 | |
| Database Type: PostgreSQL - 15.5 (Ubuntu 15.5-1.pgdg22.04+1) |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| a_asset | 4 | 7 | 69 | 0 | Asset used internally or by customers |
| a_asset_delivery | 2 | 25 | 0 | Delivery of Asset | |
| ad_role | 2 | 1 | 56 | 5 | Responsibility Role |
| ad_smtp | 18 | 0 | SMTP Server | ||
| ad_table | 1 | 35 | 1.052 | Table for the Fields | |
| ad_user | 24 | 4 | 69 | 9 | User within the system - Internal or Business Partner Contact |
| ad_usermail | 2 | 21 | 1 | Mail sent to the user | |
| c_activity | 4 | 14 | 0 | Business Activity | |
| c_bp_group | 1 | 23 | 3 | Business Partner Group | |
| c_bpartner | 11 | 3 | 74 | 18 | Identifies a Business Partner |
| m_changenotice | 4 | 16 | 1 | Change Notice | |
| m_changerequest | 1 | 2 | 19 | 0 | Change Request |
| m_inout | 5 | 11 | 78 | 9 | Material Shipment Document |
| m_product | 7 | 2 | 72 | 55 | Product Service Item |
| m_rma | 4 | 4 | 31 | 1 | Return Material Authorization |
| r_category | 3 | 1 | 13 | 3 | Request Category |
| r_categoryupdates | 2 | 11 | 1 | R_CategoryUpdates | |
| r_contactinterest | 2 | 12 | 1 | R_ContactInterest | |
| r_group | 3 | 1 | 15 | 2 | Request Group |
| r_groupupdates | 2 | 11 | 1 | R_GroupUpdates | |
| r_interestarea | 1 | 13 | 2 | Interest Area or Topic | |
| r_mailtext | 4 | 15 | 3 | Text templates for mailings | |
| r_request | 4 | 21 | 66 | 1 | Request from a Business Partner or Prospect |
| r_requestaction | 16 | 46 | 2 | Request History | |
| r_requestprocessor | 1 | 2 | 24 | 1 | Request Processor |
| r_requestprocessor_route | 3 | 14 | 1 | Automatic routing of requests | |
| r_requesttype | 5 | 1 | 25 | 3 | Type of request (e.g. Inquiry, Complaint, ..) |
| r_requesttypeupdates | 2 | 11 | 1 | Request Type Updates | |
| r_requestupdate | 2 | 17 | 1 | Request Update | |
| r_requestupdates | 2 | 11 | 0 | Request Update Recipiants | |
| r_resolution | 2 | 12 | 3 | Request Resolution | |
| r_standardresponse | 1 | 11 | 1 | Request Standard Response | |
| r_status | 4 | 3 | 23 | 4 | Request Status |
| r_statuscategory | 2 | 13 | 1 | Request Status Category | |
| 34 Tables | 983 | 1.186 | |||
| 0 Views | 0 |