Scribd
Upload
4 views2 pages

SQL 2

The document outlines the database schema for an e-commerce system, detailing the relationships between various entities such as orders, order items, carts, users, products, categories, and payments. Each entity is defined with its attributes, including data types and relationships to other entities. The schema supports functionalities like user management, product inventory, and order processing.

Uploaded by

anupsingh123404
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views2 pages

SQL 2

The document outlines the database schema for an e-commerce system, detailing the relationships between various entities such as orders, order items, carts, users, products, categories, and payments. Each entity is defined with its attributes, including data types and relationships to other entities. The schema supports functionalities like user management, product inventory, and order processing.

Uploaded by

anupsingh123404
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

order_items admins

id int id int
*
order_id int cart_items name varchar
*
product_id int id int email varchar
*
quantity int cart_id int password varchar
carts
*
0..1 product_id int
id int
* quantity int
user_id int

users
0..1
id int

name varchar
orders
email varchar
products
0..1
id int
password varchar 0..1 0..1
id int
*
user_id int
phone varchar
name varchar
total_amount float
price float
status varchar
stock int
*
category_id int
categories
0..1
id int

name varchar
payments

id int
*
order_id int

payment_method varchar

status varchar
order_items admins

id int id int
*
order_id int cart_items name varchar
*
product_id int id int email varchar
*
quantity int cart_id int password varchar
carts
*
0..1 product_id int
id int
* quantity int
user_id int

users
0..1
id int

name varchar
orders
email varchar
products
0..1
id int
password varchar 0..1 0..1
id int
*
user_id int
phone varchar
name varchar
total_amount float
price float
status varchar
stock int
*
category_id int
categories
0..1
id int

name varchar
payments

id int
*
order_id int

payment_method varchar

status varchar

You might also like