Need help to create database schema for wholesale online tee store
- by techiepark
Hi, I'm currently working on wholesale online t-shirt shop. I have done this for fixed quantity and price, and its working fine. Now i need to do this for variable quantity and price.
Here is the reference link, like what i have to do.
Basic tables i have created are -
CREATE TABLE attribute (
attribute_id int(11) NOT NULL auto_increment,
name varchar(100) NOT NULL,
PRIMARY KEY (attribute_id)
);
CREATE TABLE attribute_value (
attribute_value_id int(11) NOT NULL auto_increment,
attribute_id int(11) NOT NULL,
value varchar(100) NOT NULL,
PRIMARY KEY (attribute_value_id),
KEY idx_attribute_value_attribute_id (attribute_id)
);
CREATE TABLE product (
product_id int(11) NOT NULL auto_increment,
name varchar(100) NOT NULL,
description varchar(1000) NOT NULL,
price decimal(10,2) NOT NULL,
image varchar(150) default NULL,
thumbnail varchar(150) default NULL,
PRIMARY KEY (product_id),
FULLTEXT KEY idx_ft_product_name_description (name,description)
);
CREATE TABLE product_attribute (
product_id int(11) NOT NULL,
attribute_value_id int(11) NOT NULL,
PRIMARY KEY (product_id,attribute_value_id)
);
I'm not getting how to store the price based on variable quantity. Please help me to create product and its related tables. my requirement is same as above reference link.
