Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

table relationships


thelight

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?

 

Art

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

Archived

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

×
×
  • Create New...