https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5670
--- Comment #66 from Alex Sassmannshausen <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
