经营状况-微信公众号

存储信息

aliyun-mysql-rds

• host: bdp-rds-003.mysql.rds.aliyuncs.com
• port: 3306
• user: **
• password: **
• database: utn_ng_biz_info

建表语句

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;

数据字典

样例