|
|
* 接口相关表
|
|
|
```
|
|
|
CREATE TABLE `api` (
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
... | ... | @@ -57,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,
|
... | ... | @@ -101,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,
|
... | ... | |