title: Need help to create database schema for wholesale online tee store
body: <p>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.</p>
  
  <p>I am trying to base my design on this <a href="http://www.qtag.com/T-Shirts/Mens_Short_Sleeve_T-Shirts/Stedman_Mens_Budget_T-shirts?oscsid=c3c6127cde0b36a6a07ea1f154d12496" rel="nofollow noreferrer">reference site</a>. </p>
  
  <p>Basic tables I have created are:</p>
  
  <pre><code>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)
  );
  </code></pre>
  
  <p>I'm not getting, how to store the price based on a variable quantity. 
  e.g -</p>
  
  <pre>
  Quantity    Price
  1-9         £1.91
  10-99       £1.64
  100-499     £1.10
  500+        £1.14
  </pre>
  
  <p>Please help me to create product and its related tables. My requirement is same as above reference link.</p>