Skip to content

Commit 44f4da6

Browse files
TommyLemonTommyLemon
committed
table:完善注释
1 parent 0017ff0 commit 44f4da6

13 files changed

+58
-58
lines changed

‎table/sys_Comment.sql

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -23,12 +23,12 @@ DROP TABLE IF EXISTS `Comment`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `Comment` (
26-
`id` bigint(15) NOT NULL,
27-
`toId` bigint(15) DEFAULT NULL,
28-
`userId` bigint(15) NOT NULL,
29-
`momentId` bigint(15) NOT NULL,
30-
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
31-
`content` varchar(1000) NOT NULL,
26+
`id` bigint(15) NOT NULL COMMENT '唯一标识',
27+
`toId` bigint(15) DEFAULT NULL COMMENT '被回复的id',
28+
`userId` bigint(15) NOT NULL COMMENT '评论人id',
29+
`momentId` bigint(15) NOT NULL COMMENT '动态id',
30+
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
31+
`content` varchar(1000) NOT NULL COMMENT '内容',
3232
PRIMARY KEY (`id`)
3333
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3434
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -52,4 +52,4 @@ UNLOCK TABLES;
5252
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5353
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5454

55-
-- Dump completed on 2017-10-06 0:48:41
55+
-- Dump completed on 2017-10-06 1:02:34

‎table/sys_Login.sql

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -23,10 +23,10 @@ DROP TABLE IF EXISTS `Login`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `Login` (
26-
`id` bigint(10) NOT NULL AUTO_INCREMENT,
27-
`userId` bigint(15) NOT NULL,
28-
`type` tinyint(1) NOT NULL,
29-
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
26+
`id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
27+
`userId` bigint(15) NOT NULL COMMENT '用户id',
28+
`type` tinyint(1) NOT NULL COMMENT '类型\n0-密码登录\n1-验证码登录',
29+
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
3030
PRIMARY KEY (`id`)
3131
) ENGINE=InnoDB AUTO_INCREMENT=1493891806373 DEFAULT CHARSET=utf8 COMMENT='@deprecated，登录信息存session';
3232
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -50,4 +50,4 @@ UNLOCK TABLES;
5050
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5151
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5252

53-
-- Dump completed on 2017-10-06 0:48:42
53+
-- Dump completed on 2017-10-06 1:02:35

‎table/sys_Moment.sql

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -23,12 +23,12 @@ DROP TABLE IF EXISTS `Moment`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `Moment` (
26-
`id` bigint(15) NOT NULL,
27-
`userId` int(5) NOT NULL,
28-
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
29-
`content` varchar(300) DEFAULT NULL,
30-
`praiseUserIdList` json DEFAULT NULL,
31-
`pictureList` json DEFAULT NULL,
26+
`id` bigint(15) NOT NULL COMMENT '唯一标识',
27+
`userId` int(5) NOT NULL COMMENT '用户id',
28+
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
29+
`content` varchar(300) DEFAULT NULL COMMENT '内容',
30+
`praiseUserIdList` json DEFAULT NULL COMMENT '点赞的用户id列表',
31+
`pictureList` json DEFAULT NULL COMMENT '图片列表',
3232
PRIMARY KEY (`id`)
3333
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3434
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -52,4 +52,4 @@ UNLOCK TABLES;
5252
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5353
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5454

55-
-- Dump completed on 2017-10-06 0:48:41
55+
-- Dump completed on 2017-10-06 1:02:35

‎table/sys_Pair.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -49,4 +49,4 @@ UNLOCK TABLES;
4949
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5050
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5151

52-
-- Dump completed on 2017-10-06 0:48:42
52+
-- Dump completed on 2017-10-06 1:02:35

‎table/sys_Praise.sql

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -23,8 +23,8 @@ DROP TABLE IF EXISTS `Praise`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `Praise` (
26-
`id` bigint(15) NOT NULL,
27-
`userIdList` json NOT NULL,
26+
`id` bigint(15) NOT NULL COMMENT '唯一标识',
27+
`userIdList` json NOT NULL COMMENT '用户id列表',
2828
PRIMARY KEY (`id`)
2929
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='如果对Moment写安全要求高，可以将Moment内praiserUserIdList分离到Praise表中，作为userIdList。\n权限注解也改下：\n@MethodAccess(\n PUT = {OWNER, ADMIN}\n )\nclass Moment {\n …\n}\n\n@MethodAccess(\n PUT = {LOGIN, CONTACT, CIRCLE, OWNER, ADMIN}\n )\n class Praise {\n …\n }\n';
3030
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -48,4 +48,4 @@ UNLOCK TABLES;
4848
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
4949
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5050

51-
-- Dump completed on 2017-10-06 0:48:42
51+
-- Dump completed on 2017-10-06 1:02:35

‎table/sys_Request.sql

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -23,13 +23,13 @@ DROP TABLE IF EXISTS `Request`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `Request` (
26-
`id` int(11) NOT NULL AUTO_INCREMENT,
26+
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
2727
`version` tinyint(4) DEFAULT '0' COMMENT 'GET,HEAD可用任意结构访问任意开放内容，不需要这个字段。\n其它的操作因为写入了结构和内容，所以都需要，按照不同的version选择对应的structure。\n\n自动化版本管理：\nRequest JSON最外层可以传 “version”:Integer 。\n1.未传或 <= 0，用最新版。 “@order”:”version-“\n2.已传且 > 0，用version以上的可用版本的最低版本。 “@order”:”version+”, “version{}”:”>={version}”',
28-
`tag` varchar(20) NOT NULL,
28+
`tag` varchar(20) NOT NULL COMMENT '标签',
2929
`method` varchar(10) DEFAULT 'GET' COMMENT '只限于GET,HEAD外的操作方法。',
30-
`structure` json NOT NULL,
31-
`description` varchar(10000) DEFAULT NULL,
32-
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
30+
`structure` json NOT NULL COMMENT '结构',
31+
`description` varchar(10000) DEFAULT NULL COMMENT '描述',
32+
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
3333
PRIMARY KEY (`id`)
3434
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='最好编辑完后删除主键，这样就是只读状态，不能随意更改。需要更改就重新加上主键。\n\n每次启动服务器时加载整个表到内存。\n这个表不可省略，model内注解的权限只是客户端能用的，其它可以保证即便服务端代码错误时也不会误删数据。';
3535
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -53,4 +53,4 @@ UNLOCK TABLES;
5353
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5454
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5555

56-
-- Dump completed on 2017-10-06 0:48:41
56+
-- Dump completed on 2017-10-06 1:02:34

‎table/sys_Response.sql

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -23,12 +23,12 @@ DROP TABLE IF EXISTS `Response`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `Response` (
26-
`id` int(11) NOT NULL,
27-
`method` varchar(10) DEFAULT 'GET',
28-
`model` varchar(20) NOT NULL,
29-
`structure` json NOT NULL,
30-
`description` varchar(10000) DEFAULT NULL,
31-
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
26+
`id` int(11) NOT NULL COMMENT '唯一标识',
27+
`method` varchar(10) DEFAULT 'GET' COMMENT '方法',
28+
`model` varchar(20) NOT NULL COMMENT '表名，table是SQL关键词不能用',
29+
`structure` json NOT NULL COMMENT '结构',
30+
`description` varchar(10000) DEFAULT NULL COMMENT '描述',
31+
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
3232
PRIMARY KEY (`id`),
3333
UNIQUE KEY `id_UNIQUE` (`id`)
3434
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='每次启动服务器时加载整个表到内存。';
@@ -53,4 +53,4 @@ UNLOCK TABLES;
5353
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5454
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5555

56-
-- Dump completed on 2017-10-06 0:48:42
56+
-- Dump completed on 2017-10-06 1:02:35

‎table/sys_Test.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -25,7 +25,7 @@ DROP TABLE IF EXISTS `Test`;
2525
CREATE TABLE `Test` (
2626
`id` tinyint(2) NOT NULL,
2727
PRIMARY KEY (`id`)
28-
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
28+
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='测试及验证用的表，可以用 SELECT condition替代 SELECT * FROM Test WHERE condition，这样就不需要这张表了';
2929
/*!40101 SET character_set_client = @saved_cs_client */;
3030

3131
--
@@ -47,4 +47,4 @@ UNLOCK TABLES;
4747
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
4848
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
4949

50-
-- Dump completed on 2017-10-06 0:48:41
50+
-- Dump completed on 2017-10-06 1:02:35

‎table/sys_Verify.sql

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -23,10 +23,10 @@ DROP TABLE IF EXISTS `Verify`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `Verify` (
26-
`id` bigint(15) NOT NULL COMMENT '一般存phone',
26+
`id` bigint(15) NOT NULL COMMENT '唯一标识，一般存phone',
2727
`type` int(2) NOT NULL DEFAULT '0' COMMENT '类型：\n0-登录\n1-注册\n2-修改登录密码\n3-修改支付密码',
28-
`verify` int(6) NOT NULL,
29-
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
28+
`verify` int(6) NOT NULL COMMENT '验证码',
29+
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
3030
PRIMARY KEY (`id`)
3131
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3232
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -50,4 +50,4 @@ UNLOCK TABLES;
5050
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5151
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5252

53-
-- Dump completed on 2017-10-06 0:48:41
53+
-- Dump completed on 2017-10-06 1:02:34

‎table/sys__Statistics.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -54,4 +54,4 @@ UNLOCK TABLES;
5454
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5555
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5656

57-
-- Dump completed on 2017-10-06 0:48:41
57+
-- Dump completed on 2017-10-06 1:02:35

‎table/sys__Visit.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -48,4 +48,4 @@ UNLOCK TABLES;
4848
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
4949
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5050

51-
-- Dump completed on 2017-10-06 0:48:41
51+
-- Dump completed on 2017-10-06 1:02:34

‎table/sys_apijson_privacy.sql

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -23,12 +23,12 @@ DROP TABLE IF EXISTS `apijson_privacy`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `apijson_privacy` (
26-
`id` bigint(20) NOT NULL,
27-
`certified` tinyint(1) NOT NULL DEFAULT '0',
26+
`id` bigint(20) NOT NULL COMMENT '唯一标识',
27+
`certified` tinyint(1) NOT NULL DEFAULT '0' COMMENT '已认证',
2828
`phone` bigint(11) NOT NULL COMMENT '手机号，仅支持 11 位数的。不支持 +86 这种国家地区开头的。如果要支持就改为 VARCHAR(14)',
29-
`balance` decimal(10,2) NOT NULL DEFAULT '0.00',
30-
`_password` varchar(20) NOT NULL,
31-
`_payPassword` int(6) DEFAULT NULL,
29+
`balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
30+
`_password` varchar(20) NOT NULL COMMENT '登录密码',
31+
`_payPassword` int(6) DEFAULT NULL COMMENT '支付密码',
3232
PRIMARY KEY (`id`)
3333
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户隐私信息表。对安全要求高，不想泄漏真实名称。对外名称为 Privacy';
3434
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -52,4 +52,4 @@ UNLOCK TABLES;
5252
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5353
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5454

55-
-- Dump completed on 2017-10-06 0:48:41
55+
-- Dump completed on 2017-10-06 1:02:34

‎table/sys_apijson_user.sql

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -23,14 +23,14 @@ DROP TABLE IF EXISTS `apijson_user`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `apijson_user` (
26-
`id` bigint(15) NOT NULL AUTO_INCREMENT,
27-
`sex` tinyint(2) NOT NULL DEFAULT '0',
28-
`name` varchar(20) DEFAULT NULL,
29-
`tag` varchar(45) DEFAULT NULL,
30-
`head` varchar(300) DEFAULT NULL,
26+
`id` bigint(15) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
27+
`sex` tinyint(2) NOT NULL DEFAULT '0' COMMENT '性别：\n0-男\n1-女',
28+
`name` varchar(20) DEFAULT NULL COMMENT '名称',
29+
`tag` varchar(45) DEFAULT NULL COMMENT '标签',
30+
`head` varchar(300) DEFAULT NULL COMMENT '头像url',
3131
`contactIdList` json DEFAULT NULL COMMENT '联系人id列表',
32-
`pictureList` json DEFAULT NULL,
33-
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
32+
`pictureList` json DEFAULT NULL COMMENT '照片列表',
33+
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
3434
PRIMARY KEY (`id`)
3535
) ENGINE=InnoDB AUTO_INCREMENT=1507220582168 DEFAULT CHARSET=utf8 COMMENT='对安全要求高，不想泄漏真实名称。对外名称为 User';
3636
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -54,4 +54,4 @@ UNLOCK TABLES;
5454
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5555
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5656

57-
-- Dump completed on 2017-10-06 0:48:41
57+
-- Dump completed on 2017-10-06 1:02:34

0 commit comments

Comments
 (0)