SchemaSpy Analysis of idempiere9.adempiere - ConstraintsRegistration Generated by
Quality Systems & Solutions
29 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
aasset_aregistration a_registration.a_asset_id a_asset.a_asset_id Restrict delete 
ad_language_c_buspartner c_bpartner.ad_language ad_language.ad_language Restrict delete 
adenritytype_admodification ad_modification.entitytype ad_entitytype.entitytype Restrict delete 
adreference_adprocesspara ad_process_para.ad_reference_id ad_reference.ad_reference_id Restrict delete 
adreference_aregattribute a_registrationattribute.ad_reference_id ad_reference.ad_reference_id Restrict delete 
adreferencevalue_adprocpara ad_process_para.ad_reference_value_id ad_reference.ad_reference_id Restrict delete 
adreferencevalue_aregattribute a_registrationattribute.ad_reference_value_id ad_reference.ad_reference_id Restrict delete 
adsystem_adregistration ad_registration.ad_system_id
ad_registration.ad_client_id
ad_system.ad_system_id
ad_system.ad_client_id
Restrict delete 
aduser_aasset a_asset.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_aregistration a_registration.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_supervisor ad_user.supervisor_id ad_user.ad_user_id Restrict delete 
adusersalesrep_cbpartner c_bpartner.salesrep_id ad_user.ad_user_id Null on delete 
aparentasset_aasset a_asset.a_parent_asset_id a_asset.a_asset_id Restrict delete 
aregattribute_aregproduct a_registrationproduct.a_registrationattribute_id a_registrationattribute.a_registrationattribute_id Restrict delete 
aregattribute_aregvalue a_registrationvalue.a_registrationattribute_id a_registrationattribute.a_registrationattribute_id Cascade on delete 
aregistration_aregvalue a_registrationvalue.a_registration_id a_registration.a_registration_id Cascade on delete 
cbpartner_aasset a_asset.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_aduser ad_user.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_aregistration a_registration.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnersr_aasset a_asset.c_bpartnersr_id c_bpartner.c_bpartner_id Restrict delete 
entityt_adprocesspara ad_process_para.entitytype ad_entitytype.entitytype Restrict delete 
entityt_adreference ad_reference.entitytype ad_entitytype.entitytype Restrict delete 
leasebpartner_aasset a_asset.lease_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
mproduct_aasset a_asset.m_product_id m_product.m_product_id Restrict delete 
mproduct_aregistration a_registration.m_product_id m_product.m_product_id Restrict delete 
mproduct_aregproduct a_registrationproduct.m_product_id m_product.m_product_id Restrict delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 
salesrep_mproduct m_product.salesrep_id ad_user.ad_user_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected