|
|
* 接口相关表
|
|
|
接口相关表
|
|
|
```
|
|
|
CREATE TABLE `api` (
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
... | ... | @@ -58,7 +58,7 @@ CREATE TABLE `api_log_statistics` ( |
|
|
UNIQUE KEY `idx_utd` (`user_id`,`api_id`,`data_key`,`time_type`,`time_index`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=13257 DEFAULT CHARSET=utf8;
|
|
|
```
|
|
|
* 基础信息表
|
|
|
基础信息表
|
|
|
```
|
|
|
CREATE TABLE `base_info` (
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
... | ... | @@ -102,7 +102,7 @@ INSERT INTO personal_credit.base_info (pid, info, code) VALUES (2, '大陆居民 |
|
|
INSERT INTO personal_credit.base_info (pid, info, code) VALUES (2, '因公往来香港澳门特别行政区通行证', 518);
|
|
|
INSERT INTO personal_credit.base_info (pid, info, code) VALUES (2, '边境管理区通行证', 711);
|
|
|
```
|
|
|
* 通知表
|
|
|
通知表
|
|
|
```
|
|
|
CREATE TABLE `notice` (
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
... | ... | @@ -127,7 +127,7 @@ CREATE TABLE `notice_template` ( |
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='通知模板';
|
|
|
```
|
|
|
|
|
|
帮助信息表
|
|
|
```
|
|
|
CREATE TABLE `support` (
|
|
|
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
|
... | ... | @@ -140,7 +140,7 @@ CREATE TABLE `support` ( |
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
|
|
|
```
|
|
|
|
|
|
用户表
|
|
|
```
|
|
|
CREATE TABLE `user` (
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
... | ... | @@ -171,7 +171,7 @@ CREATE TABLE `user_statistics` ( |
|
|
UNIQUE KEY `idx_tkv` (`time_index`,`time_type`,`data_key`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
|
|
|
```
|
|
|
|
|
|
账户表
|
|
|
```
|
|
|
CREATE TABLE `user_account` (
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
... | ... | @@ -210,7 +210,7 @@ CREATE TABLE `user_account_log_statistics` ( |
|
|
UNIQUE KEY `idx_utd` (`user_id`,`data_key`,`time_index`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
|
|
|
```
|
|
|
|
|
|
用户接口关系表
|
|
|
```
|
|
|
CREATE TABLE `user_api` (
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
... | ... | @@ -237,7 +237,7 @@ CREATE TABLE `user_api_log` ( |
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
|
|
|
```
|
|
|
|
|
|
白名单表
|
|
|
```
|
|
|
CREATE TABLE `user_ip_whitelist` (
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
... | ... | |