mysql

USE shopdb;
CREATE TABLE product_category (
product_name_ID INT(5) NOT NULL AUTO_INCREMENT,
product_name VARCHAR(50) NOT NULL,
PRIMARY KEY (product_name_ID), INDEX(product_name)
);
CREATE TABLE product (
product_ID INT(5) NOT NULL AUTO_INCREMENT,
product_name_ID INT(5) NOT NULL,
size INT(5) NOT NULL,
PRIMARY KEY (product_ID)
);
CREATE TABLE customer (
customer_ID INT(5) NOT NULL AUTO_INCREMENT,
customer_name VARCHAR(100) NOT NULL,
customer_email VARCHAR(100) NOT NULL,
customer_address VARCHAR(100) NOT NULL,
customer_password INT(10) NOT NULL,
PRIMARY KEY (customer_ID), INDEX(customer_name, customer_email, customer_address)
);
CREATE TABLE administrator (
admin_name VARCHAR(100) NOT NULL,
admin_password INT(10) NOT NULL
);
CREATE TABLE bag (
bag_ID INT(10) NOT NULL,
customer_ID INT(5) NOT NULL,
product_ID INT(10) NOT NULL,
product_quantity INT(5) NOT NULL,
PRIMARY KEY (bag_ID)
);
CREATE TABLE shipping (
shipping_ID INT(5) NOT NULL,
shipping_name VARCHAR(100) NOT NULL,
bag_ID INT(5) NOT NULL,
customer_ID INT(5) NOT NULL,
PRIMARY KEY (shipping_ID)
);
CREATE TABLE customer_order (
order_ID INT(5) NOT NULL,
customer_ID INT(5) NOT NULL,
bag_ID INT(5) NOT NULL,
shipping_ID INT(5) NOT NULL,
PRIMARY KEY (order_ID)
);