Scribd
Upload
7 views2 pages

Database Schema for E-commerce System

The document outlines a database schema for an e-commerce system, including tables for Orders, Customers, and Products. Each table contains various fields such as order_id, customer_id, product_id, and associated attributes like name, quantity, and price. Relationships between the tables are indicated, showing how orders are linked to customers and order items.

Uploaded by

zeroperiodog
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
7 views2 pages

Database Schema for E-commerce System

The document outlines a database schema for an e-commerce system, including tables for Orders, Customers, and Products. Each table contains various fields such as order_id, customer_id, product_id, and associated attributes like name, quantity, and price. Relationships between the tables are indicated, showing how orders are linked to customers and order items.

Uploaded by

zeroperiodog
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

Orders

0..1
order_id INT
*
customer_id INT

order_date DATE

amount DECIMAL(10,2) OrderItems


Customers
*
0..1 order_id INT
customer_id INT
*
product_id INT
name VARCHAR(100)
quantity INT
city VARCHAR(100)
Primary Key(order_id,product_id)
join_date DATE

Products
0..1
product_id INT

name VARCHAR(100)

category VARCHAR(50)

price DECIMAL(10,2)
Orders
0..1
order_id INT
*
customer_id INT

order_date DATE

amount DECIMAL(10,2) OrderItems


Customers
*
0..1 order_id INT
customer_id INT
*
product_id INT
name VARCHAR(100)
quantity INT
city VARCHAR(100)
Primary Key(order_id,product_id)
join_date DATE

Products
0..1
product_id INT

name VARCHAR(100)

category VARCHAR(50)

price DECIMAL(10,2)

You might also like