[Bug 13542] New: Subscripton is only table to store userid instead of borrowernumber
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13542 Bug ID: 13542 Summary: Subscripton is only table to store userid instead of borrowernumber Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Database Assignee: gmcharlt@gmail.com Reporter: katrin.fischer@bsz-bw.de QA Contact: testopia@bugs.koha-community.org When a new subscription is created in the serials module, the userid of the staff member is saved to subscripiton.librarian. This makes subscription the only table to store information about the patron not using the borrowernumber, but the userid instead. If you delete the staff member, his/her userid will stay in the subscription forever. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13542 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Also, if the userid changes, the information in the subscription table might get useless. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13542 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #2 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Can we envisage to simply remove this column? -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13542 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- We save the creator in lots of places, maybe we could replaces it with a creator/user... whatever that has a FK on borrowers with a SET NULL on deletion of the borrower? We could also look up the userid visible in the borrowers and deletedborrowers tables ... but that might not always lead to a correct borrowernumber (userid could have been reused... not sure if that happens often). A bit worried a library might complain, but at the same time I am not sure how useful it is to save the initial creator - if someone changes the subscription afer, noone will know. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org