微信

sql

CREATE TABLE `wecom_group` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `group_name` varchar(100) NOT NULL DEFAULT '' COMMENT '群名称',
  `group_id` varchar(50) NOT NULL DEFAULT '' COMMENT '群官方ID',
  `group_crack_id` varchar(50) NOT NULL DEFAULT '' COMMENT '群破解ID',
  `creater_crack_id` varchar(50) NOT NULL DEFAULT '' COMMENT '创建人破解ID',
  `group_create_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '群创建时间',
  `total` int(11) NOT NULL DEFAULT '0' COMMENT '成员数量',
  `owner_crack_id` varchar(50) NOT NULL DEFAULT '' COMMENT '群主破解ID',
  `owner_work_id` varchar(50) NOT NULL DEFAULT '' COMMENT '群主工号',
  `owner_name` varchar(50) NOT NULL DEFAULT '' COMMENT '群主姓名',
  `creater_work_id` varchar(50) NOT NULL DEFAULT '' COMMENT '创建人工号',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  `create_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='群聊';

json

{
    "acctid": "00483",
    "avatar": "https://wework.qpic.cn/wwpic3az/61498_Dz2E7R3DRFCMyxs_1747674002/0",
    "corp_id": "1970325076029765",
    "invite_user_id": "5629503781244698",
    "is_admin": 0,
    "join_scene": 0,
    "join_time": 1751440285,
    "mobile": "",
    "nickname": "",
    "position": "",
    "realname": "刘学",
    "remark": "",
    "room_nickname": "",
    "sex": 1,
    "unionid": "ozynqsokgjHrMkuKPgJtlRC1p_yg",
    "user_id": "1688851758325955",
    "username": "刘学(lx)"
}

sql

CREATE TABLE `wecom_group_member` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `group_crack_id` varchar(50) NOT NULL DEFAULT '' COMMENT '群破解ID',
  `user_crack_id` varchar(50) NOT NULL DEFAULT '' COMMENT '用户破解ID',
  `join_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '加入时间',
  `invite_user_crack_id` varchar(50) NOT NULL DEFAULT '' COMMENT '邀请人破解ID',
  `group_nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '群内昵称',
  `group_chat_id` varchar(50) NOT NULL DEFAULT '' COMMENT '企微ChatId',
  `user_work_id` varchar(50) NOT NULL DEFAULT '' COMMENT '用户工号',
  `user_name` varchar(50) NOT NULL DEFAULT '' COMMENT '用户名称',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  `create_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='群成员';

json

{
    "acctid": "00483",
    "avatar": "https://wework.qpic.cn/wwpic3az/61498_Dz2E7R3DRFCMyxs_1747674002/0",
    "conversation_id": "S:1688851758325955_1688855777762757",
    "corp_id": "1970325076029765",
    "mobile": "",
    "nickname": "",
    "position": "",
    "realname": "刘学",
    "remark": "",
    "sex": 1,
    "unionid": "ozynqsokgjHrMkuKPgJtlRC1p_yg",
    "user_id": "1688851758325955",
    "username": "刘学(lx)"
}

sql

CREATE TABLE `wecom_friend` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `username` varchar(10) NOT NULL DEFAULT '' COMMENT '好友名称',
  `avatar` varchar(200) NOT NULL DEFAULT '' COMMENT '好友名称',
  `crack_friend_id` varchar(50) NOT NULL DEFAULT '' COMMENT '好友破解ID',
  `acct_id` varchar(50) NOT NULL DEFAULT '' COMMENT '好友标识: 可以等同企微UserId',
  `user_id` varchar(50) NOT NULL DEFAULT '' COMMENT '企微UserId',
  `qw_username` varchar(50) NOT NULL DEFAULT '' COMMENT '企微姓名: 刘玉路(lyl07583)',
  `work_id` varchar(10) NOT NULL DEFAULT '' COMMENT '工号',
  `email` varchar(50) NOT NULL DEFAULT '' COMMENT '邮箱',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号',
  `corp_id` varchar(20) NOT NULL DEFAULT '' COMMENT '主体ID',
  `unionid` varchar(20) NOT NULL DEFAULT '' COMMENT 'unionid',
  `sex` int(11) NOT NULL DEFAULT '0' COMMENT '性别： 0未知 1男 2女',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  `create_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1724 DEFAULT CHARSET=utf8mb4 COMMENT='好友';

聊天

日志事件

微信 ​

微信