[thelist] DB Schema Design

[Matt Warden]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ian Anderson wrote:
> tbl_statuses
> ID Status    Class
> 1  On order  product
> 2  Declined  payment
> 3  Not live  customer
> 4  In stock  product
> 5  Live      customer
> 
> 
> 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.

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

- --
Matt Warden
Miami University
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFEX2XHrI3LObhzHRMRAqOvAJkBUB/5Oa5Vi+xRxUXs4s6RCWzLqACfYxrV
O/w92ws0GwzkS3kj7/FE+So=
=92vd
-----END PGP SIGNATURE-----