Bug 22480 - itemtype/itype is used to join allot of tables, but often isn't defined as a key
Summary: itemtype/itype is used to join allot of tables, but often isn't defined as a key
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: master
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Martin Renvoize
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks: 5334
  Show dependency treegraph
 
Reported: 2019-03-08 08:10 UTC by Martin Renvoize
Modified: 2019-03-08 22:14 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 Martin Renvoize 2019-03-08 08:10:03 UTC
The itype and itemtype fields in many tables refer to the itemtypes table but are not defined as foreign keys.. they should be to prevent data corruption.