E-commerce transaction system ER diagram
0 Report
This template is suitable for data model design of e-commerce transaction systems. It uses ER diagrams to show the core entities in the system and their relationships (such as users, products, orders, payments, etc.), helping to clearly understand the relationships and data structure between business objects.
Related Recommendations
Other works by the author
Outline/Content
See more
ADDRESS
bigint
address_id
PK
user_id
FK
varchar
recipient
phone
full_address
bool
is_default
PAYMENT
payment_id
order_id
payment_method
decimal
amount
status
timestamp
pay_time
USER
username
email
created_at
includes
SHIPMENT
shipment_id
tracking_number
carrier
shipped_at
delivered_at
PRODUCT
product_id
name
price
int
stock
category
places
has
ORDER
order_sn
total_amount
contains
generates
ORDER_ITEM
item_id
quantity
unit_price
Collect
Collect
Collect
Collect
0 Comments
Next Page