Bug 22480

Summary: itemtype/itype is used to join allot of tables, but often isn't defined as a key
Product: Koha Reporter: Martin Renvoize <martin.renvoize>
Component: DatabaseAssignee: Martin Renvoize <martin.renvoize>
Status: RESOLVED WONTFIX QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: jonathan.druart
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21150
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21842
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 5334    

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.