Re: database structure for a dynamic product catalogue
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.
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.