I’m working on an application where several customers will be using the
same
database. I want them to be able to build their own entries for various
drop-down lists is if they were the only user of the application. I
also
don’t want to make building the drop-lists any harder than they need to
be.
I have thought of two ways to do this. I’d appreciate feedback and
comments
as to which method might be better .
-
Break normalization rules by putting the customer_id in every
drop-list
table. This would make it easier to create the droplists using the
‘acts_as_dropdown’ plugin. -
Keep the table fully normalized. Use find_by_sql to create the
necessary
joins to populate the drop-lists for each customer_id. -
Something else entirely.