[PHP-DB] Archiving data in a database From: Sanders, Nicholas (SandersN <email protected>)
Date: 11/23/00

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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>