Tag: database

The ER diagram above indicates that a user can choose to enter multiple groups after registration, and a group will release a race task. The user can choose to participate in the group release race, complete the race to receive the bonus.

（1）User simple registration information table.

Tb_customer

Fields	Type	Key
Customer_id	int	PK	NOT NULL
Customer_password	varchar	–	NOT NULL
Customer_email	varchar	–	NOT NULL

 

（2）Group information table

Tb_group

Fields	Type	Key
Group_id	int	PK	NOT NULL
Group_name	varchar	–	NOT NULL
Group_org	int	FK	NOT NULL
Group_Date	Date	–	NOT NULL
Group_type	varchar	–	NOT NULL

 

(3) Friend information table

Tb_friend

Fields	Type	Key
Friend_id	int	PK	NOT NULL
Friend_user	int	FK	NOT NULL
Friend_Item	int	FK	NOT NULL
Friend_name	varchar	–	NOT NULL

 

(4) Race information table

Tb_item

Fields	Type	Key
Item_id	int	PK	NOT NULL
Item_group	int	FK	NOT NULL
Item_startime	Date	–	NOT NULL
Item_endtime	Date	–	NOT NULL
Item_startprice	varchar	–	NOT NULL
Item_endprice	varchar	–	NOT NULL
Item_state	int	–	NOT NULL
Item_number	int	–	NOT NULL

 

(5) User details table

Tb_user

Fields	Type	Key
User_id	int	PK	NOT NULL
User_name	varchar	–	NOT NULL
User_email	varchar	–	NOT NULL
User_tel	int	–	NOT NULL
User_signature	varchar	–	NOT NULL
User_gender	varchar	–	NOT NULL
User_item	int	FK	NOT NULL
User_friend	int	FK	NOT NULL
User_group	int	FK	NOT NULL
User_customer	int	FK	NOT NULL