-- 会员互动消息（被查看 / 微信被解锁）
CREATE TABLE IF NOT EXISTS `member_interaction` (
    `id`           bigint       NOT NULL AUTO_INCREMENT COMMENT '编号',
    `receiver_id`  bigint       NOT NULL COMMENT '接收人（被查看 / 被解锁用户）',
    `actor_id`     bigint       NOT NULL COMMENT '操作人',
    `biz_type`     varchar(32)  NOT NULL COMMENT 'VIEWED / WECHAT_UNLOCKED',
    `ref_id`       bigint       NULL DEFAULT NULL COMMENT '关联业务 id（访客记录 / 操作记录）',
    `read_status`  bit(1)       NOT NULL DEFAULT b'0' COMMENT '是否已读',
    `tenant_id`    bigint       NOT NULL DEFAULT 0 COMMENT '租户编号',
    `creator`      varchar(64)  NULL DEFAULT '' COMMENT '创建者',
    `create_time`  datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updater`      varchar(64)  NULL DEFAULT '' COMMENT '更新者',
    `update_time`  datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `deleted`      bit(1)       NOT NULL DEFAULT b'0' COMMENT '是否删除',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `idx_receiver_read` (`receiver_id`, `read_status`) USING BTREE,
    KEY `idx_receiver_time` (`receiver_id`, `id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员互动消息';