[thelist] DB design question

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


--
[ Picked text/plain from multipart/alternative ]
> Why do you need to put amenities in a separate table.
> Couldn't you have a column for each type of amenity in the main table?

Every time you added a new amenity, you'd have to alter the table structure.
If the amenities are in a separate table, adding a new one is simply another
record in the table, a much less complex proposition. (See my previous
response for more details.)

joel



More information about the thelist mailing list