[Koha-bugs] [Bug 5670] Housebound Readers Module

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5670

--- Comment #66 from Alex Sassmannshausen <alex.sassmannshausen at 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.