CREATE TABLE `sys_notice_user_rel` (
  `snyr_notice_id` varchar(64) NOT NULL COMMENT '公告ID(sys_notice.notice_id)',
  `snyr_user_id` bigint(20) NOT NULL COMMENT '用户ID(sys_user.user_id)',
  `snyr_user_status` char(1) DEFAULT '0' COMMENT '0:未读 1:已读',
  PRIMARY KEY (`snyr_notice_id`,`snyr_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='通知公告人员表关系表';