CREATE TABLE IF NOT EXISTS `tcm_app_user_activity_notice` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `app_user_id` bigint NOT NULL COMMENT 'APP用户ID',
  `activity_notice_id` bigint NOT NULL COMMENT '活动通知主键',
  `read_at` datetime DEFAULT NULL COMMENT '已读时间',
  `deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除：0否 1是',
  `created_by` varchar(64) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(64) DEFAULT NULL COMMENT '更新人',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_app_user_activity_notice_deleted` (`app_user_id`,`activity_notice_id`,`deleted`),
  KEY `idx_app_user_created_at` (`app_user_id`,`deleted`,`created_at`),
  KEY `idx_activity_notice_deleted` (`activity_notice_id`,`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='APP用户活动通知记录表';