Archiving data in a database
| From: | Sanders, Nicholas | Date: | Thu, 23 Nov 2000 10:20:14 +0000 |
| Subject: | Archiving data in a database | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4684@lists.php.net to get a copy of this message | ||
Hi,
I'm designing a staff database and I've got about 20 tables some of them
with 1 to many relationships i.e A member of staff can have multiple email
addresses.
What I'm trying to work out is what to do when I delete a member of staff I
don't want to loose the data so how do I archive it.
Should I create a replica of all the tables, or one table for each member of
staff deleted?
Any Ideas ?
Cheers
Nick