Bug 26493 - Add missing FK constraints to aqbudgets
Summary: Add missing FK constraints to aqbudgets
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on: 18050
Blocks: 5334
  Show dependency treegraph
 
Reported: 2020-09-20 22:44 UTC by Katrin Fischer
Modified: 2021-10-28 13:23 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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