users 👤

id int pk

username varchar(100)

email varchar(100)

password varchar(255)

name varchar(100)

phone varchar(20)

address text

profile_pic varchar(255)

created_at timestamp

cart 🛒

id int pk

user_id int

product_name varchar(255)

quantity int

price_at_time decimal(10,2)

product_id int

orders 📄

id int pk

user_id int

order_group_id varchar(50)

product_id int

product_name varchar(255)

quantity int

price decimal(10,2)

total_price decimal(10,2)

status enum('Pending','Shipped','Delivered','Cancelled','Cancel Requested')

order_date timestamp

created_at datetime

admin_message text

cancel_message text

products 📦

id int pk

name varchar(100)

category varchar(50)

price decimal(10,2)

image varchar(255)

description text

stock int

featured int

categories 🏷️

id int pk

name varchar(100)