GitLab

CREATE TABLE `api` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '接口名称',
  `cn_name` varchar(20) DEFAULT '' COMMENT '接口中文名称',
  `desc` varchar(50) DEFAULT '' COMMENT '接口描述',
  `url` varchar(100) NOT NULL DEFAULT '' COMMENT '接口地址',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '接口状态',
  `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='接口表';

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');
INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('blacklist', '黑名单', '黑名单信息', 'https://i.trustutn.org/b/blacklist', 1, 0, '2016-08-15 09:36:05');
INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('logStatistics', '其它机构查询', '其它机构查询情况', 'https://i.trustutn.org/b/logStatistics', 1, 0, '2016-08-15 09:36:55');
INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('idCheck', '身份证验证', '身份证信息验证', 'https://i.trustutn.org/idCheck', 1, 0, '2016-08-15 09:37:31');
INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('bankcardauth', '银行卡验证', '银行卡实名验证
', 'https://i.trustutn.org/bankcardauth', 1, 0, '2016-08-15 09:38:51');
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='接口调用日志表';