软件开发项目实践（一）
1.自己设计至少一张表，字段不少于10个，包含主键自增、自动生成时间戳等。业务根据自己的兴趣爱好，例如电影、美食、图书、旅游均可以。
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18mysql> desc user;
+-------------+-------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+-------------------+-----------------------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| phone | varchar(11) | NO | PRI | NULL | |
| passwd | varchar(16) | NO | | NULL | |
| nickname | varchar(20) | NO | | NULL | |
| gender | varchar(5) | NO | | NULL | |
| home | varchar(50) | NO | | NULL | |
| status | varchar(30) | NO | | NULL | |
| birth | varchar(50) | NO | | NULL | |
| body_height | int(11) | NO | | NULL | |
| body_weight | int(11) | NO | | NULL | |
| createTime | timestamp | NO | | CURRENT_TIMESTAMP | |
| updateTime | datetime | YES | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+-------------+-------------+------+-----+-------------------+-----------------------------+
12 rows in set (0.00 sec)
