From 0bc54f2346e919644f7b14c1e91dbb789f59b063 Mon Sep 17 00:00:00 2001 From: “mitao” <“2763622819@qq.com”> Date: 星期二, 14 四月 2026 22:21:11 +0800 Subject: [PATCH] feat:APP课程模块、健康科普 --- tcm-training-admin-backend/sql/init.sql | 19 +++++++++++++++++++ 1 files changed, 19 insertions(+), 0 deletions(-) diff --git a/tcm-training-admin-backend/sql/init.sql b/tcm-training-admin-backend/sql/init.sql index 5cb762c..f99ebc8 100644 --- a/tcm-training-admin-backend/sql/init.sql +++ b/tcm-training-admin-backend/sql/init.sql @@ -669,6 +669,25 @@ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='养生课程收藏记录表'; -- ---------------------------- +-- 养生课程：会员加课记录 +-- ---------------------------- +CREATE TABLE IF NOT EXISTS `tcm_health_course_member_join_record` ( + `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, + `course_id` BIGINT UNSIGNED NOT NULL COMMENT '养生课程ID', + `app_user_id` BIGINT UNSIGNED NOT NULL COMMENT '用户ID', + `joined_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP 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_health_course_member_join` (`course_id`, `app_user_id`, `deleted`), + KEY `idx_health_course_member_join_user` (`app_user_id`), + KEY `idx_health_course_member_join_time` (`joined_at`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='养生课程会员加课记录表'; + +-- ---------------------------- -- 内容：咨询点击记录 -- ---------------------------- CREATE TABLE IF NOT EXISTS `tcm_content_consult_click_record` ( -- Gitblit v1.7.1