|
|
|
# 经营状况-微信公众号
|
|
|
|
|
|
|
|
# 存储信息
|
|
|
|
aliyun-mysql-rds
|
|
|
|
|
|
|
|
* host: bdp-rds-003.mysql.rds.aliyuncs.com
|
|
|
|
* port: 3306
|
|
|
|
* user: **
|
|
|
|
* password: **
|
|
|
|
* database: utn_ng_biz_info
|
|
|
|
|
|
|
|
# 建表语句
|
|
|
|
|
|
|
|
```sql
|
|
|
|
CREATE TABLE `wechat_public_num` (
|
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
|
`company_id` bigint(20) DEFAULT NULL,
|
|
|
|
`title` varchar(512) DEFAULT NULL COMMENT '公众号标题，名称',
|
|
|
|
`titleImgURL` text COMMENT '公众号标题图片URL',
|
|
|
|
`publicNum` varchar(125) DEFAULT NULL COMMENT '公众号',
|
|
|
|
`authentication` varchar(512) DEFAULT NULL COMMENT '微信认证',
|
|
|
|
`q_r_CodeImgURL` text COMMENT '二维码图片URL',
|
|
|
|
`q_r_code_oss_path` varchar(255) DEFAULT NULL,
|
|
|
|
`q_r_code_addr` varchar(255) DEFAULT NULL COMMENT '二维码扫描结果地址',
|
|
|
|
`recommend` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '介绍',
|
|
|
|
`autrhenticationFlag` varchar(10) DEFAULT NULL COMMENT '认证标识',
|
|
|
|
`detailURL` text COMMENT '公众号详情URL',
|
|
|
|
`source` varchar(255) DEFAULT NULL COMMENT '数据来源 空为搜狗微信搜索 wxb为微小宝',
|
|
|
|
`deleted` int(10) NOT NULL DEFAULT '0' COMMENT '是否删除',
|
|
|
|
`crawlTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
`updateTime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
|
`company_name_digest` char(32) DEFAULT NULL,
|
|
|
|
`shuidi_q_r_code_url` varchar(300) DEFAULT NULL,
|
|
|
|
`company_name_id` char(32) DEFAULT NULL,
|
|
|
|
PRIMARY KEY (`id`),
|
|
|
|
UNIQUE KEY `UNIQUE_publicNum` (`publicNum`),
|
|
|
|
KEY `q_r_code_addr` (`q_r_code_addr`),
|
|
|
|
KEY `authentication_index` (`authentication`(255),`autrhenticationFlag`,`deleted`),
|
|
|
|
KEY `idx_companyId` (`company_id`),
|
|
|
|
KEY `autFlag_deleted_index` (`autrhenticationFlag`,`deleted`),
|
|
|
|
KEY `inx_updateTime` (`updateTime`),
|
|
|
|
KEY `idx_digest` (`company_name_digest`),
|
|
|
|
KEY `idx_company_name` (`authentication`(255))
|
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
|
|
|
|
``` |
|
|
\ No newline at end of file |
