[thelist] DB Schema Design
Ian Anderson
ian at zstudio.co.uk
Mon May 8 11:16:18 CDT 2006
Matt Warden wrote:
>> This table is not normalised: the values for class should be moved out
>> into some other table and related with a foreign key.
>
> You can do this, but it is not necessary.
Mmmm. No, not necessary, but good practice I'd say.
Consider any other single column with a relatively fixed set of values.
You could argue the same, mais non?
>> And the values in this table would then need to define which table in
>> the database the associated statuses belong to:
>
> Why? As far as I can tell, there's no reason to do this.
It's called "Being hit by a bus".
If the developer ain't around no more for any reason, I'd like there to
be an explicit notation of which table these puppies belong to, and not
just in a ring binder on some shelf with three thousand other pieces of
paper, neither.
--
zStudio - Web development and accessibility
- http://zStudio.co.uk
Snippetz.net - Your personal, private code library
- http://snippetz.net
More information about the thelist
mailing list