Displaying 1 result from an estimated 1 matches for "has_pool".
Did you mean:
has_pal
2010 Jan 25
15
database design question: building features
...nt database architectures for
an application to manage properties. For capturing the property
features, I have two options: a single model/table with all the features
as fields, or a set of joined models - property, feature, feature data.
(see attached ERD diagram)
OPTION A
Properties
name
address
has_pool
has_doorman
has_etc. (a bunch of values, not all boolean)
=OR=
OPTION B
Properties
id
name
address
Features
id
title
featurable_type (polymorphic, in this case points to "property.id")
data_type
Feature_Data
id
feature_id
featureable_id (polymorphic, in this case points to "prope...