Topic: Triple Join
How would I represent the :has_many_and_is_a 'products_lookup_options' in this triple table join?
Basic explanation of my situation:
Products/lookup relationship: Have multiple types of products (recorded in lookup where type=product_type).
Lookup/options relationship: Each type has a set of properties (which may or may not be set -- can be null). So, options declares what lookup.type values are associated with the specific 'product_type', and in what order (you can have multiple uses for the same dataset in some cases eg. transmit and receive frequency).
Triple join: The triple join table links the lookup_id to the option_id where lookup.type = options.lookup_type, and those are linked to the product where product.lookup_id = options.lookup_id.
Hope that makes some level of sense.
Last edited by KittyKate (2007-03-06 17:34:35)