[thelist] DB design question

[matt g]

> From: Joel Canfield <joel at spinhead.com>
>
> Property table:
> address
>
> PropertyAmenities table:
> Property.address
> Amenities.amenityID

Hi,
You would want to use a regular ID in the property table, wouldn't you?

Property table:
propertyID
address

PropertyAmenities table:
Property.propertyID
Amenities.amenityID

That way, you're indexing/searching for a number rather than a string in the
PropertyAmenties table. Seems faster. Please tell me if there's a reason
that it's not.

Thanks,
matt g