I'm creating a database schema for a internet store and I wonder how to better create the tables "images" and "products". A simpler way will be to have it as one_to_many, that is:
images(....., product_id references products(id))
The more flexible way is to create it as many_to_many. However, I can't think of any scenario where I'll really need this products <-> many_to_many <-> images
relationship, that is, where I'll reuse images for more that one product.
What would you recommend? Is there anything I'm missing? When will I need many_to_many in my case?