SchemaSpy Analysis of idempiere9.adempiere - ConstraintsCollaboration Management Generated by
Quality Systems & Solutions
16 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
adtable_adpostit ad_postit.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_cmchat cm_chat.ad_table_id ad_table.ad_table_id Cascade on delete 
adtable_cmchattype cm_chattype.ad_table_id ad_table.ad_table_id Cascade on delete 
aduser_cmchatentry cm_chatentry.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_cmchattypeupdate cm_chattypeupdate.ad_user_id ad_user.ad_user_id Cascade on delete 
aduser_cmchatupdate cm_chatupdate.ad_user_id ad_user.ad_user_id Cascade on delete 
aduser_supervisor ad_user.supervisor_id ad_user.ad_user_id Restrict delete 
cmchat_chchatentry cm_chatentry.cm_chat_id cm_chat.cm_chat_id Cascade on delete 
cmchat_cmchatupdate cm_chatupdate.cm_chat_id cm_chat.cm_chat_id Cascade on delete 
cmchatentry_grandparent cm_chatentry.cm_chatentrygrandparent_id cm_chatentry.cm_chatentry_id Restrict delete 
cmchattype_cmchat cm_chat.cm_chattype_id cm_chattype.cm_chattype_id Null on delete 
cmchattype_cmchattypeupdate cm_chattypeupdate.cm_chattype_id cm_chattype.cm_chattype_id Cascade on delete 
cmentrty_cmentryparent cm_chatentry.cm_chatentryparent_id cm_chatentry.cm_chatentry_id Restrict delete 
createdby_adpostit ad_postit.createdby ad_user.ad_user_id Restrict delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 
updatedby_adpostit ad_postit.updatedby ad_user.ad_user_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected