https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5670 --- Comment #66 from Alex Sassmannshausen <alex.sassmannshausen@ptfs-europe.com> --- (In reply to Jonathan Druart from comment #65)
(In reply to Jonathan Druart from comment #64)
My alternative proposal now would be: - create a new custom table "housebound_role" - with three columns (borrower_id, deliverer, chooser)
The PK for this new table would be borrower_id, so should not it be 2 new columns in the borrowers table instead?
I considered that, but proposed a new table because: - the borrowers table is quite large as it is. Adding columns to it would make it slightly less discoverable - the vast majority of borrowers in the system will have neither a "deliverer" nor a "chooser" role, so those columns will just be empty/false in the borrowers table (this is particularly the case if the housebound module is switched off!). - in the housebound_role table the columns will only exist if the borrower is in fact a volunteer of some form (either chooser or deliverer), so each entry will be "doing something". Conversely, joins are quite cheap, so I think I prefer this design. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.