数据管理部分设计实例_软件工程
在服务器上用浏览器打开文件传输助手传进去就行
-
第一关
+------------+--------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+------------+----------------+
| guestID | bigint(20) | NO | PRI | NULL | auto_increment |
| birthday | varchar(255) | YES | | 0002-02-02 | |
| enterprise | varchar(255) | YES | | NULL | |
| name | varchar(255) | YES | | NULL | |
| nickName | varchar(255) | YES | | NULL | |
| password | varchar(255) | YES | | 123456 | |
| credit | double | YES | | 1000 | |
| phone | varchar(255) | YES | | NULL | |
+------------+--------------+------+-----+------------+----------------+
-
第二关
+--------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| hotelID | bigint(20) | NO | | NULL | |
| hotelName | varchar(255) | YES | | NULL | |
| city | varchar(255) | YES | | NULL | |
| circle | varchar(255) | YES | | NULL | |
| address | text | YES | | NULL | |
| level | varchar(255) | YES | | NULL | |
| score | double | YES | | 0 | |
| introduction | text | YES | | NULL | |
| equipment | text | YES | | NULL | |
| commentsNum | int(11) | YES | | 0 | |
+--------------+--------------+------+-----+---------+-------+
10 rows in set (0.00 sec)
-
第三关
+------------+--------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+------------+----------------+
| hotelWorkerID | bigint(20) | NO | PRI | NULL | auto_increment |
| password | varchar(255) | YES | | 123456 | |
| hotelName | varchar(255) | YES | | | |
+------------+--------------+------+-----+------------+----------------+