Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE buyer(
- buyer_id VARCHAR(10) PRIMARY KEY,
- buyer_name VARCHAR(100) NOT NULL,
- buyer_phoneNumber VARCHAR(20) NOT NULL,
- buyer_email VARCHAR(20) NOT NULL
- );
- CREATE TABLE address(
- address_id INT(10) PRIMARY KEY,
- address_street TEXT NOT NULL,
- address_city TEXT NOT NULL,
- address_country VARCHAR(10) NOT NULL,
- address_zip_code VARCHAR(6) NOT NULL
- );
- CREATE TABLE buyer_address(
- buyer_id VARCHAR(10) NOT NULL,
- address_id INT(10) NOT NULL
- );
- CREATE TABLE product(
- product_id VARCHAR(10) PRIMARY KEY,
- product_name VARCHAR(100) NOT NULL,
- product_weight INT(10) NOT NULL,
- product_price DECIMAL(10,2) NOT NULL
- );
- CREATE TABLE orders(
- order_id VARCHAR(10) PRIMARY KEY,
- buyer_id VARCHAR(10) NOT NULL,
- order_date DATETIME NOT NULL,
- order_total DECIMAL(10,2) NOT NULL,
- address_id INT(10) NOT NULL
- );
- CREATE TABLE order_detail(
- order_id VARCHAR(10) NOT NULL,
- product_id VARCHAR(10) NOT NULL,
- qty INT(10) NOT NULL
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement