数据库表格设计

 

1. User

Field	Type	extra
id	int	primary key  auto_increment
student_id	varchar(16)
name	varchar(16)
password	varchar(16)
email	varchar(256)
gender	enum('男'，'女'，'保密')
age	int
personal_credit	int
profile	text

 

 

2. Court

Field	Type	extra
id	int	primary key  auto_increment
state	enum('空'，'忙')
user_id	int	foreign key

 

3. Time

Field	Type	extra
id	int	primary key  auto_increment
startTime	time
endTime	time	foreign key

 

4. Date

Field	Type	extra
id	int	primary key  auto_increment
date	date

 

5. Time_site

Field	Type	extra
id	int	primary key  auto_increment
T_id	int	foreign key(time表中的id)
C_id	int	foreign key(site表中的id)

 

6. Data_time

Field	Type	extra
id	int	primary key  auto_increment
d_id	int	foreign key(date表中的id)
t_id	int	foreign key(time表中的id)