sql.txt

create DATABASE book_management;




CREATE TABLE products(
    category VARCHAR(50),
    mrp FLOAT,
    name VARCHAR(100),
    description VARCHAR(10000),
    product_id INT AUTO_INCREMENT PRIMARY KEY,
    price FLOAT,
    image VARCHAR(500),
    prod_condition VARCHAR(50),
    customer_id INT,
    FOREIGN KEY (customer_id) REFERENCES login(customer_id)
)

CREATE TABLE orders (
    order_id INT,
    order_date datetime,
    customer_id INT,
    product_id INT,
    FOREIGN KEY(customer_id) REFERENCES login(customer_id),
    FOREIGN KEY(product_id) REFERENCES products(product_id)
    )


CREATE TABLE cart(
    product_id INT,
    customer_id INT,
    size INT,
    
    FOREIGN KEY(product_id) REFERENCES products(product_id),
    FOREIGN KEY(customer_id) REFERENCES login(customer_id)
    
    )