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