RE: [PHP-DB] Archiving data in a database From: Chris Mason (chris <email protected>)
Date: 11/23/00

How about havingng an "active" switch in a field, so you can switch off a
staff member without purging the record. I rarely delete data, ususally I
turn the record off.

Chris Mason
Box 340, The Valley, Anguilla, British West Indies
Tel: 264 497 5670 Fax: 264 497 8463
USA Fax (561) 382-7771
Take a virtual tour of the island
http://net.ai/ The Anguilla Guide
Find out more about NetConcepts
www.netconcepts.ai
Talk to me in real time with Instant Messenger: masonc92 <email protected>

-----Original Message-----
From: php-db-return-4684-chris=net.ai <email protected>
[mailto:php-db-return-4684-chris=net.ai <email protected>]On Behalf Of
Sanders, Nicholas
Sent: Thursday, November 23, 2000 6:20 AM
To: php-db <email protected> php. net (E-mail)
Subject: [PHP-DB] Archiving data in a database

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>

-- 
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>