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

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

id int pk

order_id int

sender_type enum('user','admin')

message text

created_at datetime

id int pk

user_id int

product_name varchar(255)

quantity int

price_at_time decimal(10,2)

product_id int

id int pk

name varchar(100)

category varchar(50)

price decimal(10,2)

image varchar(255)

description text

stock int

featured int

id int pk

name varchar(100)