Bug 25878

Summary: Schema incorrectly describes course_items fields
Product: Koha Reporter: Andrew Fuerste-Henry <andrew>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: minor    
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:
Circulation function:

Description Andrew Fuerste-Henry 2020-06-25 16:20:21 UTC
On the schema page for the course_items table we include this comment on course_items.itype:
"new itemtype for the item to have while on reserve (optional)"

We have comparable notes for ccode, holdingbranch, and location.

That comment is not strictly correct. While a course is active, these fields in course_items will hold the items original values. If the course is marked inactive and the item's original values are returned to the items table, then the fields in course_items will hold the values that this item had while on reserve.

At this time I do not have alternate wording that explains this succinctly enough to put into the schema comment.
Comment 1 Katrin Fischer 2020-08-30 19:34:38 UTC
I believe this might have changed recently, as we have 3 columns now for each of the values that can be changed. Andrew, can you confirm?

`itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)
`itype_enabled` tinyint(1) NOT NULL DEFAULT 0, -- indicates if itype should be changed while on course reserve
`itype_storage` varchar(10) DEFAULT NULL, -- a place to store the itype when item is on course reserve