Displaying 1 result from an estimated 1 matches for "categories_images".
2006 Jan 14
0
Compact db design a bad idea?
...ree
tables
categories
- id
- name
products
- id
- name
images
- id
- filename
What I can''t decide on is how to do the join tables.
Option 1 - would have many join tables and require many join models.
(The join models are to use the position field for acts_as_list to
order the images)
categories_images
- category_id
- image_id
images_products
- product_id
_ image_id
Option 2 - have a one generic join table and only one join model
image_joins
- owner_class
- owner_id
- image_id
In option 2 a record could be (Category, 2, 3) or (Product, 4, 1)
--------
Option 1 seems simpler but could lead to...