SchemaSpy Analysis of idempiere11.adempiere - ConstraintsAssets Generated by
Quality Systems & Solutions
106 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
aaaddition_aachange a_asset_change.a_asset_addition_id a_asset_addition.a_asset_addition_id Restrict delete 
aaretirement_aachange a_asset_change.a_asset_retirement_id a_asset_retirement.a_asset_retirement_id Restrict delete 
aassetaddition_adepreciationex a_depreciation_exp.a_asset_addition_id a_asset_addition.a_asset_addition_id Restrict delete 
aassetchange_aassetchangeamt a_asset_change_amt.a_asset_change_id a_asset_change.a_asset_change_id Restrict delete 
aassetclass_aassetgroup a_asset_group.a_asset_class_id a_asset_class.a_asset_class_id Restrict delete 
aassetdisposed_adepreciationex a_depreciation_exp.a_asset_disposed_id a_asset_disposed.a_asset_disposed_id Restrict delete 
aassetgroup_aassetgroupacct a_asset_group_acct.a_asset_group_id a_asset_group.a_asset_group_id Cascade on delete 
aassetgroup_aassetgrouptrl a_asset_group_trl.a_asset_group_id a_asset_group.a_asset_group_id Cascade on delete 
aassetgroup_cinvoiceline c_invoiceline.a_asset_group_id a_asset_group.a_asset_group_id Restrict delete 
aassetgroup_mproductcategory m_product_category.a_asset_group_id a_asset_group.a_asset_group_id Restrict delete 
aassetspread_aassetacct a_asset_acct.a_asset_spread_id a_asset_spread.a_asset_spread_id Restrict delete 
aassettype_aassetgroup a_asset_group.a_asset_type_id a_asset_type.a_asset_type_id Restrict delete 
adepreciation_aassetacct a_asset_acct.a_depreciation_id a_depreciation.a_depreciation_id Restrict delete 
adepreciation_aassetgroupacct a_asset_group_acct.a_depreciation_id a_depreciation.a_depreciation_id Restrict delete 
adepreciationconv_aassetacct a_asset_acct.a_depreciation_conv_id a_depreciation_convention.a_depreciation_convention_id Restrict delete 
adepreciationconv_aassetgroupa a_asset_group_acct.a_depreciation_conv_id a_depreciation_convention.a_depreciation_convention_id Restrict delete 
adepreciationconvf_aassetacct a_asset_acct.a_depreciation_conv_f_id a_depreciation_convention.a_depreciation_convention_id Restrict delete 
adepreciationconvf_aassetgroup a_asset_group_acct.a_depreciation_conv_f_id a_depreciation_convention.a_depreciation_convention_id Restrict delete 
adepreciationentry_adepreciati a_depreciation_exp.a_depreciation_entry_id a_depreciation_entry.a_depreciation_entry_id Restrict delete 
adepreciationf_aassetacct a_asset_acct.a_depreciation_f_id a_depreciation.a_depreciation_id Restrict delete 
adepreciationf_aassetgroupacct a_asset_group_acct.a_depreciation_f_id a_depreciation.a_depreciation_id Restrict delete 
adepreciationmethod_aassetacct a_asset_acct.a_depreciation_method_id a_depreciation_method.a_depreciation_method_id Restrict delete 
adepreciationmethod_aassetgrou a_asset_group_acct.a_depreciation_method_id a_depreciation_method.a_depreciation_method_id Restrict delete 
adepreciationmethodf_aassetacc a_asset_acct.a_depreciation_method_f_id a_depreciation_method.a_depreciation_method_id Restrict delete 
adepreciationmethodf_aassetgro a_asset_group_acct.a_depreciation_method_f_id a_depreciation_method.a_depreciation_method_id Restrict delete 
adepreciationtableheader_aass2 a_asset_change.a_depreciation_table_header_id a_depreciation_table_header.a_depreciation_table_header_id Restrict delete 
adepreciationtableheader_aass3 a_asset_group_acct.a_depreciation_table_header_id a_depreciation_table_header.a_depreciation_table_header_id Restrict delete 
adepreciationtableheader_aasse a_asset_acct.a_depreciation_table_header_id a_depreciation_table_header.a_depreciation_table_header_id Restrict delete 
aduser_aassetchange a_asset_change.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_aassetdelivery a_asset_delivery.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 
afundingmode_adepreciationwork a_depreciation_workfile.a_fundingmode_id a_fundingmode.a_fundingmode_id Restrict delete 
afundingmode_afundingmodeacct a_fundingmode_acct.a_fundingmode_id a_fundingmode.a_fundingmode_id Restrict delete 
bplocation_aduser ad_user.bp_location_id c_location.c_location_id Restrict delete 
c_calendar_year c_year.c_calendar_id c_calendar.c_calendar_id Restrict delete 
c_currency_c_acctschema c_acctschema.c_currency_id c_currency.c_currency_id Restrict delete 
c_year_period c_period.c_year_id c_year.c_year_id Restrict delete 
cacctschema_aassetacct a_asset_acct.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_aassetchange a_asset_change.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_aassetchangeamt a_asset_change_amt.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_aassetgroupacct a_asset_group_acct.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_aassetrevalentry a_asset_reval_entry.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_aassettransfer a_asset_transfer.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_adepreciationentry a_depreciation_entry.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_adepreciationexp a_depreciation_exp.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_adepreciationworkf a_depreciation_workfile.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_afundingmodeacct a_fundingmode_acct.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cbpartner_aassetchange a_asset_change.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_aassetinfofin a_asset_info_fin.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_cbplocation c_bpartner_location.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_ccharge c_charge.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnerlocation_aassetchange a_asset_change.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbplocation_aduser ad_user.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
ccharge_aassetaddition a_asset_addition.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_cinvoiceline c_invoiceline.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_minoutline m_inoutline.c_charge_id c_charge.c_charge_id Restrict delete 
ccurrency_aassetaddition a_asset_addition.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_aassetrevalentry a_asset_reval_entry.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_adepreciationentry a_depreciation_entry.c_currency_id c_currency.c_currency_id Restrict delete 
cinvoiceline_aassetaddition a_asset_addition.c_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
cinvoiceline_aassetdisposed a_asset_disposed.c_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
cinvoiceline_aassetretirement a_asset_retirement.c_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
clocation_aassetchange a_asset_change.c_location_id c_location.c_location_id Restrict delete 
clocation_aduser ad_user.c_location_id c_location.c_location_id Restrict delete 
clocation_cbplocation c_bpartner_location.c_location_id c_location.c_location_id Restrict delete 
convoiceline_ref c_invoiceline.ref_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
cperiod_aassetdisposed a_asset_disposed.c_period_id c_period.c_period_id Restrict delete 
cperiod_aassetrevalentry a_asset_reval_entry.c_period_id c_period.c_period_id Restrict delete 
cperiod_aassetsplit a_asset_split.c_period_id c_period.c_period_id Restrict delete 
cperiod_aassettransfer a_asset_transfer.c_period_id c_period.c_period_id Restrict delete 
cperiod_adepreciationbuild a_depreciation_build.c_period_id c_period.c_period_id Restrict delete 
cperiod_adepreciationentry a_depreciation_entry.c_period_id c_period.c_period_id Restrict delete 
cperiod_cacctschema c_acctschema.c_period_id c_period.c_period_id Restrict delete 
createdby_aassetgrouptrl a_asset_group_trl.createdby ad_user.ad_user_id Restrict delete 
cuom_cinvoiceline c_invoiceline.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_minoutline m_inoutline.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_mproduct m_product.c_uom_id c_uom.c_uom_id Restrict delete 
minoutline_aassetaddition a_asset_addition.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_cinvoiceline c_invoiceline.m_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
minoutline_ref m_inoutline.ref_inoutline_id m_inoutline.m_inoutline_id Restrict delete 
mlocator_aassetaddition a_asset_addition.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_aassetproduct a_asset_product.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_minoutline m_inoutline.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_movementline m_movementline.m_locatorto_id m_locator.m_locator_id Restrict delete 
mlocator_mproduct m_product.m_locator_id m_locator.m_locator_id Restrict delete 
mlocatorto_mmovementline m_movementline.m_locator_id m_locator.m_locator_id Restrict delete 
moutline_aassetdelivery a_asset_delivery.m_inoutline_id m_inoutline.m_inoutline_id Cascade on delete 
mproduct_aassetaddition a_asset_addition.m_product_id m_product.m_product_id Restrict delete 
mproduct_aassetproduct a_asset_product.m_product_id m_product.m_product_id Restrict delete 
mproduct_cinvoiceline c_invoiceline.m_product_id m_product.m_product_id Restrict delete 
mproduct_minoutline m_inoutline.m_product_id m_product.m_product_id Restrict delete 
mproduct_mmovementline m_movementline.m_product_id m_product.m_product_id Restrict delete 
mproduct_mproductcategory m_product.m_product_category_id m_product_category.m_product_category_id Restrict delete 
mproduct_mproductdownload m_productdownload.m_product_id m_product.m_product_id Restrict delete 
mproductcat_parentcat m_product_category.m_product_category_parent_id m_product_category.m_product_category_id Restrict delete 
mproductdl_aassetdelivery a_asset_delivery.m_productdownload_id m_productdownload.m_productdownload_id Restrict delete 
rdefaultmailtext_aduser ad_user.r_defaultmailtext_id r_mailtext.r_mailtext_id Restrict delete 
reversalline_minoutline m_inoutline.reversalline_id m_inoutline.m_inoutline_id Restrict delete 
reversalline_mmovementline m_movementline.reversalline_id m_movementline.m_movementline_id Restrict delete 
rmailtext_mproduct m_product.r_mailtext_id r_mailtext.r_mailtext_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 
updatedby_aassetgrouptrl a_asset_group_trl.updatedby ad_user.ad_user_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected