| 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 | ||