[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

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

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

--- Comment #7 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
(In reply to Andrew Isherwood from comment #6)
> But it's just a foreign key to the (now deleted) bib ID, is that useful
> information that needs preserving? Sorry, genuine question, I'm not being
> facetious :)

As long as the bilbio_id is there, you can join on the deleted* tables and get
information about the records that were requested. This is interesting
information to libraries. Example: if a record was requested multiple times,
they might to purchase it. If records from a certain subject are ordered more
than other subjects, they might want to shift the budget in this direction,
etc.

-- 
You are receiving this mail because:
You are watching all bug changes.