https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28786 --- Comment #159 from Tomás Cohen Arazi <tomascohen@gmail.com> --- (In reply to Jonathan Druart from comment #28)
(In reply to Martin Renvoize from comment #27)
I've finally found a moment to look at this.
Whilst I like Tomas's proposal to normalise the database by having a distinct table.. I think that can certainly come as a followup later.
If we are talking about 3NF, I don't think having a separate table with a single column (different than the FK) is what can be called normalisation.
If that is what you have in mind, I think it's wrong: borrowers < 1-1 > secrets - borrowernumber (FK borrowers.borrowernumber) - secret
Look at bug 29924 and it will become obvious that we are just delaying the inevitable discussion. Which is fine. But I hope we solve on the next cycle. -- You are receiving this mail because: You are watching all bug changes.