baqing-shop/sql/biz_member_message.sql

-- 会员站内消息
CREATE TABLE IF NOT EXISTS `biz_member_message` (
  `message_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '消息ID',
  `member_id` bigint(20) NOT NULL COMMENT '收件会员ID',
  `biz_type` varchar(32) NOT NULL COMMENT '业务类型',
  `biz_id` bigint(20) DEFAULT NULL COMMENT '业务ID',
  `title` varchar(128) NOT NULL COMMENT '标题',
  `content` varchar(1000) DEFAULT NULL COMMENT '内容',
  `read_flag` char(1) NOT NULL DEFAULT '0' COMMENT '0未读1已读',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`message_id`),
  KEY `idx_member_time` (`member_id`,`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员站内消息';