| ... | ... | @@ -14,6 +14,7 @@ |
|
|
|
|
|
|
|
### 建表语句
|
|
|
|
|
|
|
|
|
|
|
|
```sql
|
|
|
|
CREATE TABLE `tb_app_data` (
|
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
|
| ... | ... | @@ -55,7 +56,7 @@ CREATE TABLE `tb_app_data` ( |
|
|
|
KEY `idx_app_state` (`app_state`),
|
|
|
|
KEY `idx_app_id` (`app_id`)
|
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=5220537 DEFAULT CHARSET=utf8 COMMENT='移动APP数据';
|
|
|
|
|
|
|
|
```
|
|
|
|
|
|
|
|
### 数据结构
|
|
|
|
|
| ... | ... | @@ -73,6 +74,8 @@ CREATE TABLE `tb_app_data` ( |
|
|
|
"comment_num": "评论数",
|
|
|
|
"download_num": "下载次数",
|
|
|
|
"product_unit": "出品单位（app发布者）",
|
|
|
|
"company_name_digest": "主体唯一键",
|
|
|
|
"data_source": "数据来源",
|
|
|
|
"province": "省份",
|
|
|
|
"city": "城市",
|
|
|
|
"county": "地区",
|
| ... | ... | @@ -83,11 +86,11 @@ CREATE TABLE `tb_app_data` ( |
|
|
|
"app_download_url": "APP下载链接",
|
|
|
|
"home_page": "APP官方主页",
|
|
|
|
"app_state": "APP状态",
|
|
|
|
"labels": "APP标签",
|
|
|
|
"create_time": "收录时间",
|
|
|
|
"lastupdatetime": "最后更新时间",
|
|
|
|
"use_flag": "使用标记",
|
|
|
|
"is_history": "是否是历史数据",
|
|
|
|
"id_hide": "是否不展示"
|
|
|
|
"is_history": "是否是历史数据"
|
|
|
|
}
|
|
|
|
```
|
|
|
|
|
| ... | ... | @@ -121,7 +124,7 @@ CREATE TABLE `tb_app_data` ( |
|
|
|
| labels | varchar | APP标签（多个标签用“,”隔开） |
|
|
|
|
| create_time | timestamp | 收录时间 |
|
|
|
|
| update_time | datetime | 最后更新时间 |
|
|
|
|
| use_flag | smallint | 使用标记，10废弃删除 |
|
|
|
|
| use_flag | smallint | 使用标记，10废弃使用 |
|
|
|
|
| is_history | smallint | 是否是历史数据，1历史数据 |
|
|
|
|
|
|
|
|
### 样例
|
| ... | ... | @@ -151,7 +154,7 @@ CREATE TABLE `tb_app_data` ( |
|
|
|
"home_page": "https://shuidi.cn/user/privacy",
|
|
|
|
"app_state": 1,
|
|
|
|
"create_time": "2021-06-19 22:06:06",
|
|
|
|
"lastupdatetime": "2021-06-19 22:06:06"
|
|
|
|
"update_time": "2021-06-19 22:06:06"
|
|
|
|
}
|
|
|
|
```
|
|
|
|
|
| ... | ... | |
