I'm trying to figure out what is the 'rails' way of doing this. I'm
expressing products and their variations. Variations are just
products that belong to a parent product. It's basically a tree
structure. Variations can also belong to other variations. What I'm
trying to decide is the best way to get all the descendents for a
product in one query and keep the table as normalized as possible.
The un-normalized way would be to add a root_id column, or I could use
a join table I guess. Any thoughts?