[thelist] DB design question

Joel Canfield joel at spinhead.com
Fri Dec 6 15:29:01 CST 2002

[ Picked text/plain from multipart/alternative ]
> You would want to use a regular ID in the property table,
> wouldn't you?
> Property table:
> propertyID
> address

You could, but as rudy will tell you (which is why I know it now) you don't
need to add an artificially unique identifier when you already have one -
address. You're almost certainly not going to have two properties at the
same address, so use that field instead of creating an artificial one.


More information about the thelist mailing list