Database design

(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

Leave a Reply

Your email address will not be published. Required fields are marked *