SchemaSpy Analysis of idempiere11.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 |