首页 > itarticle > 用户及权限系统数据库设计 ER Diagram:

用户及权限系统数据库设计 ER Diagram:

admin 11月 18, 2020 0

Customer

Field	Type	Key	Description
customer_id	int	PRI	The ID of customer
customer_name	varchar(20)		The name of customer

Seller

Field	Type	Key	Description
seller_id	int	PRI	The ID of seller
seller_name	varchar(20)		The name of seller
seller_pwd	varchar(20)		The password of seller

Order

Field	Type	Key	Description
order_id	int	PRI	The ID of order
total	float		The total price of order
order_info	varchar(500)		The information of order
order_state	varchar(10)		The state of order
remark	varchar(500)		The remark of order

Field	Type	Key	Description
food_id	int	PRI	The ID of food
food_name	varchar(20)		The name of food
food_type	varchar(20)		The type of food
food_price	float		The price of food
food_desc	varchar(100)		The description of food
food_img	varchar(100)		The address of food image

Ordering

Field	Type	Key	Description
food_id	int	PRI	The ID of food
food_name	varchar(20)		The name of food
food_type	varchar(20)		The type of food
food_price	float		The price of food
food_desc	varchar(100)		The description of food
food_img	varchar(100)		The address of food image

Select

Field	Type	Key	Description
customer_id	int	PRI	The ID of customer
food_id	int		The ID of food
food_num	int		The number of selected food

Manager

Field	Type	Key	Description
seller_id	int	PRI	The ID of seller
food_id	int		The ID of food

ER Diagram: