(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 |