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

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 54 5 Responsibility Role
ad_smtp 18 0 SMTP Server
ad_table 1 32 1,029 Table for the Fields
ad_user 24 4 68 8 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 17 Identifies a Business Partner
m_changenotice 4 16 1 Change Notice
m_changerequest 1 2 19 0 Change Request
m_inout 5 11 77 9 Material Shipment Document
m_product 7 2 72 55 Product Service Item
m_rma 4 4 30 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 65 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     974 1,161  
0 Views     0