https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5670
--- Comment #67 from Jonathan Druart <[email protected]> --- (In reply to Alex Sassmannshausen from comment #66) > (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. My concern is more about the DB normalization, I think we need to keep that in mind and normalize it as much as possible to keep data integrity. I'd like to get more opinions before you start. -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug. _______________________________________________ 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/
