sys_notice_user_rel.sql 339 B

12345
  1. CREATE TABLE `sys_notice_user_rel` (
  2. `snyr_notice_id` varchar(64) NOT NULL COMMENT '公告ID(sys_notice.notice_id)',
  3. `snyr_user_id` bigint(20) NOT NULL COMMENT '用户ID(sys_user.user_id)',
  4. PRIMARY KEY (`snyr_notice_id`, `snyr_user_id`)
  5. ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='通知公告人员表关系表'