Re: database structure for a dynamic product catalogue
Posted by: Marion Gordon
Date: August 16, 2014 02:57AM

Hay friend,
I have 3 main ways of filtering products: by category, by manufacturer and by gender.

I have the following tables

products
- id
- name
- manufacturer_id
- gender_id

categories
- id
- name
- parent_id

products2categories
- id
- product_id
- category_id

manufacturers
- id
- name

gender
- id
- name
Using these tables I can list products e.g. find all products where manufacturer_id = 1, gender = 1, category= 453.

Options: ReplyQuote


Subject
Written By
Posted
Re: database structure for a dynamic product catalogue
August 16, 2014 02:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.