/*
|
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;
|
