[Koha-bugs] [Bug 11617] Add itemnumber constraint to aqorders_items

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11617

Galen Charlton <gmcharlt at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |gmcharlt at gmail.com

--- Comment #10 from Galen Charlton <gmcharlt at gmail.com> ---
(In reply to M. de Rooy from comment #9)
> (In reply to Katrin Fischer from comment #8)
> > On the contrary I woudl argue that we should not remove the
> > biblionumber on cancelling an order, as I can see no reason why this would
> > be necessary.
> If we keep the itemnumber, we should certainly keep the biblionumber too.
> Rather see a title (marked as deleted) instead of Deleted bibliographic
> notice, can't find title.

It's a pity not having the foreign key constraints, but on balance there's too
much potential need for library staff to need to refer to both ordered bibs and
items for a period of time, even after the items or bibs are deleted in
cataloging.

This is going a bit far off, but I think we should consider adding a Boolean
"is deleted" flag to biblio and items, to represent the case where an item or
bib no longer is held by the library but is still referred to by other records
that need to be kept for some archival purpose.  This would make us more free
to add FK constraints, at the cost of needing more code to distinguished
between a merely deleted and a fully purged bib or item.

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