SV: [thelist] DB Design question

[Steve Cook]

I would go with the active/inactive column myself - probably as a boolean datatype (true/false). I can't see any major reason for an extra table in a case like that unless you are going to (for instance) have different information in additional columns for active / inactive breeds.

.steve


########################
http://www.cookstour.org
######################## 


> -----Ursprungligt meddelande-----
> Från: Bob Haroche [mailto:spambait at onpointsolutions.com] 
> Skickat: den 15 september 2003 16:23
> Till: Evolt
> Ämne: [thelist] DB Design question
> 
<SNIP>
> 1. Adding an active/inactive column to the existing 
> AnimalBreeds table? 2. Creating an InactiveAnimalBreeds table 
> and moving the records back and forth between the two? 3. 
> Something else?
> <SNIP>