/* Navicat Premium Data Transfer Source Server : 海政通线上 Source Server Type : MySQL Source Server Version : 80044 (8.0.44) Source Host : 124.71.107.223:10633 Source Schema : tcm_training_admin Target Server Type : MySQL Target Server Version : 80044 (8.0.44) File Encoding : 65001 Date: 01/09/2026 14:25:26 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for sys_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `id` bigint NOT NULL AUTO_INCREMENT, `parent_id` bigint NOT NULL DEFAULT 0 COMMENT '父级ID，0表示根节点', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '权限/菜单名称', `menu_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单编码', `type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '类型：M模块 C菜单 B按钮', `path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路由路径', `component` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '前端组件', `icon` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图标', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', `visible` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示：1显示 0隐藏', `permission_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限标识', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_sys_menu_code`(`menu_code` ASC) USING BTREE, INDEX `idx_sys_menu_parent_id`(`parent_id` ASC) USING BTREE, INDEX `idx_sys_menu_type`(`type` ASC) USING BTREE, INDEX `idx_sys_menu_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6151 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '后台菜单与权限表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_menu_20260827_bak -- ---------------------------- DROP TABLE IF EXISTS `sys_menu_20260827_bak`; CREATE TABLE `sys_menu_20260827_bak` ( `id` bigint NOT NULL AUTO_INCREMENT, `parent_id` bigint NOT NULL DEFAULT 0 COMMENT '父级ID，0表示根节点', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '权限/菜单名称', `menu_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单编码', `type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '类型：M模块 C菜单 B按钮', `path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路由路径', `component` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '前端组件', `icon` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图标', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', `visible` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示：1显示 0隐藏', `permission_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限标识', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_sys_menu_code`(`menu_code` ASC) USING BTREE, INDEX `idx_sys_menu_parent_id`(`parent_id` ASC) USING BTREE, INDEX `idx_sys_menu_type`(`type` ASC) USING BTREE, INDEX `idx_sys_menu_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6114 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '后台菜单与权限表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_menu_2026_0806_back -- ---------------------------- DROP TABLE IF EXISTS `sys_menu_2026_0806_back`; CREATE TABLE `sys_menu_2026_0806_back` ( `id` bigint NOT NULL AUTO_INCREMENT, `parent_id` bigint NOT NULL DEFAULT 0 COMMENT '父级ID，0表示根节点', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '权限/菜单名称', `menu_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单编码', `type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '类型：M模块 C菜单 B按钮', `path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路由路径', `component` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '前端组件', `icon` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图标', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', `visible` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示：1显示 0隐藏', `permission_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限标识', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_sys_menu_code`(`menu_code` ASC) USING BTREE, INDEX `idx_sys_menu_parent_id`(`parent_id` ASC) USING BTREE, INDEX `idx_sys_menu_type`(`type` ASC) USING BTREE, INDEX `idx_sys_menu_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5032 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '后台菜单与权限表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_region -- ---------------------------- DROP TABLE IF EXISTS `sys_region`; CREATE TABLE `sys_region` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '城市名称', `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `cityCode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `parentId` int NULL DEFAULT NULL COMMENT '父级ID', `english` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '英文名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 3537 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '省市区三级联动' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_role -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `id` bigint NOT NULL AUTO_INCREMENT, `role_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色名称', `role_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色编码', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_sys_role_name`(`role_name` ASC) USING BTREE, UNIQUE INDEX `uk_sys_role_code`(`role_code` ASC) USING BTREE, INDEX `idx_sys_role_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '后台角色表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_role_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `id` bigint NOT NULL AUTO_INCREMENT, `role_id` bigint NOT NULL COMMENT '角色ID', `menu_id` bigint NOT NULL COMMENT '菜单/权限ID', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_sys_role_menu`(`role_id` ASC, `menu_id` ASC) USING BTREE, INDEX `idx_sys_role_menu_menu_id`(`menu_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2731 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色菜单权限关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_role_menu_20260827_bak -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu_20260827_bak`; CREATE TABLE `sys_role_menu_20260827_bak` ( `id` bigint NOT NULL AUTO_INCREMENT, `role_id` bigint NOT NULL COMMENT '角色ID', `menu_id` bigint NOT NULL COMMENT '菜单/权限ID', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_sys_role_menu`(`role_id` ASC, `menu_id` ASC) USING BTREE, INDEX `idx_sys_role_menu_menu_id`(`menu_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2429 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色菜单权限关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_role_menu_2026_0806_back -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu_2026_0806_back`; CREATE TABLE `sys_role_menu_2026_0806_back` ( `id` bigint NOT NULL AUTO_INCREMENT, `role_id` bigint NOT NULL COMMENT '角色ID', `menu_id` bigint NOT NULL COMMENT '菜单/权限ID', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_sys_role_menu`(`role_id` ASC, `menu_id` ASC) USING BTREE, INDEX `idx_sys_role_menu_menu_id`(`menu_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2405 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色菜单权限关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `id` bigint NOT NULL AUTO_INCREMENT, `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `real_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '人员名称', `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系电话', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `status` tinyint NOT NULL DEFAULT 1, `deleted` tinyint(1) NOT NULL DEFAULT 0, `last_login_at` datetime NULL DEFAULT NULL COMMENT '最后登录时间', `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_sys_user_username`(`username` ASC) USING BTREE, UNIQUE INDEX `uk_sys_user_phone`(`phone` ASC) USING BTREE, INDEX `idx_sys_user_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_user_role -- ---------------------------- DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `id` bigint NOT NULL AUTO_INCREMENT, `user_id` bigint NOT NULL COMMENT '帐号ID', `role_id` bigint NOT NULL COMMENT '角色ID', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_sys_user_role`(`user_id` ASC, `role_id` ASC) USING BTREE, INDEX `idx_sys_user_role_role_id`(`role_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '帐号角色关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_activity_notice -- ---------------------------- DROP TABLE IF EXISTS `tcm_activity_notice`; CREATE TABLE `tcm_activity_notice` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '通知标题', `content_html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '通知内容富文本', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_activity_notice_created_at`(`created_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '活动通知表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_agent_region -- ---------------------------- DROP TABLE IF EXISTS `tcm_agent_region`; CREATE TABLE `tcm_agent_region` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '记录ID，主键，自增', `agent_id` bigint NOT NULL COMMENT '关联省代理人员ID，外键指向 provincial_agent.id', `region_code` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '6位行政区划编码（如：510101 表示成都市辖区）', `region_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区域名称（冗余字段，便于直接展示，如：成都市）', `region_level` tinyint NULL DEFAULT NULL COMMENT '区域行政级别：1-省级，2-市级，3-区县级，4-乡镇级（可根据编码前缀判断）', `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_agent_region`(`agent_id` ASC, `region_code` ASC) USING BTREE COMMENT '联合唯一索引，防止同一代理重复添加同一区域' ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理负责区域表，存储每个省代理所管辖的具体区域（一对多关系，一个代理可负责多个区域）' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_agreement_content -- ---------------------------- DROP TABLE IF EXISTS `tcm_agreement_content`; CREATE TABLE `tcm_agreement_content` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `agreement_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '协议类型', `content_html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '协议内容富文本', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_agreement_content_type_deleted`(`agreement_type` ASC, `deleted` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '协议内容表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_app_system_notice -- ---------------------------- DROP TABLE IF EXISTS `tcm_app_system_notice`; CREATE TABLE `tcm_app_system_notice` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `app_user_id` bigint NOT NULL COMMENT 'APP用户ID', `notice_type_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '通知类型编码', `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '通知标题', `content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '通知摘要内容', `reference_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '业务引用类型', `reference_id` bigint NULL DEFAULT NULL COMMENT '业务引用主键', `payload_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '透传载荷JSON', `push_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING' COMMENT '推送状态：PENDING/SUCCESS/FAILED/SKIPPED', `push_error_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '推送失败原因', `pushed_at` datetime NULL DEFAULT NULL COMMENT '推送时间', `read_at` datetime NULL DEFAULT NULL COMMENT '已读时间', `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '是否删除：0否 1是', `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL 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`) USING BTREE, UNIQUE INDEX `uk_app_notice_ref_deleted`(`app_user_id` ASC, `notice_type_code` ASC, `reference_type` ASC, `reference_id` ASC, `deleted` ASC) USING BTREE, INDEX `idx_app_notice_user_created`(`app_user_id` ASC, `deleted` ASC, `created_at` ASC) USING BTREE, INDEX `idx_app_notice_type_created`(`notice_type_code` ASC, `deleted` ASC, `created_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 671 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'APP统一系统通知表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_app_user -- ---------------------------- DROP TABLE IF EXISTS `tcm_app_user`; CREATE TABLE `tcm_app_user` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名称（昵称）', `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号（登录账号）', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录密码（加密存储）', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像URL', `wechat_openid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信OpenID', `wechat_nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信昵称', `wechat_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信头像URL', `wechat_bound_at` datetime NULL DEFAULT NULL COMMENT '微信绑定时间', `apple_user_identifier` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '苹果用户标识', `apple_identity_subject` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '苹果身份主题标识', `apple_bound_at` datetime NULL DEFAULT NULL COMMENT '苹果绑定时间', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '用户类型：0个人 1诊所', `gender` tinyint(1) NULL DEFAULT NULL COMMENT '性别：0女 1男', `age` tinyint UNSIGNED NULL DEFAULT NULL COMMENT '年龄', `intro` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '个人介绍', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', `clinic_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '绑定诊所ID（type=1时有值）', `superior_clinic_user_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '上级诊所用户ID', `member_expire_at` datetime NULL DEFAULT NULL COMMENT '会员有效期（NULL=非会员，有值且未过期=会员）', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_app_user_phone`(`phone` ASC) USING BTREE, INDEX `idx_app_user_clinic`(`clinic_id` ASC) USING BTREE, INDEX `idx_app_user_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9844 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '学员表（C端用户）' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_app_user_activity_notice -- ---------------------------- DROP TABLE IF EXISTS `tcm_app_user_activity_notice`; CREATE TABLE `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 NULL DEFAULT NULL COMMENT '已读时间', `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '是否删除：0否 1是', `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL 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`) USING BTREE, UNIQUE INDEX `uk_app_user_activity_notice_deleted`(`app_user_id` ASC, `activity_notice_id` ASC, `deleted` ASC) USING BTREE, INDEX `idx_app_user_created_at`(`app_user_id` ASC, `deleted` ASC, `created_at` ASC) USING BTREE, INDEX `idx_activity_notice_deleted`(`activity_notice_id` ASC, `deleted` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'APP用户活动通知记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_app_user_entry_log -- ---------------------------- DROP TABLE IF EXISTS `tcm_app_user_entry_log`; CREATE TABLE `tcm_app_user_entry_log` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `app_user_id` bigint UNSIGNED NOT NULL COMMENT 'APP用户ID', `entry_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '进入系统时间', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_app_user_entry_log_user_time`(`app_user_id` ASC, `entry_time` ASC) USING BTREE, INDEX `idx_app_user_entry_log_entry_time`(`entry_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'APP用户进入系统记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_app_user_notice_read_record -- ---------------------------- DROP TABLE IF EXISTS `tcm_app_user_notice_read_record`; CREATE TABLE `tcm_app_user_notice_read_record` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `app_user_id` bigint NOT NULL COMMENT 'APP用户ID', `notice_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '通知类型', `last_read_at` datetime NULL DEFAULT NULL COMMENT '最后已读时间', `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '是否删除：0否 1是', `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL 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`) USING BTREE, UNIQUE INDEX `uk_app_user_notice_type_deleted`(`app_user_id` ASC, `notice_type` ASC, `deleted` ASC) USING BTREE, INDEX `idx_notice_type`(`notice_type` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 200 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'APP用户通知已读记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_app_user_notification_setting -- ---------------------------- DROP TABLE IF EXISTS `tcm_app_user_notification_setting`; CREATE TABLE `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) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_app_user_notification_setting_user_deleted`(`app_user_id` ASC, `deleted` ASC) USING BTREE, INDEX `idx_app_user_notification_setting_user`(`app_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'APP用户通知设置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_app_version_config -- ---------------------------- DROP TABLE IF EXISTS `tcm_app_version_config`; CREATE TABLE `tcm_app_version_config` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `version_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '展示版本号', `version_code` int NOT NULL COMMENT '版本字段', `android_file_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '安卓文件地址', `android_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '安卓文件名称', `ios_file_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'iOS文件地址', `ios_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'iOS文件名称', `force_update` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否强制更新：1是 0否', `update_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '更新说明', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_app_version_code`(`version_code` ASC) USING BTREE, INDEX `idx_app_version_created_at`(`created_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'APP版本设置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_clinic -- ---------------------------- DROP TABLE IF EXISTS `tcm_clinic`; CREATE TABLE `tcm_clinic` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '诊所名称', `agent_id` bigint NULL DEFAULT NULL COMMENT '负责该诊所的省代理ID，tcm_provincial_agent.id', `contact_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人姓名', `contact_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人电话', `province_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省编码', `province_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省名称', `city_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '市编码', `city_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '市名称', `district_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区编码', `district_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区名称', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '诊所地址', `business_license_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '营业执照图片', `invite_code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邀请码', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', `bank_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户银行名称（如：中国建设银行）', `account_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行账号', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '账户名称/户名（即开户人姓名或公司名称）', `branch_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户支行名称（如：成都高新支行）', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_clinic_invite_code`(`invite_code` ASC) USING BTREE, INDEX `idx_clinic_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8207 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '诊所表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_clinic_2026_0806_back -- ---------------------------- DROP TABLE IF EXISTS `tcm_clinic_2026_0806_back`; CREATE TABLE `tcm_clinic_2026_0806_back` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '诊所名称', `contact_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人姓名', `contact_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人电话', `province_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省编码', `province_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省名称', `city_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '市编码', `city_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '市名称', `district_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区编码', `district_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区名称', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '诊所地址', `business_license_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '营业执照图片', `invite_code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邀请码', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_clinic_invite_code`(`invite_code` ASC) USING BTREE, INDEX `idx_clinic_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8202 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '诊所表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_common_question -- ---------------------------- DROP TABLE IF EXISTS `tcm_common_question`; CREATE TABLE `tcm_common_question` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '问题标题', `content_html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '问题内容富文本', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_common_question_created_at`(`created_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '常见问题表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_content_consult_click_record -- ---------------------------- DROP TABLE IF EXISTS `tcm_content_consult_click_record`; CREATE TABLE `tcm_content_consult_click_record` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `content_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '内容类型：LIVE/HEALTH_COURSE', `content_id` bigint UNSIGNED NOT NULL COMMENT '内容ID', `app_user_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '用户ID', `clicked_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '点击时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_content_consult_type_content`(`content_type` ASC, `content_id` ASC) USING BTREE, INDEX `idx_content_consult_user`(`app_user_id` ASC) USING BTREE, INDEX `idx_content_consult_time`(`clicked_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5317 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '内容咨询点击记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_course_purchase_order -- ---------------------------- DROP TABLE IF EXISTS `tcm_course_purchase_order`; CREATE TABLE `tcm_course_purchase_order` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `order_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单编号', `app_user_id` bigint UNSIGNED NOT NULL COMMENT '用户ID', `user_nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户昵称快照', `user_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户手机号快照', `course_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程类型：HEALTH_COURSE养生课程，可扩展', `purchase_target_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '购买对象类型：COURSE整课 COURSE_CHAPTER课程小节', `course_id` bigint UNSIGNED NOT NULL COMMENT '课程ID', `course_video_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '课程小节ID（整课购买为空）', `product_name_snapshot` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品名称快照：整课=课程名称 小节=课程名称-小节名称', `course_title_snapshot` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程名称快照', `chapter_name_snapshot` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '小节名称快照', `cover_img_snapshot` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '课程封面图快照', `order_amount` decimal(10, 2) NOT NULL COMMENT '订单金额快照', `payment_method` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '付款方式：WECHAT微信 ALIPAY支付宝', `refund_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '退款金额', `refund_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '退款备注', `status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单状态：WAITING_PAYMENT待支付 PAID已支付 REFUNDED已退款 CANCELLED已取消', `paid_at` datetime NULL DEFAULT NULL COMMENT '支付时间', `refunded_at` datetime NULL DEFAULT NULL COMMENT '退款时间', `cancelled_at` datetime NULL DEFAULT NULL COMMENT '取消时间', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_course_purchase_order_no`(`order_no` ASC) USING BTREE, INDEX `idx_course_purchase_order_user`(`app_user_id` ASC) USING BTREE, INDEX `idx_course_purchase_order_status`(`status` ASC) USING BTREE, INDEX `idx_course_purchase_order_course_type`(`course_type` ASC) USING BTREE, INDEX `idx_course_purchase_order_target_type`(`purchase_target_type` ASC) USING BTREE, INDEX `idx_course_purchase_order_course`(`course_id` ASC) USING BTREE, INDEX `idx_course_purchase_order_course_video`(`course_video_id` ASC) USING BTREE, INDEX `idx_course_purchase_order_payment_method`(`payment_method` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 188 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '课程购买订单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_expert -- ---------------------------- DROP TABLE IF EXISTS `tcm_expert`; CREATE TABLE `tcm_expert` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `specialty` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '擅长领域', `intro` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '专家介绍', `status` tinyint NOT NULL DEFAULT 1, `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_expert_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '授课专家表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_health_course -- ---------------------------- DROP TABLE IF EXISTS `tcm_health_course`; CREATE TABLE `tcm_health_course` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '养生课程ID', `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程名称', `level_category_id` bigint UNSIGNED NOT NULL COMMENT '养生等级分类ID', `difficulty_category_id` bigint UNSIGNED NOT NULL COMMENT '难度分类ID', `expert_id` bigint UNSIGNED NOT NULL COMMENT '授课专家ID', `sale_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '课程售价', `summary` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '课程简介', `target_users` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '适用人群', `cover_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '课程封面图URL', `banner_imgs` json NULL COMMENT '课程宣传图URL列表（多图）', `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '课程介绍（富文本）', `base_sales_count` int NOT NULL DEFAULT 0 COMMENT '基础销量', `real_sales_count` int NOT NULL DEFAULT 0 COMMENT '真实销量', `learn_user_count` int NOT NULL DEFAULT 0 COMMENT '累计学习人数', `favorite_count` int NOT NULL DEFAULT 0 COMMENT '收藏量', `total_duration_seconds` int NOT NULL DEFAULT 0 COMMENT '课程总时长（秒）', `video_count` int NOT NULL DEFAULT 0 COMMENT '视频小节数', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', `is_home_recommend` tinyint(1) NOT NULL DEFAULT 0 COMMENT '首页推荐：1是 0否', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_health_course_level`(`level_category_id` ASC) USING BTREE, INDEX `idx_health_course_difficulty`(`difficulty_category_id` ASC) USING BTREE, INDEX `idx_health_course_expert`(`expert_id` ASC) USING BTREE, INDEX `idx_health_course_status`(`status` ASC) USING BTREE, INDEX `idx_health_course_home_recommend`(`is_home_recommend` ASC) USING BTREE, INDEX `idx_health_course_created_at`(`created_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '养生课程表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_health_course_download_record -- ---------------------------- DROP TABLE IF EXISTS `tcm_health_course_download_record`; CREATE TABLE `tcm_health_course_download_record` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `app_user_id` bigint UNSIGNED NOT NULL COMMENT '用户ID', `course_id` bigint UNSIGNED NOT NULL COMMENT '养生课程ID', `course_video_id` bigint UNSIGNED NOT NULL COMMENT '视频小节ID', `course_title_snapshot` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '课程标题快照', `chapter_name_snapshot` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '章节标题快照', `cover_img_snapshot` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '封面图快照', `video_url_snapshot` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '视频地址快照', `duration_seconds_snapshot` int NOT NULL DEFAULT 0 COMMENT '视频时长快照（秒）', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_health_course_download_user_deleted_created`(`app_user_id` ASC, `deleted` ASC, `created_at` ASC) USING BTREE, INDEX `idx_health_course_download_user_video_deleted`(`app_user_id` ASC, `course_video_id` ASC, `deleted` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '养生课程下载记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_health_course_favorite_record -- ---------------------------- DROP TABLE IF EXISTS `tcm_health_course_favorite_record`; CREATE TABLE `tcm_health_course_favorite_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', `action_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '操作类型：FAVORITE/CANCEL', `action_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_health_course_favorite_course`(`course_id` ASC) USING BTREE, INDEX `idx_health_course_favorite_user`(`app_user_id` ASC) USING BTREE, INDEX `idx_health_course_favorite_time`(`action_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5249 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '养生课程收藏记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_health_course_member_join_record -- ---------------------------- DROP TABLE IF EXISTS `tcm_health_course_member_join_record`; CREATE TABLE `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) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_health_course_member_join`(`course_id` ASC, `app_user_id` ASC, `deleted` ASC) USING BTREE, INDEX `idx_health_course_member_join_user`(`app_user_id` ASC) USING BTREE, INDEX `idx_health_course_member_join_time`(`joined_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '养生课程会员加课记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_health_course_play_record -- ---------------------------- DROP TABLE IF EXISTS `tcm_health_course_play_record`; CREATE TABLE `tcm_health_course_play_record` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `course_id` bigint UNSIGNED NOT NULL COMMENT '养生课程ID', `video_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '视频小节ID', `app_user_id` bigint UNSIGNED NOT NULL COMMENT '用户ID', `play_start` datetime NOT NULL COMMENT '开始播放时间', `play_end` datetime NULL DEFAULT NULL COMMENT '结束播放时间', `duration_seconds` int NOT NULL DEFAULT 0 COMMENT '累计播放时长（秒）', `is_completed` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否完播：1是 0否', `last_play_position_seconds` int NOT NULL DEFAULT 0 COMMENT '本次结束时播放位置（秒）', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_health_course_play_course`(`course_id` ASC) USING BTREE, INDEX `idx_health_course_play_video`(`video_id` ASC) USING BTREE, INDEX `idx_health_course_play_user`(`app_user_id` ASC) USING BTREE, INDEX `idx_health_course_play_start`(`play_start` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5972 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '养生课程播放记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_health_course_video -- ---------------------------- DROP TABLE IF EXISTS `tcm_health_course_video`; CREATE TABLE `tcm_health_course_video` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '视频小节ID', `course_type` tinyint NOT NULL DEFAULT 1 COMMENT '课程类型：1养生课程', `course_id` bigint UNSIGNED NOT NULL COMMENT '所属养生课程ID', `chapter_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '小节名称', `video_source_type` tinyint NOT NULL DEFAULT 1 COMMENT '视频来源：1视频地址 2本地上传', `video_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频地址', `video_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '本地上传原始文件名', `duration_seconds` int NOT NULL DEFAULT 0 COMMENT '视频时长（秒）', `sale_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '小节售价', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_health_course_video_course_sort`(`course_id` ASC, `sort` ASC) USING BTREE, INDEX `idx_health_course_video_status`(`course_id` ASC, `status` ASC) USING BTREE, INDEX `idx_health_course_video_type_status`(`course_type` ASC, `status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '养生课程视频小节表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_health_popularization -- ---------------------------- DROP TABLE IF EXISTS `tcm_health_popularization`; CREATE TABLE `tcm_health_popularization` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '健康科普ID', `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标题', `cover_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '封面图', `content_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '内容类型：1图文 2视频', `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '图文内容', `video_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频地址', `video_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频文件名', `video_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频介绍', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', `is_home_recommend` tinyint(1) NOT NULL DEFAULT 0 COMMENT '首页推荐：1是 0否', `click_count` int NOT NULL DEFAULT 0 COMMENT '点击量', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_health_popularization_type`(`content_type` ASC) USING BTREE, INDEX `idx_health_popularization_status`(`status` ASC) USING BTREE, INDEX `idx_health_popularization_home_recommend`(`is_home_recommend` ASC) USING BTREE, INDEX `idx_health_popularization_created_at`(`created_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '健康科普表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_health_popularization_2026_0806_back -- ---------------------------- DROP TABLE IF EXISTS `tcm_health_popularization_2026_0806_back`; CREATE TABLE `tcm_health_popularization_2026_0806_back` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '健康科普ID', `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标题', `cover_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '封面图', `content_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '内容类型：1图文 2视频', `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '图文内容', `video_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频地址', `video_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频文件名', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', `is_home_recommend` tinyint(1) NOT NULL DEFAULT 0 COMMENT '首页推荐：1是 0否', `click_count` int NOT NULL DEFAULT 0 COMMENT '点击量', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_health_popularization_type`(`content_type` ASC) USING BTREE, INDEX `idx_health_popularization_status`(`status` ASC) USING BTREE, INDEX `idx_health_popularization_home_recommend`(`is_home_recommend` ASC) USING BTREE, INDEX `idx_health_popularization_created_at`(`created_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '健康科普表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_live_course -- ---------------------------- DROP TABLE IF EXISTS `tcm_live_course`; CREATE TABLE `tcm_live_course` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '直播课程ID', `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程名称', `level` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '课程级别：初级/中级/高级', `expert_id` bigint UNSIGNED NOT NULL COMMENT '授课专家ID', `cover_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '课程封面图URL', `banner_imgs` json NULL COMMENT '课程宣传图URL列表（多图）', `intro` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '课程介绍（富文本）', `target_users` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '适用人群', `quiz_delay_minutes` int NOT NULL DEFAULT 0 COMMENT '可答题时间：直播开始N分钟后解锁答题', `quiz_points` int NOT NULL DEFAULT 0 COMMENT '答题可得积分', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '启用状态：1启用 0禁用', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '直播间密码', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_expert`(`expert_id` ASC) USING BTREE, INDEX `idx_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '养生直播课程表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_live_course_2026_0806_back -- ---------------------------- DROP TABLE IF EXISTS `tcm_live_course_2026_0806_back`; CREATE TABLE `tcm_live_course_2026_0806_back` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '直播课程ID', `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程名称', `level` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '课程级别：初级/中级/高级', `expert_id` bigint UNSIGNED NOT NULL COMMENT '授课专家ID', `cover_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '课程封面图URL', `banner_imgs` json NULL COMMENT '课程宣传图URL列表（多图）', `intro` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '课程介绍（富文本）', `target_users` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '适用人群', `quiz_delay_minutes` int NOT NULL DEFAULT 0 COMMENT '可答题时间：直播开始N分钟后解锁答题', `quiz_points` int NOT NULL DEFAULT 0 COMMENT '答题可得积分', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '启用状态：1启用 0禁用', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_expert`(`expert_id` ASC) USING BTREE, INDEX `idx_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '养生直播课程表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_live_course_category -- ---------------------------- DROP TABLE IF EXISTS `tcm_live_course_category`; CREATE TABLE `tcm_live_course_category` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类ID', `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '分类类型：LEVEL/DIFFICULTY', `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '分类名称', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_type_sort`(`type` ASC, `sort` ASC) USING BTREE, INDEX `idx_type_name`(`type` ASC, `name` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '直播课程分类表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_live_reserve -- ---------------------------- DROP TABLE IF EXISTS `tcm_live_reserve`; CREATE TABLE `tcm_live_reserve` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `live_course_id` bigint UNSIGNED NOT NULL COMMENT '直播课程ID', `session_id` bigint UNSIGNED NOT NULL COMMENT '场次ID', `app_user_id` bigint UNSIGNED NOT NULL COMMENT '用户ID', `reserve_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '预约时间', `is_cancel` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否取消：0否 1是', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_session_app_user`(`session_id` ASC, `app_user_id` ASC) USING BTREE, INDEX `idx_live_course_reserve`(`live_course_id` ASC) USING BTREE, INDEX `idx_app_user_reserve`(`app_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 148 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '直播预约记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_live_room_setting -- ---------------------------- DROP TABLE IF EXISTS `tcm_live_room_setting`; CREATE TABLE `tcm_live_room_setting` ( `banner_image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Banner图片地址', `live_room_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '直播间地址' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '微赞直播间设置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_live_session -- ---------------------------- DROP TABLE IF EXISTS `tcm_live_session`; CREATE TABLE `tcm_live_session` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '场次ID', `live_course_id` bigint UNSIGNED NOT NULL COMMENT '所属直播课程ID', `start_time` datetime NULL DEFAULT NULL COMMENT '开始直播时间', `video_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频地址', `duration_seconds` int NULL DEFAULT NULL COMMENT '视频时长（秒）', `base_reserve_count` int NOT NULL DEFAULT 0 COMMENT '基础预约量（初始刷基数）', `base_watch_count` int NOT NULL DEFAULT 0 COMMENT '基础观看量（初始刷基数）', `real_reserve_count` int NOT NULL DEFAULT 0 COMMENT '真实预约人数', `real_watch_count` int NOT NULL DEFAULT 0 COMMENT '真实观看人数', `reserve_convert_rate` decimal(5, 2) NOT NULL DEFAULT 0.00 COMMENT '预约转化率（%）', `completion_rate` decimal(5, 2) NOT NULL DEFAULT 0.00 COMMENT '完播率（%）', `effective_watch_rate` decimal(5, 2) NOT NULL DEFAULT 0.00 COMMENT '有效观看率（%）', `quiz_correct_count` int NOT NULL DEFAULT 0 COMMENT '答题正确人数', `points_issued` int NOT NULL DEFAULT 0 COMMENT '累计发放积分', `live_status` tinyint NOT NULL DEFAULT 0 COMMENT '上课状态：0未开始 1直播中 2已结束', `actual_start_time` datetime NULL DEFAULT NULL COMMENT '实际开播时间', `actual_end_time` datetime NULL DEFAULT NULL COMMENT '实际结束时间', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_live_course`(`live_course_id` ASC) USING BTREE, INDEX `idx_start_time`(`start_time` ASC) USING BTREE, INDEX `idx_live_status`(`live_status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 90133 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '直播场次表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_live_session_question -- ---------------------------- DROP TABLE IF EXISTS `tcm_live_session_question`; CREATE TABLE `tcm_live_session_question` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '题目ID', `session_id` bigint UNSIGNED NOT NULL COMMENT '所属场次ID', `sort` tinyint NOT NULL DEFAULT 1 COMMENT '题目序号：1/2/3', `stem` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '题干内容', `option_a` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '选项A内容', `option_b` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '选项B内容', `option_c` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '选项C内容', `correct_option` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '正确答案：A/B/C', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_session_sort_deleted`(`session_id` ASC, `sort` ASC, `deleted` ASC) USING BTREE, INDEX `idx_session`(`session_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1398 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '直播场次内嵌题目表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_live_session_quiz_record -- ---------------------------- DROP TABLE IF EXISTS `tcm_live_session_quiz_record`; CREATE TABLE `tcm_live_session_quiz_record` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `session_id` bigint UNSIGNED NOT NULL COMMENT '场次ID', `app_user_id` bigint UNSIGNED NOT NULL COMMENT '用户ID', `question_id` bigint UNSIGNED NOT NULL COMMENT '题目ID', `chosen_option` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '学员所选答案：A/B/C', `is_correct` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否答对：1是 0否', `points_earned` int NOT NULL DEFAULT 0 COMMENT '本题获得积分', `answered_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '答题时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_session_app_user_question`(`session_id` ASC, `app_user_id` ASC, `question_id` ASC) USING BTREE, INDEX `idx_session_quiz`(`session_id` ASC) USING BTREE, INDEX `idx_app_user_quiz`(`app_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5723 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '场次答题记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_live_watch_record -- ---------------------------- DROP TABLE IF EXISTS `tcm_live_watch_record`; CREATE TABLE `tcm_live_watch_record` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `live_course_id` bigint UNSIGNED NOT NULL COMMENT '直播课程ID', `session_id` bigint UNSIGNED NOT NULL COMMENT '场次ID', `app_user_id` bigint UNSIGNED NOT NULL COMMENT '用户ID', `watch_start` datetime NOT NULL COMMENT '开始观看时间', `watch_end` datetime NULL DEFAULT NULL COMMENT '结束观看时间', `duration_seconds` int NOT NULL DEFAULT 0 COMMENT '累计观看时长（秒）', `is_completed` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否完播：1是 0否', `is_effective` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有效观看：1是 0否', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_session_watch`(`session_id` ASC) USING BTREE, INDEX `idx_live_course_watch`(`live_course_id` ASC) USING BTREE, INDEX `idx_app_user_watch`(`app_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5983 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '直播观看记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_member_intro_config -- ---------------------------- DROP TABLE IF EXISTS `tcm_member_intro_config`; CREATE TABLE `tcm_member_intro_config` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `module_count` int NOT NULL DEFAULT 0 COMMENT '模块数量', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '会员权益说明', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '会员介绍配置主表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_member_intro_item -- ---------------------------- DROP TABLE IF EXISTS `tcm_member_intro_item`; CREATE TABLE `tcm_member_intro_item` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `config_id` bigint UNSIGNED NOT NULL COMMENT '配置ID', `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '图片地址', `description` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '权益名称', `sort` int NOT NULL DEFAULT 1 COMMENT '排序', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_member_intro_item_config_sort`(`config_id` ASC, `sort` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '会员介绍图文模块表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_member_price_config -- ---------------------------- DROP TABLE IF EXISTS `tcm_member_price_config`; CREATE TABLE `tcm_member_price_config` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `month_card_price` decimal(10, 2) NOT NULL DEFAULT 69.00 COMMENT '月卡会员价格', `month_card_days` int NOT NULL DEFAULT 30 COMMENT '月卡时长', `month_card_enabled` tinyint(1) NOT NULL DEFAULT 1 COMMENT '月卡是否启用', `quarter_card_price` decimal(10, 2) NOT NULL DEFAULT 199.00 COMMENT '季卡会员价格', `quarter_card_days` int NOT NULL DEFAULT 90 COMMENT '季卡时长', `quarter_card_enabled` tinyint(1) NOT NULL DEFAULT 1 COMMENT '季卡是否启用', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '会员价格配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_member_purchase_order -- ---------------------------- DROP TABLE IF EXISTS `tcm_member_purchase_order`; CREATE TABLE `tcm_member_purchase_order` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `order_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单编号', `app_user_id` bigint UNSIGNED NOT NULL COMMENT '用户ID', `user_nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户昵称快照', `user_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户手机号快照', `member_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '会员类型：MONTH_CARD月卡 QUARTER_CARD季卡', `member_days` int NOT NULL COMMENT '会员时长天数快照', `order_amount` decimal(10, 2) NOT NULL COMMENT '订单金额快照', `payment_method` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '付款方式：WECHAT微信 ALIPAY支付宝', `refund_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '退款金额', `refund_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '退款备注', `status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单状态：WAITING_PAYMENT待支付 PAID已支付 REFUNDED已退款 CANCELLED已取消', `paid_at` datetime NULL DEFAULT NULL COMMENT '支付时间', `refunded_at` datetime NULL DEFAULT NULL COMMENT '退款时间', `cancelled_at` datetime NULL DEFAULT NULL COMMENT '取消时间', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_member_purchase_order_no`(`order_no` ASC) USING BTREE, INDEX `idx_member_purchase_order_user`(`app_user_id` ASC) USING BTREE, INDEX `idx_member_purchase_order_status`(`status` ASC) USING BTREE, INDEX `idx_member_purchase_order_member_type`(`member_type` ASC) USING BTREE, INDEX `idx_member_purchase_order_payment_method`(`payment_method` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '会员购买订单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_message_push_config -- ---------------------------- DROP TABLE IF EXISTS `tcm_message_push_config`; CREATE TABLE `tcm_message_push_config` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `notice_type_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '通知类型编码', `notice_type_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '通知类型名称', `push_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启PUSH推送：1是 0否', `sms_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启短信通知：1是 0否', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_message_push_notice_type_code`(`notice_type_code` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '消息推送配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_payment_flow -- ---------------------------- DROP TABLE IF EXISTS `tcm_payment_flow`; CREATE TABLE `tcm_payment_flow` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `flow_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '平台流水号', `business_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '业务类型：COURSE_PURCHASE课程购买 MEMBER_PURCHASE会员购买', `business_order_id` bigint UNSIGNED NOT NULL COMMENT '业务订单ID', `business_order_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '业务订单编号', `flow_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '流水类型：PAYMENT支付 REFUND退款', `trade_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '交易状态：SUCCESS成功 REFUNDED已退款', `app_user_id` bigint UNSIGNED NOT NULL COMMENT '用户ID', `user_nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户昵称快照', `user_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户手机号快照', `product_name_snapshot` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品名称快照', `payment_method` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '支付方式：WECHAT微信 ALIPAY支付宝', `transaction_amount` decimal(10, 2) NOT NULL COMMENT '交易金额', `third_party_trade_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '第三方支付单号', `third_party_refund_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '第三方退款单号', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `trade_time` datetime NOT NULL COMMENT '交易时间', `source_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '来源类型：COURSE_PAYMENT课程支付 COURSE_REFUND课程退款 MEMBER_PAYMENT会员支付 MEMBER_REFUND会员退款', `source_id` bigint UNSIGNED NOT NULL COMMENT '来源记录ID', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_payment_flow_no`(`flow_no` ASC) USING BTREE, UNIQUE INDEX `uk_payment_flow_source`(`source_type` ASC, `source_id` ASC) USING BTREE, INDEX `idx_payment_flow_business_order`(`business_type` ASC, `business_order_id` ASC) USING BTREE, INDEX `idx_payment_flow_business_order_no`(`business_order_no` ASC) USING BTREE, INDEX `idx_payment_flow_user`(`app_user_id` ASC) USING BTREE, INDEX `idx_payment_flow_flow_type`(`flow_type` ASC) USING BTREE, INDEX `idx_payment_flow_trade_status`(`trade_status` ASC) USING BTREE, INDEX `idx_payment_flow_payment_method`(`payment_method` ASC) USING BTREE, INDEX `idx_payment_flow_trade_time`(`trade_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 207 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '支付流水表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_platform_qualification -- ---------------------------- DROP TABLE IF EXISTS `tcm_platform_qualification`; CREATE TABLE `tcm_platform_qualification` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `qualification_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '资质名称', `qualification_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '资质类型：RICH_TEXT/LINK', `record_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '备案号', `content_html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '资质内容富文本', `link_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '跳转链接', `sort` int NOT NULL DEFAULT 0 COMMENT '排序', `publish_enabled` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否上架：1是 0否', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_platform_qualification_created_at`(`created_at` ASC) USING BTREE, INDEX `idx_platform_qualification_publish_enabled`(`publish_enabled` ASC) USING BTREE, INDEX `idx_platform_qualification_type`(`qualification_type` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '平台资质表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_points_config -- ---------------------------- DROP TABLE IF EXISTS `tcm_points_config`; CREATE TABLE `tcm_points_config` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `activity_start_at` datetime NOT NULL COMMENT '活动开始时间', `activity_end_at` datetime NOT NULL COMMENT '活动结束时间', `gift_cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '礼品封面图', `gift_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '礼品名称', `required_points` int NOT NULL COMMENT '所需积分', `settlement_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '结算状态：0待结算 1已结算', `settled_at` datetime NULL DEFAULT NULL COMMENT '结算时间', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_points_config_end`(`activity_end_at` ASC) USING BTREE, INDEX `idx_points_config_status`(`settlement_status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9106 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '积分设置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_points_exchange_order -- ---------------------------- DROP TABLE IF EXISTS `tcm_points_exchange_order`; CREATE TABLE `tcm_points_exchange_order` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `order_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '汇总订单编号', `config_id` bigint UNSIGNED NOT NULL COMMENT '积分配置ID', `gift_cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '礼品封面图', `gift_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '礼品名称', `required_points` int NOT NULL COMMENT '所需积分', `activity_start_at` datetime NOT NULL COMMENT '活动开始时间', `activity_end_at` datetime NOT NULL COMMENT '活动结束时间', `clinic_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '诊所ID', `clinic_app_user_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '诊所用户ID', `clinic_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '诊所名称快照', `receiver_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收件人姓名', `receiver_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收件人电话', `receiver_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收货地址', `item_count` int NOT NULL DEFAULT 0 COMMENT '兑换人数', `total_points` int NOT NULL DEFAULT 0 COMMENT '汇总积分', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态：0待发货 1已发货 2兑换完成 3已取消', `tracking_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '物流单号', `shipped_at` datetime NULL DEFAULT NULL COMMENT '发货时间', `completed_at` datetime NULL DEFAULT NULL COMMENT '完成时间', `cancelled_at` datetime NULL DEFAULT NULL COMMENT '取消时间', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_points_exchange_order_no`(`order_no` ASC) USING BTREE, INDEX `idx_points_exchange_order_config`(`config_id` ASC) USING BTREE, INDEX `idx_points_exchange_order_status`(`status` ASC) USING BTREE, INDEX `idx_points_exchange_order_clinic_app_user_id`(`clinic_app_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9309 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '积分兑换汇总订单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_points_exchange_order_item -- ---------------------------- DROP TABLE IF EXISTS `tcm_points_exchange_order_item`; CREATE TABLE `tcm_points_exchange_order_item` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `order_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '汇总订单ID', `order_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '明细订单编号', `app_user_id` bigint UNSIGNED NOT NULL COMMENT '用户ID', `user_nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户昵称快照', `user_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户电话快照', `clinic_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '诊所ID', `clinic_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '诊所名称快照', `province_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省编码快照', `province_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省名称快照', `city_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '市编码快照', `city_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '市名称快照', `district_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区编码快照', `district_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区名称快照', `settled_points` int NOT NULL DEFAULT 0 COMMENT '结算前积分', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态：0待发货 1已发货 2兑换完成 3已取消', `tracking_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '物流单号', `shipped_at` datetime NULL DEFAULT NULL COMMENT '发货时间', `completed_at` datetime NULL DEFAULT NULL COMMENT '完成时间', `cancelled_at` datetime NULL DEFAULT NULL COMMENT '取消时间', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_points_exchange_item_order_no`(`order_no` ASC) USING BTREE, INDEX `idx_points_exchange_item_order_id`(`order_id` ASC) USING BTREE, INDEX `idx_points_exchange_item_user_id`(`app_user_id` ASC) USING BTREE, INDEX `idx_points_exchange_item_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9413 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '积分兑换明细订单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_points_ledger -- ---------------------------- DROP TABLE IF EXISTS `tcm_points_ledger`; CREATE TABLE `tcm_points_ledger` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `app_user_id` bigint UNSIGNED NOT NULL COMMENT '用户ID', `user_nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户昵称快照', `user_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户电话快照', `clinic_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '诊所ID', `clinic_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '诊所名称快照', `province_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省编码快照', `province_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省名称快照', `city_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '市编码快照', `city_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '市名称快照', `district_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区编码快照', `district_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区名称快照', `income_expense_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '收支类型：INCOME/EXPENSE', `business_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '业务类型：LIVE_WATCH/POINTS_EXCHANGE', `content_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '内容名称', `reference_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '引用类型', `reference_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '引用ID', `reference_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '引用编号', `points_delta` int NOT NULL DEFAULT 0 COMMENT '积分变动值', `operated_at` datetime NOT NULL COMMENT '操作时间', `source_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '源类型', `source_id` bigint UNSIGNED NOT NULL COMMENT '源数据ID', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_points_ledger_source`(`source_type` ASC, `source_id` ASC) USING BTREE, INDEX `idx_points_ledger_user`(`app_user_id` ASC) USING BTREE, INDEX `idx_points_ledger_operated_at`(`operated_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9534 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '积分收支流水表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_project_introduction -- ---------------------------- DROP TABLE IF EXISTS `tcm_project_introduction`; CREATE TABLE `tcm_project_introduction` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标题', `cover_img` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '封面图', `category` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '类别：platform(平台介绍)、mode(营销模式)、action(营销动作)', `content_type` tinyint NOT NULL COMMENT '类型：1图文 2视频', `content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '图文内容（富文本HTML）', `video_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频地址', `video_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频文件名', `video_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频介绍', `click_count` int NOT NULL DEFAULT 0 COMMENT '点击量', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_category`(`category` ASC) USING BTREE, INDEX `idx_content_type`(`content_type` ASC) USING BTREE, INDEX `idx_status`(`status` ASC) USING BTREE, INDEX `idx_created_at`(`created_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目介绍表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_project_introduction_password -- ---------------------------- DROP TABLE IF EXISTS `tcm_project_introduction_password`; CREATE TABLE `tcm_project_introduction_password` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `password_enabled` tinyint NOT NULL DEFAULT 0 COMMENT '是否启用密码访问：1启用 0不启用', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '访问密码（加密）', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目介绍密码配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_provincial_agent -- ---------------------------- DROP TABLE IF EXISTS `tcm_provincial_agent`; CREATE TABLE `tcm_provincial_agent` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '代理ID，主键，自增', `agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '省区负责人姓名', `province` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '负责省份名称（如：四川省）', `bank_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开户银行名称（如：中国建设银行）', `account_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '银行账号', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '账户名称/户名（即开户人姓名或公司名称）', `branch_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开户支行名称（如：成都高新支行）', `contact_info` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系信息（可填电话、邮箱、手机号等）', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态：1启用，0禁用，2注销', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详细地址（如：成都市高新区天府大道XX号）', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '省代理人员信息表，存储代理的基本资料及银行账户信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_system_banner_config -- ---------------------------- DROP TABLE IF EXISTS `tcm_system_banner_config`; CREATE TABLE `tcm_system_banner_config` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `banner_img` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'Banner图片', `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'Banner标题', `start_at` datetime NOT NULL COMMENT '展示开始时间', `end_at` datetime NOT NULL COMMENT '展示结束时间', `jump_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '跳转类型', `target_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '跳转目标ID', `target_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '跳转目标名称', `target_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '三方地址', `publish_enabled` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否上架：1是 0否', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_system_banner_time`(`start_at` ASC, `end_at` ASC) USING BTREE, INDEX `idx_system_banner_jump_type`(`jump_type` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Banner配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_system_settings -- ---------------------------- DROP TABLE IF EXISTS `tcm_system_settings`; CREATE TABLE `tcm_system_settings` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `service_phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '客服电话', `service_online_time` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '客服在线时间', `backup_cycle_days` int NOT NULL COMMENT '备份周期（天）', `member_expire_remind_days` int NOT NULL COMMENT '会员到期提醒天数', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统设置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_user_feedback -- ---------------------------- DROP TABLE IF EXISTS `tcm_user_feedback`; CREATE TABLE `tcm_user_feedback` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `app_user_id` bigint UNSIGNED NOT NULL COMMENT '反馈用户ID', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '问题和意见', `contact` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系方式：手机号或邮箱', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, INDEX `idx_user_feedback_app_user_id`(`app_user_id` ASC) USING BTREE, INDEX `idx_user_feedback_created_at`(`created_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户意见反馈表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tcm_user_points_account -- ---------------------------- DROP TABLE IF EXISTS `tcm_user_points_account`; CREATE TABLE `tcm_user_points_account` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `app_user_id` bigint UNSIGNED NOT NULL COMMENT '用户ID', `points_balance` int NOT NULL DEFAULT 0 COMMENT '当前积分余额', `last_settled_config_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '最后一次结算配置ID', `last_cleared_at` datetime NULL DEFAULT NULL COMMENT '最后一次清零时间', `deleted` tinyint(1) NOT NULL DEFAULT 0, `created_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '系统初始化' COMMENT '创建人', `updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE, UNIQUE INDEX `uk_points_account_user`(`app_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9212 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户积分账户表' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;