Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
P
project-credit
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 2
    • Issues 2
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • 互联网应用开发
  • project-credit
  • Wiki
  • db

db · Changes

Page history
xiaolong.jin created page: db authored Sep 18, 2016 by 金小龙's avatar 金小龙
Hide whitespace changes
Inline Side-by-side
Showing with 24 additions and 1 deletion
+24 -1
  • db.md db.md +24 -1
  • No files found.
db.md
View page @ 10284bfe
test ```
\ No newline at end of file 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');
```
\ No newline at end of file
Clone repository
  • api
  • crontab
  • db
  • doc
  • files
  • Home
  • sql