CREATE TABLE IF NOT EXISTS `tcm_app_user_notification_setting` (
|
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
|
`app_user_id` BIGINT UNSIGNED NOT NULL COMMENT 'APP用户ID',
|
`order_status_update_enabled` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '订单状态更新通知开关',
|
`activity_notice_enabled` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '活动通知开关',
|
`course_update_enabled` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '课程更新通知开关',
|
`live_reservation_enabled` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '直播预约通知开关',
|
`advance_notice_minutes` INT NOT NULL DEFAULT 60 COMMENT '直播提醒提前分钟数',
|
`deleted` TINYINT(1) NOT NULL DEFAULT 0,
|
`created_by` VARCHAR(64) NOT NULL DEFAULT '系统初始化' COMMENT '创建人',
|
`updated_by` VARCHAR(64) NOT NULL DEFAULT '系统初始化' COMMENT '更新人',
|
`created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
PRIMARY KEY (`id`),
|
UNIQUE KEY `uk_app_user_notification_setting_user_deleted` (`app_user_id`, `deleted`),
|
KEY `idx_app_user_notification_setting_user` (`app_user_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='APP用户通知设置表';
|
