Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

table relationships


Recommended Posts

Hello there. I was looking through the database diagram that came with osCommerceMS2. I am trying to understand the relationship between the tables products, products_to_categories, categories and categories_description.


So products to products_to_categories have a one to many relationship? Or is it one to one? The head of the arrow means it is pointing to the many side of a relationship, correct?



Link to comment
Share on other sites

because just having products and categories would mean a many to many relationship another table is introduced so:


product(many) - product_to_categories(one) - categories(many)

Your online success is Paramount.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...