posdb

DROP TABLE IF EXISTS adminPanel;
DROP TABLE IF EXISTS customer;
DROP TABLE IF EXISTS category;
DROP TABLE IF EXISTS brand;
DROP TABLE IF EXISTS product;
DROP TABLE IF EXISTS sales;

CREATE TABLE adminPanel
(
    userName VARCHAR(100),
    password VARCHAR(100)
);
CREATE TABLE customer
(
    customerId INT IDENTITY(1,1),
    customerName VARCHAR(30),
    customerPhone VARCHAR(30),
    customerEmail VARCHAR(100),
    customerAddress VARCHAR(100)
);
CREATE TABLE category
(
    categoryId INT IDENTITY(1,1),
    categoryName VARCHAR(100)
);
CREATE TABLE brand
(
    brandId INT IDENTITY(1,1),
    brandName VARCHAR(100)
);
CREATE TABLE product
(
    productId INT IDENTITY(1,1),
    productCode VARCHAR(30),
    productName VARCHAR(100),
    brandId INT,
    categoryId INT,
    productPrice FLOAT,
    productQuantity FLOAT,
    productStockInDate VARCHAR(30),
    productExpireDate VARCHAR(30)
);

CREATE TABLE cart
(
    cartId INT,
    productId INT,
    quantity FLOAT,
    productStockOutDate VARCHAR(30)
    customerId INT
);


INSERT INTO customer VALUES ('robin','01234567890','a@b.com','1/2 road');