cs-wechat/sql

CREATE TABLE `cs_min_wechat_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `open_id` varchar(512) DEFAULT NULL,
  `union_id` varchar(512) DEFAULT NULL,
  `phone` varchar(256) DEFAULT NULL COMMENT '用户手机号',
  `wechat_type` int NOT NULL DEFAULT '0' COMMENT '0:小程序 1:公众号',
  `wechat_app_id` varchar(512) NOT NULL COMMENT '小程序、公众号appId',
  `nick_name` varchar(256) DEFAULT NULL COMMENT '微信昵称',
  `head_img_url` varchar(512) DEFAULT NULL COMMENT '微信头像',
  `is_deleted` int NOT NULL DEFAULT '0',
  `create_time` bigint NOT NULL,
  `modified_time` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_app_id` (`wechat_app_id`),
  KEY `idx_open_id` (`open_id`),
  KEY `idx_phone` (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='春笋小程序公众号用户表'