| ... | ... | @@ -43,4 +43,37 @@ CREATE TABLE `wechat_public_num` ( |
|
|
|
KEY `idx_company_name` (`authentication`(255))
|
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
|
|
|
|
``` |
|
|
\ No newline at end of file |
|
|
|
```
|
|
|
|
# 数据字典
|
|
|
|
|
|
|
|
| 表名 | 字段名 | 字段类型 | 注释 |
|
|
|
|
| ------ | ------ | ------ | ------ |
|
|
|
|
| | id | bigint(20) | |
|
|
|
|
| | company_id | bigint(20) | |
|
|
|
|
| | title | varchar(512) | 公众号标题，名称 |
|
|
|
|
| | titleImgURL | text | 公众号标题图片URL |
|
|
|
|
| | publicNum | varchar(125) | 公众号 |
|
|
|
|
| | authentication | varchar(512) | 微信认证 |
|
|
|
|
| | q_r_CodeImgURL | text | 二维码图片URL |
|
|
|
|
| | q_r_code_oss_path | varchar(255) | |
|
|
|
|
| | q_r_code_addr | varchar(255) | 二维码扫描结果地址 |
|
|
|
|
| wechat_public_num | recommend | text | 介绍 |
|
|
|
|
| | autrhenticationFlag | varchar(10) | 认证标识 |
|
|
|
|
| | detailURL | text | 公众号详情URL |
|
|
|
|
| | source | varchar(255) | 数据来源 空为搜狗微信搜索 wxb为微小宝 |
|
|
|
|
| | deleted | int(10) | 是否删除 |
|
|
|
|
| | crawlTime | datetime | |
|
|
|
|
| | updateTime | datetime | 更新时间 |
|
|
|
|
| | company_name_digest | char(32) | |
|
|
|
|
| | shuidi_q_r_code_url | varchar(300) | |
|
|
|
|
| | company_name_id | char(32) | |
|
|
|
|
|
|
|
|
# 样例
|
|
|
|
|
|
|
|
| id | company_id | title | titleImgURL | publicNum | authentication | q_r_CodeImgURL | q_r_code_oss_path | q_r_code_addr | recommend | autrhenticationFlag | detailURL | source | deleted | crawlTime | updateTime | company_name_digest | shuidi_q_r_code_url | company_name_id |
|
|
|
|
| ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ |
|
|
|
|
| 2082742 | 187402665 | 聚优云生活 | yghf201904 | 天津颐购华方电子商务有限责任公司 | wechat_app/qr/371bb0809bf7bd39e2f1d88a0768676b.jpg | http://weixin.qq.com/r/jSgXDyjEHHVjrWxs932f | true | wechat | 0 | 2021-04-26 08:00:00 | 2021-05-03 18:02:41 | 90e1ba256af1f201211059baffdc6901 | wechat/45/66/f9/4566f99c360939ebefadc29679acc4d3.jpg | 227ca5bd653e554696a31c0bea1d0385 |
|
|
|
|
| 2082743 | 119547845 | 尚颐健康 | gh_2343c328ba88 | 江阴市尚颐健康管理有限公司 | wechat_app/qr/94ac1de9d1bb76458d8832ab8144dec4.jpg | http://weixin.qq.com/r/A0TM1PnE-qSBrb239xER | true | wechat | 0 | 2021-04-26 08:00:00 | 2021-05-03 18:02:41 | c6f1c2f3d396d91c97de220d6ed011b2 | wechat/6b/9c/67/6b9c67912f9c0b5d89e2dffcdf81e528.jpg | cee5b5a5c5115baac89506b8522f7b4c |
|
|
|
|
| 2082744 | 212431236 | 呼和浩特肤康皮肤病医院 | hhhtfk | 呼和浩特肤康皮肤病医院有限公司 | wechat_app/qr/471426bce4c21242db69730819351b1b.jpg | http://weixin.qq.com/r/6zukvADEaV0WrUTf9275 | true | wechat | 0 | 2021-04-26 08:00:00 | 2021-05-03 18:02:41 | 9f28ab19a9c4398d71261a427aa46633 | wechat/11/6d/f4/116df49f23dea840b6f356110ad6176b.jpg | 4aa74c17d56d9283dfb7884c5cf1d30e |
|
|
|
|
| 2082745 | 118161169 | 吉林省君菲集团有限公司 | junfeism | 吉林省君菲集团有限公司 | wechat_app/qr/04a6d4e5f4f56173dfc34e62488f68c7.jpg | http://weixin.qq.com/r/bjl9Zc3E7pCRrYkG92x8 | true | wechat | 0 | 2021-04-26 08:00:00 | 2021-05-03 18:02:41 | 21e44293629f4f2895964d0d70a74265 | wechat/7e/b1/af/7eb1af794e7f6ed0269d4214bb285320.jpg | bce210382a642affb8e2216de77fe83d |
|
|
|
|
| 2082746 | 118161169 | 吉林省君菲集团 | gh_b7386bdbc48e | 吉林省君菲集团有限公司 | wechat_app/qr/5ae2dd2bf23a5f9c3569b1a75ac279fe.jpg | http://weixin.qq.com/r/ukNRSZ7EQMM-rdoq9xao | true | wechat | 0 | 2021-04-26 08:00:00 | 2021-05-03 18:02:41 | 21e44293629f4f2895964d0d70a74265 | wechat/ee/d0/6e/eed06ea95b5a5752e128c13fa45a0e9c.jpg | bce210382a642affb8e2216de77fe83d | |
|
|
\ No newline at end of file |
