Bug 26493

Summary: Add missing FK constraints to aqbudgets
Product: Koha Reporter: Katrin Fischer <katrin.fischer>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: jonathan.druart
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on: 18050    
Bug Blocks: 5334    

Description Katrin Fischer 2020-09-20 22:44:45 UTC
There are several column in aqbudgets that should have FK constraints on them:

budget_branchcode
=> branches.branchcode

budget_owner_id
=> borrowers.borrowernumber

sort1_authcat
sort2_authcat
=> authorised_value_categories.category_name