Yep, that was one of my ideas too. So, less work will be necessary on C4 subs. But as said K. Fisher, if there are "deleted..." tables, it is probably for one reason?? Mathieu Galen Charlton a écrit :
Hi,
On Sun, Sep 15, 2013 at 6:41 AM, Mathieu Saby <mathieu.saby@univ-rennes2.fr <mailto: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 <mailto: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
-- Mathieu Saby Service d'Informatique Documentaire Service Commun de la Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.saby@univ-rennes2.fr