db.md

@@ -9,7 +9,7 @@ CREATE TABLE `api` (
   `create_time` int(11) NOT NULL DEFAULT '0',
   `last_upadte` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='接口表'
+) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='接口表';
 
 INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('overdueClassify', '逾期', '逾期信息', 'https://i.trustutn.org/b/overdueClassify', 1, 0, '2016-08-15 09:35:23');
 INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('loanClassify', '共债', '共债信息', 'https://i.trustutn.org/b/loanClassify', 1, 0, '2016-08-15 09:35:46');
@@ -21,4 +21,27 @@ INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time
 INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('phoneinfo', '电话号码信息', '电话号码相关查询', 'https://i.trustutn.org/b/phoneinfo', 1, 0, '2016-09-01 06:25:41');
 INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('phonetag', '电话号码标记', '电话号码标记查询', 'https://i.trustutn.org/phonetag', 1, 0, '2016-09-01 06:25:42');
 INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('phoneMatch', '设备号匹配', '手机号设备号匹配查询', 'https://i.trustutn.org/b/phoneMatch', 1, 0, '2016-09-01 06:25:45');
+```
+
+```
+CREATE TABLE `api_log` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
+  `api_id` int(11) NOT NULL DEFAULT '0' COMMENT '接口id',
+  `time_index` int(11) DEFAULT '0',
+  `id_card` bigint(20) DEFAULT '0' COMMENT '身份证号',
+  `name` varchar(50) DEFAULT '' COMMENT '姓名',
+  `phone` bigint(20) NOT NULL DEFAULT '0' COMMENT '手机号',
+  `imsi` bigint(20) NOT NULL DEFAULT '0' COMMENT '国际移动用户识别码',
+  `imei` bigint(20) NOT NULL DEFAULT '0',
+  `input_params` varchar(2000) NOT NULL DEFAULT '' COMMENT '传入参数',
+  `output_params` varchar(2000) NOT NULL DEFAULT '' COMMENT '返回结果',
+  `response_time` bigint(20) DEFAULT '0' COMMENT '接口响应时间',
+  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '返回状态 0 调用失败 2 调用成功,但未命中 1调用成功且命中',
+  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
+  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`id`),
+  KEY `idx_uast` (`user_id`,`api_id`,`status`,`time_index`),
+  KEY `idx_tuas` (`time_index`,`user_id`,`api_id`,`status`)
+) ENGINE=InnoDB AUTO_INCREMENT=280043 DEFAULT CHARSET=utf8 COMMENT='接口调用日志表';
 ```
\ No newline at end of file