Please enable JavaScript.
Coggle requires JavaScript to display documents.
SUPER MARKET ANALYSIS, DB (user, Product, orders, payment, cart, category)…
SUPER MARKET ANALYSIS
Customer
SignUP
Login
Password
My Profile
Cart
Payment
View Products
View order
Owner/Admin
Add/ View/ Update Products
Mange orders
Add/ View/ Update categories
Mange customer profile
Login
DB
user
id(PK)
name
password
phone
address
photo
user_type
email
Product
id(PK)
product_name
photo
description
price
cat_id(FK)
discount
quanitity
orders
order_status
0-pending
1-confirm
2-cancel
id(PK)
product_id(FK)
user_id(FK)
delivery_address
quantity
price
total_amount
payment
id(PK)
txn_id
order_id(FK)
payment_amount
payment_mode
payment_status
cart
id(PK)
user_id(FK)
product_id(FK)
quantity
category
id(PK)
cat_name