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

Constraint Name Child Column Parent Column Delete Rule
adlabel_adlabelassignment ad_labelassignment.ad_label_id ad_label.ad_label_id Restrict delete 
adlabel_adlabeltrl ad_label_trl.ad_label_id ad_label.ad_label_id Cascade on delete 
adlabelcategory_adlabcattable ad_labelcategorytable.ad_labelcategory_id ad_labelcategory.ad_labelcategory_id Restrict delete 
adlabelcategory_adlabel ad_label.ad_labelcategory_id ad_labelcategory.ad_labelcategory_id Restrict delete 
adlabelcategory_adlabelcategor ad_labelcategory_trl.ad_labelcategory_id ad_labelcategory.ad_labelcategory_id Cascade on delete 
adtable_adlabelassignment ad_labelassignment.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adlabelcategorytable ad_labelcategorytable.ad_table_id ad_table.ad_table_id Restrict delete 
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_adlabelcategorytrl ad_labelcategory_trl.createdby ad_user.ad_user_id Restrict delete 
createdby_adlabeltrl ad_label_trl.createdby ad_user.ad_user_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_adlabelcategorytrl ad_labelcategory_trl.updatedby ad_user.ad_user_id Restrict delete 
updatedby_adlabeltrl ad_label_trl.updatedby 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