obsidian-valut-mq/三方渠道对接/企微.md

URL：https://api-gateway-qa.meiqia.cn/sp/unauth/auth/wx-callback

CREATE TABLE `luoke_auth_info` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `ent_id` BIGINT NOT NULL,
  `user_id` VARCHAR(64) NOT NULL,
  `device_id` VARCHAR(64) NOT NULL DEFAULT '',
  `corp_id` VARCHAR(64) NOT NULL DEFAULT '',
  `nickname` VARCHAR(255) NOT NULL DEFAULT '',
  `avatar` VARCHAR(512) NOT NULL DEFAULT '',
  `region` VARCHAR(64) NOT NULL DEFAULT '',
  `deleted_at` BIGINT NOT NULL DEFAULT 0,
  `created_at` BIGINT NOT NULL DEFAULT 0,
  `updated_at` BIGINT NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_luoke_auth_ent_user` (`ent_id`, `user_id`),
  KEY `idx_luoke_auth_user_id` (`user_id`)
) ;

CREATE TABLE `luoke_fansinfo` (  
  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键ID',  
  `ent_id` BIGINT NOT NULL COMMENT '企业ID',  
  `sub_source` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '子来源',  
  `sender` BIGINT UNSIGNED NOT NULL COMMENT '发送者ID',  
  `client_id` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '客户端ID',  
  `created_at` BIGINT NOT NULL DEFAULT 0 COMMENT '创建时间',  
  `updated_at` BIGINT NOT NULL DEFAULT 0 COMMENT '更新时间',  
  PRIMARY KEY (`id`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Luoke粉丝信息表';