[thelist] DB Schema Design
Matt Warden
mwarden at gmail.com
Mon May 8 10:37:43 CDT 2006
-----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-----
More information about the thelist
mailing list