Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

database structure, explain of some tables


calypse

Recommended Posts

Hi guys,

 

I am posting a question to which I did not found response until now.

I am rewriting our company database in order to conform to the structure of oscommerce. We will use Postgresql then and i do not have access to Mysql database.

 

My question is: what is the "product_option_values_to_product_options" table? is it a join table for a relation many-many? Or is it a validation table that provides the options for "product attributes table"?

I do not understand, but this may be related to my limited experience in database design. I created the tables product options and p.o.values , i set the relationship between them and "P.O to P.O.V" then I created product attributes believing that in this Way I could only choose an already set record but it is not working in this way (I can choose whatever combination i want, i.e. color and 64 mb) Could you please explain me better?

 

Sorry for my inexperience and for my english.

 

Best

 

Cristian

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...