Hi, On Sun, Sep 15, 2013 at 6:41 AM, Mathieu Saby <mathieu.saby@univ-rennes2.fr>wrote:
- or by creating a new column 'deletedbiblionumber" in acqorders
I would prefer the 3d option (the "cleaner" for me, as I suppose removing foreign key is not good for integrity of DB), but I am very very far from being a database expert or a real developer.
For the sake of listing more possibilities, another option would be to merge deletedbiblio into biblio and add a Boolean column to indicate whether the bib is logically deleted or not. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org