Hi all,
The table structures are below.
The table category_cat is built on the adjacency model (where the parent and child entries are both stored in the same table). For my problem, I've created 3 tables for example. The category_cat table containts drill-downs of pets (from animal type to animal color). I have the table product_pdt that containts "I hate shirts" of every animal category. And the table pdttocat_ptc...
ZoeNet
Last Activity: Oct 19 '07, 04:14 PM
Joined: Sep 28 '07
Location:
-
Adjacency model problem
-
I'll try that thanks... -
If I take a single size product (the camping chair) with your structure, I still need to enter a size to the product witch I don't think is applicable for a single size product. And for the price it should be in the table size because the price varies with the different size of the product....Leave a comment:
-
Database design problem
I'm trying to built a database for ecommerce and I'm stuck with this problem.
I'll use a grocery store for the example.
First here's the tables.
table product_prd
id_prd
name_prd
description_prd
A product may have different "sizes" like a bag of chips. The table product_prd is linked (one-to-many) to product_size_pd s
table product_size_pd s...
No activity results to display
Leave a comment: