Scribd
Upload
50 views2 pages

Orders Order - Items Products Users

The document describes an e-commerce database schema with tables for orders, order items, products, users, merchants, and countries. The orders and order items tables have a one-to-many relationship, as do products and order items. Users can make multiple orders and belong to a single country. Merchants operate in a single country.

Uploaded by

John Faria
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
50 views2 pages

Orders Order - Items Products Users

The document describes an e-commerce database schema with tables for orders, order items, products, users, merchants, and countries. The orders and order items tables have a one-to-many relationship, as do products and order items. Users can make multiple orders and belong to a single country. Merchants operate in a single country.

Uploaded by

John Faria
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 order_items products users

id int order_id int id int id int

user_id int product_id int name varchar full_name varchar

status varchar quantity int merchant_id int email varchar

created_at varchar price int gender varchar

status varchar date_of_birth varchar

created_at varchar created_at varchar

merchants countries country_code int

id int code int

merchant_name varchar name varchar

country_code int continent_name varchar

created_at varchar

admin_id int
orders order_items products users
1 1 1
id int order_id int id int id int
*

user_id int product_id int name varchar full_name varchar


* *
*
status varchar quantity int merchant_id int email varchar

created_at varchar price int gender varchar

status varchar date_of_birth varchar

created_at varchar created_at varchar


*
merchants countries country_code int
1
id int code int
1 1

merchant_name varchar name varchar

country_code int continent_name varchar


*

created_at varchar

admin_id int
*

You might also like