/*
 Navicat Premium Data Transfer

 Source Server         : wanpai
 Source Server Type    : MySQL
 Source Server Version : 50742
 Source Host           : 8.137.22.229:3306
 Source Schema         : playpai_course

 Target Server Type    : MySQL
 Target Server Version : 50742
 File Encoding         : 65001

 Date: 22/09/2025 17:50:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_back_money
-- ----------------------------
DROP TABLE IF EXISTS `t_back_money`;
CREATE TABLE `t_back_money`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'paymentIds',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `status` int(11) NULL DEFAULT NULL COMMENT '0待审核1同意2拒绝',
  `insertTime` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '退款' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_back_money
-- ----------------------------

-- ----------------------------
-- Table structure for t_cancelled_classes
-- ----------------------------
DROP TABLE IF EXISTS `t_cancelled_classes`;
CREATE TABLE `t_cancelled_classes`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` int(1) NULL DEFAULT NULL COMMENT '消课类型（1=上课消课，2=支付消课）',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `coursePackagePaymentId` bigint(20) NULL DEFAULT NULL COMMENT '课程支付记录id',
  `coursePackageSchedulingId` bigint(20) NULL DEFAULT NULL COMMENT '排课记录id',
  `voucher` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '消课凭证',
  `cancelledClassesNumber` int(11) NULL DEFAULT NULL COMMENT '消课数量',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 194 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课包消课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_cancelled_classes
-- ----------------------------

-- ----------------------------
-- Table structure for t_course
-- ----------------------------
DROP TABLE IF EXISTS `t_course`;
CREATE TABLE `t_course`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '课程名称',
  `type` int(1) NULL DEFAULT NULL COMMENT '类型（1=课后练习，2=运动教学视频，3=器材教学视频）',
  `introduce` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '介绍',
  `coverDrawing` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '封面图',
  `introductionDrawing` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '介绍图',
  `courseVideo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '课程视频',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 70 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '视频课课程' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course
-- ----------------------------
INSERT INTO `t_course` VALUES (27, 'U6年龄段第1课', 2, '', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/38c0eff8a8d2433a910955760bcb7dd0.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/a3308650732349c898359a4b2a14bf37.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/dff98a07cc5c4025a7d058221139ad83.mp4', 1, '2023-10-31 09:32:12');
INSERT INTO `t_course` VALUES (28, 'U6年龄段第2课', 2, '', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/0c4422243f844a33a7c972fc705b31fc.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/5acce7b4d5c5487eb57a1bfbd8b0b89c.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/eb95e41465b64a76ae98aec138e91ff2.mp4', 1, '2023-10-31 11:09:16');
INSERT INTO `t_course` VALUES (29, 'U6年龄段第3课', 2, '', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/e1199285297543448f4dd8b2b60316c6.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/25d49e1cfcfd4b199bd425498a452328.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/9fa6c6f412a645209c26918c66711f36.mp4', 1, '2023-10-31 11:13:24');
INSERT INTO `t_course` VALUES (30, 'U6年龄段第4课', 2, '', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/e99470edf9e44500ab02acb264646f76.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/d3d39748f0214ff8bca3cbb2cd3d1b34.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/ad1a285a30cf4e04a421ee296757e514.mp4', 1, '2023-10-31 11:15:34');
INSERT INTO `t_course` VALUES (31, 'U6年龄段第5课', 2, '', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/6dfba5c528f142b0b0dc7b9b70de37a6.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/31a17fba9877496cb22789c3159cef40.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/a4debeea43674f409a95010500b9d422.mp4', 1, '2023-10-31 11:18:49');
INSERT INTO `t_course` VALUES (32, '利用老年康体区域进行相关运动', 3, '', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/777e507e84d242898e84104efb258fba.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/180a4b863f964c859d1b62bd1a5b436f.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/a70f4a319e664b89b17f8d2eb446ea92.mp4', 2, '2023-10-31 11:55:50');
INSERT INTO `t_course` VALUES (33, '什么是玩湃四门智慧球场', 3, '', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/a6d6919031d240efb185bf51b3db0a7d.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/d911b54f64c34bd99dc0806e430cbdcf.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/92f9c6b8eea54f8888a0406a07487df2.mp4', 1, '2023-10-31 13:03:05');
INSERT INTO `t_course` VALUES (34, '课后练习', 1, '练习练习练习练习练习练习练习练习练习练习练习', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/3c05559a0f1f42139a0467d9e940505d.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/748d930fb63545cb94b04916c80b2873.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/a0e8f36db5824ca1aef7e3ad85ece896.mp4', 2, '2023-11-21 15:04:31');
INSERT INTO `t_course` VALUES (35, '课后练习1', 1, '课后课后课后课后课后课后课后课后', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/26527ae216114cc2acb41c1208445413.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/a7c3e72bd46147e697ac86ec236ba7cd.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/bd03a5cadd4947cc983dc2b2fb25422f.mp4', 2, '2023-11-21 15:05:30');
INSERT INTO `t_course` VALUES (36, '基础动作01', 2, '如何进行投掷', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/c7999855688c42edacd55fc7c8260ebb.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/3bc75f57a5044005930466cf4a2af040.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/ea885b2fcac54f40a8f1c18501f05259.mp4', 3, '2024-03-21 14:59:07');
INSERT INTO `t_course` VALUES (37, '基础动作02', 2, '如何接飞环', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/53352c42fe654ace8583efe43d2e96dd.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/3bc75f57a5044005930466cf4a2af040.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/757481f91f5f4bd2aad6c44309d5c87f.mp4', 3, '2024-03-21 15:28:57');
INSERT INTO `t_course` VALUES (38, '进阶动作01', 2, '反手投掷技巧', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/75bcf3f3e4b041e09963077336f4ae1b.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/3bc75f57a5044005930466cf4a2af040.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/dcb679b7b924414898c8e3c1c3e5a782.mp4', 3, '2024-03-21 15:29:48');
INSERT INTO `t_course` VALUES (39, '进阶动作02', 2, '从头顶投掷飞环', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/7601ee137116427cba8e6007a11c9dd2.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/3bc75f57a5044005930466cf4a2af040.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/ebbfe05ce3664e548e8d8c6d7dd0efd4.mp4', 3, '2024-03-21 15:30:24');
INSERT INTO `t_course` VALUES (40, '进阶动作03', 2, '从地面投掷飞环', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/33af136262774bb195ea2a7ff6865f91.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/3bc75f57a5044005930466cf4a2af040.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/cd32b12037f74c30aeb7cf23f46e761c.mp4', 3, '2024-03-21 15:31:38');
INSERT INTO `t_course` VALUES (41, '玩法介绍01', 2, '静态正手投掷', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/a7448e2fbce34e68a767209acdaea4ea.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/f376767d526045fa8dd90960da1d3f4f.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/5ef5290e43f140acba384c0ff6dba2aa.mp4', 3, '2024-03-21 18:14:17');
INSERT INTO `t_course` VALUES (42, '玩法介绍02', 2, '静态投掷及跑动', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/c202b3befcaa4e44bc30fe18ede1dae4.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/71039740e9b94576b4462329ccbff7fd.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/e36f45e15dd34643aded645e1c4b447e.mp4', 3, '2024-03-21 18:56:11');
INSERT INTO `t_course` VALUES (43, '玩法介绍03', 2, '高分系列赛', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/a7f7c06279124139bcefb9bec092cdf2.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/2db0e89128d4448f9413319955752c29.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/1887d6858fe84b18acfe4b17db7b3a28.mp4', 3, '2024-04-03 09:28:30');
INSERT INTO `t_course` VALUES (44, '玩法介绍04', 2, '接力拾取飞环', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/232487ee9a3647af9fd7005a712338c9.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/2dc57fc5ad414b6bb0211a67275aa524.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/71a6808f99824f9f9877cad10164bbd0.mp4', 3, '2024-04-03 09:30:53');
INSERT INTO `t_course` VALUES (45, '玩法介绍05', 2, '三连珠游戏', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/e3be28e5cfa947b989838718f6e34825.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/0f29281e659349f5b624d3c31db6c89f.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/0c900bb4dffb4671b8b68760e894a1da.mp4', 3, '2024-04-03 09:32:00');
INSERT INTO `t_course` VALUES (46, '玩法介绍06', 2, '系列挑战模式', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/d21a48ca39f64310bac9266c5a7b688c.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/19c3632e0a9a4b8696825ce5b40e309f.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/b68d19b6f17f4db6ac350eb8dd3e78d4.mp4', 3, '2024-04-03 09:34:07');
INSERT INTO `t_course` VALUES (47, '玩法介绍07 ', 1, '区域对区域游戏', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/fd48e3145b914fd59ab97e0713beb106.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/772bd8fb096647babf4095fe1d036bda.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/902953234548454c8c758f3deadbb872.mp4', 3, '2024-04-03 09:37:35');
INSERT INTO `t_course` VALUES (48, '玩法介绍08', 2, '“混乱”游戏', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/f4585ef4794c434694cacf725ce809a4.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/6caacb794a5143e69ff928ca69d08198.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/c3a30582d1014588b031d65af8ea29da.mp4', 3, '2024-04-03 09:38:36');
INSERT INTO `t_course` VALUES (49, '玩法介绍09', 2, '双环挑战赛', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/dfa36163988f42d9b3fb355d1416c7a4.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/cf3a68f222004655a195374e746f1806.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/3f847bce85da4ac2af43021bc4517a46.mp4', 3, '2024-04-03 09:39:42');
INSERT INTO `t_course` VALUES (50, '玩法介绍10', 2, '“猴子”游戏', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/22d893e5916b47fba79cb0290ad5269e.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/7ed57c980f3c496095c098fe36fe117e.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/21169343ebbb4ac2bc4dd27038444730.mp4', 3, '2024-04-03 09:40:21');
INSERT INTO `t_course` VALUES (51, '玩法介绍11', 2, '团队模式（YOU.FO世界杯）', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/fb3dbd18f8fb476fb863b588876ec282.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/1da3d6e8775a4e7c9fa2a6bbda71f8ab.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/faf6981474b74dd98c359617ade46329.mp4', 3, '2024-04-03 09:43:22');
INSERT INTO `t_course` VALUES (52, '玩法介绍07', 2, '区域对区域游戏', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/2ef73823559e43bb827ff425df59a3e8.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/5c3709a9c9574033b5848aa39c053820.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/67dcc4391bfa4aa1a26b2554997f71d7.mp4', 3, '2024-04-08 15:01:10');
INSERT INTO `t_course` VALUES (53, '第16课', 2, '游戏模式 | “猴子”游戏', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/c8c6738e87b8472fb857f689d3cf1d44.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/b1c4b48ca2224b94af331d2442b52270.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/f2eeb874585b4ce3a9a3e2162f513fa4.mp4', 1, '2024-05-11 11:14:56');
INSERT INTO `t_course` VALUES (54, '第15课', 2, '游戏模式 | 双环挑战游戏', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/e81cde9869864fa8b0503946a59d2a8c.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/cb8ed896449648ad92be6e573584cdb8.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/e4b069f2de964fd7b5dc7eb0c8a96e3a.mp4', 1, '2024-05-11 11:18:16');
INSERT INTO `t_course` VALUES (55, '第14课', 2, '游戏模式 | “混乱”游戏', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/b09be1be05094eb597803ac974010d1e.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/8dbe4762ea6c470ea84b826a85811df5.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/857929fe2aa54e22a3123f54166f9fa3.mp4', 1, '2024-05-11 11:20:03');
INSERT INTO `t_course` VALUES (56, '第13课', 2, '游戏模式 | 区域对区域游戏', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/e729147b3d9742608f0c07256fff2794.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/e2bb9f5b908d4a7cb9e336d05bec1fde.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/7c8b7dc77e9b483aaf57de0896b22ac3.mp4', 1, '2024-05-11 11:21:21');
INSERT INTO `t_course` VALUES (57, '第12课', 2, '游戏模式 | 系列挑战游戏', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/0e279d682a1b4393808093257b216f2d.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/3b13462e9be540a6aa126bd08dc54e7e.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/41dc5a4ea4cd416babfd3dfee1a30682.mp4', 1, '2024-05-11 11:22:36');
INSERT INTO `t_course` VALUES (58, '第11课', 2, '游戏模式 | 三连珠游戏', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/e05e67b67d9841b8944c064a255ffafc.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/1ffc303ed7d9482ab2d4efc94d851131.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/7b029e765275458c821beb84d4552f3e.mp4', 1, '2024-05-11 11:24:15');
INSERT INTO `t_course` VALUES (59, '第10课', 2, '游戏模式 | 接力拾取飞环', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/68189d8034c24845b4269c7d870233da.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/b4303648682d443eb3b288472d56320e.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/dc3e602752b0482e969b1195bc188f6c.mp4', 1, '2024-05-11 11:25:53');
INSERT INTO `t_course` VALUES (60, '第9课', 2, '游戏模式 | 高分系列赛', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/2e55c5393ae546fa8bd955f030634090.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/4be20ff19280481fbc2beecbe2ea78ee.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/dcab792fb92c4fcf97106eed1d41de57.mp4', 1, '2024-05-11 11:27:44');
INSERT INTO `t_course` VALUES (61, '第8课', 2, '练习方法 | 静态投掷及跑动', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/d466f123697a48ac9c3c2a06d928c230.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/b183ae11827e45f9a5d6f2340968ee4f.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/c191630d86944d02846ab8332f27b983.mp4', 1, '2024-05-11 11:28:31');
INSERT INTO `t_course` VALUES (62, '第7课', 2, '练习方法 | 静态正手投掷', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/5bd3f7c2bdbe482390e0f2a0090b2fb8.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/cfae04ec6a37421282d6bcd6ee9b4a02.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/d691f9e46d4a45249553777ed0592660.mp4', 1, '2024-05-11 11:29:25');
INSERT INTO `t_course` VALUES (63, '第6课', 2, '进阶动作 | 从地面投掷飞环', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/07ab4fcfb32542a6aa8c056f0702ad19.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/6d62151ad77d455483468c26bd102984.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/ea3f51ecfc1b462986e027091db8a93a.mp4', 1, '2024-05-11 11:30:09');
INSERT INTO `t_course` VALUES (64, '第5课', 2, '进阶动作 | 从头顶投掷飞环', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/5715af3c2aba4170ba85f806fba786a6.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/0153ef2db780402e9454015f9896202a.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/2302b03924194cebbcab9f17d0493b68.mp4', 1, '2024-05-11 11:31:00');
INSERT INTO `t_course` VALUES (65, '第4课', 2, '进阶动作 | 反手投掷技巧', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/c76fb880bd8448a2a8e53b4f856cf1d0.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/0233aab708a14dbf89627bec18545352.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/d4714ef47059450dbe967518f5cfb3ba.mp4', 1, '2024-05-11 11:32:14');
INSERT INTO `t_course` VALUES (66, '第3课', 2, '基础动作 | 如何接飞环', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/bdd116177dc3465eb846c594c88fe32f.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/38f47612c5534fb88a7f00dc89510695.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/ce44d40306004ff5b0535aa2da9e1a63.mp4', 1, '2024-05-11 11:32:52');
INSERT INTO `t_course` VALUES (67, '第2课', 2, '基础动作 | 如何投掷飞环', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/039dc675b21b410a854370a7ff16160e.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/02d700559aa74f25be39be4b15f094b8.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/252a1fd3dd224170bdeb98f3f59d01e7.mp4', 1, '2024-05-11 11:33:30');
INSERT INTO `t_course` VALUES (68, '第1课', 2, 'YOU.FO运动入门规则', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/383edf49536d4a87bf62cb67225ffef7.jpg', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/69b2146b9eff4cc8ad82878d5e38b0f4.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/cdcf726308db4133a64c070c15d11aa2.mp4', 1, '2024-05-11 11:35:05');
INSERT INTO `t_course` VALUES (69, '1231', 1, '123', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/729ace3ec0434d4aa0570d76bf7a2a2f.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/img/f0ee1f8bce53433fa5bfd616c88f4bf0.png', 'https://we-park-life.oss-cn-beijing.aliyuncs.com/video/912216b0e71b484bab7800b8125448b2.txt', 3, '2025-09-17 13:53:50');

-- ----------------------------
-- Table structure for t_course_consum
-- ----------------------------
DROP TABLE IF EXISTS `t_course_consum`;
CREATE TABLE `t_course_consum`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `changeType` int(11) NULL DEFAULT NULL COMMENT '0减少1增加',
  `num` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '变更原因',
  `paymentId` bigint(20) NULL DEFAULT NULL COMMENT 'payId',
  `insertTime` datetime(0) NULL DEFAULT NULL,
  `appUserId` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1192 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课时变化记录表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_consum
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package`;
CREATE TABLE `t_course_package`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省',
  `provinceCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省编号',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市',
  `cityCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
  `storeId` int(11) NULL DEFAULT NULL COMMENT '门店id',
  `coursePackageTypeId` int(11) NULL DEFAULT NULL COMMENT '课包类型id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '课包名称',
  `siteId` int(11) NULL DEFAULT NULL COMMENT '上课场地id',
  `coachId` int(11) NULL DEFAULT NULL COMMENT '教练id',
  `maxSubscribeNumber` int(11) NULL DEFAULT NULL COMMENT '最多预约人数',
  `classStartTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '上课开始时间',
  `classEndTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '上课结束时段',
  `classWeeks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '上课周，多个分号分隔',
  `coverDrawing` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '封面图',
  `detailDrawing` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详情图',
  `introduceDrawing` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '介绍图',
  `sort` int(1) NULL DEFAULT NULL COMMENT '排序',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=现金，2=玩湃币）',
  `validDays` int(11) NULL DEFAULT NULL COMMENT '有效天数',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=未开始，2=进行中，3=已结束，4=已暂停 ）',
  `auditStatus` int(1) NULL DEFAULT NULL COMMENT '审核状态（1=待审核，2=已同意，3=已拒绝）',
  `auditUserId` int(11) NULL DEFAULT NULL COMMENT '审核人id',
  `authRemark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核备注',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `type` int(255) NULL DEFAULT NULL COMMENT '1常规 2假期 3体验',
  `needNum` int(11) NULL DEFAULT 1 COMMENT '每节课需要支付的课时数',
  `startTime` datetime(0) NULL DEFAULT NULL COMMENT '假期 有效期',
  `endTime` datetime(0) NULL DEFAULT NULL COMMENT '假期 有效期',
  `codeTIme` int(11) NULL DEFAULT 1 COMMENT '扣除课时数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 149 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课包' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_discount
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_discount`;
CREATE TABLE `t_course_package_discount`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `coursePackagePaymentConfigId` int(11) NULL DEFAULT NULL COMMENT '课包价格规则id',
  `type` int(1) NULL DEFAULT NULL COMMENT '折扣类型（1=会员折扣，2=续课优惠，3=限时折扣，4=赠送课时）',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '折扣优惠规则JSON',
  `auditStatus` int(1) NULL DEFAULT NULL COMMENT '审核状态（1=待审核，2=已通过，3=已拒绝）',
  `auditUserId` int(11) NULL DEFAULT NULL COMMENT '审核人id',
  `auditRemark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核备注',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `status` int(11) NULL DEFAULT 2 COMMENT '1上架 2下架',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 200 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课包折扣' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_discount
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_order
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_order`;
CREATE TABLE `t_course_package_order`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '业务编号',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentIds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '学员ids',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝，3=玩湃币,4=积分，5=积分+微信，6=积分+支付宝,7=手动支付）\n',
  `classHours` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `originalPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价',
  `userCouponId` bigint(20) NULL DEFAULT NULL COMMENT '优惠券id',
  `cashPayment` decimal(10, 2) NULL DEFAULT NULL COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT NULL COMMENT '玩湃币价格/积分',
  `payUserType` int(1) NULL DEFAULT NULL COMMENT '支付用户类型（1=用户，2=管理员）',
  `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已支付）',
  `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
  `payUserId` int(11) NULL DEFAULT NULL COMMENT '支付用户id',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课，3=已换课）',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `payUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '平台手动支付时使用\r\n平台手动支付时使用',
  `salesName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '销售人员(线下购课添加购课订单时使用)',
  `orderType` int(1) NULL DEFAULT NULL COMMENT '订单类型（1=购买订单，2=积分商品兑换订单）',
  `fenzhangNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '分账流水号',
  `fenzhangOrderNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '分账业务号  存值表明已分账 未存表明未分账',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户课程包购买记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_order
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_order1
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_order1`;
CREATE TABLE `t_course_package_order1`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '业务编号',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentIds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '学员ids',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝，3=玩湃币,4=积分，5=积分+微信，6=积分+支付宝）\n',
  `classHours` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `originalPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价',
  `userCouponId` bigint(20) NULL DEFAULT NULL COMMENT '优惠券id',
  `cashPayment` decimal(10, 2) NULL DEFAULT NULL COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT NULL COMMENT '玩湃币价格/积分',
  `payUserType` int(1) NULL DEFAULT NULL COMMENT '支付用户类型（1=用户，2=管理员）',
  `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已支付）',
  `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
  `payUserId` int(11) NULL DEFAULT NULL COMMENT '支付用户id',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课，3=已换课）',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `payUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '平台手动支付时使用\r\n平台手动支付时使用',
  `salesName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '销售人员(线下购课添加购课订单时使用)',
  `orderType` int(1) NULL DEFAULT NULL COMMENT '订单类型（1=购买订单，2=积分商品兑换订单）',
  `fenzhangNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '分账流水号',
  `fenzhangOrderNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '分账业务号  存值表明已分账 未存表明未分账',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户课程包购买记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_order1
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_order2
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_order2`;
CREATE TABLE `t_course_package_order2`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '业务编号',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentIds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '学员ids',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝，3=玩湃币,4=积分，5=积分+微信，6=积分+支付宝）\n',
  `classHours` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `originalPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价',
  `userCouponId` bigint(20) NULL DEFAULT NULL COMMENT '优惠券id',
  `cashPayment` decimal(10, 2) NULL DEFAULT NULL COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT NULL COMMENT '玩湃币价格/积分',
  `payUserType` int(1) NULL DEFAULT NULL COMMENT '支付用户类型（1=用户，2=管理员）',
  `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已支付）',
  `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
  `payUserId` int(11) NULL DEFAULT NULL COMMENT '支付用户id',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课，3=已换课）',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `payUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '平台手动支付时使用\r\n平台手动支付时使用',
  `salesName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '销售人员(线下购课添加购课订单时使用)',
  `orderType` int(1) NULL DEFAULT NULL COMMENT '订单类型（1=购买订单，2=积分商品兑换订单）',
  `fenzhangNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '分账流水号',
  `fenzhangOrderNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '分账业务号  存值表明已分账 未存表明未分账',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户课程包购买记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_order2
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_order3
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_order3`;
CREATE TABLE `t_course_package_order3`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '业务编号',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentIds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '学员ids',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝，3=玩湃币,4=积分，5=积分+微信，6=积分+支付宝）\n',
  `classHours` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `originalPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价',
  `userCouponId` bigint(20) NULL DEFAULT NULL COMMENT '优惠券id',
  `cashPayment` decimal(10, 2) NULL DEFAULT NULL COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT NULL COMMENT '玩湃币价格/积分',
  `payUserType` int(1) NULL DEFAULT NULL COMMENT '支付用户类型（1=用户，2=管理员）',
  `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已支付）',
  `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
  `payUserId` int(11) NULL DEFAULT NULL COMMENT '支付用户id',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课，3=已换课）',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `payUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '平台手动支付时使用\r\n平台手动支付时使用',
  `salesName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '销售人员(线下购课添加购课订单时使用)',
  `orderType` int(1) NULL DEFAULT NULL COMMENT '订单类型（1=购买订单，2=积分商品兑换订单）',
  `fenzhangNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `fenzhangOrderNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户课程包购买记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_order3
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_order4
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_order4`;
CREATE TABLE `t_course_package_order4`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '业务编号',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentIds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '学员ids',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝，3=玩湃币,4=积分，5=积分+微信，6=积分+支付宝）\n',
  `classHours` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `originalPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价',
  `userCouponId` bigint(20) NULL DEFAULT NULL COMMENT '优惠券id',
  `cashPayment` decimal(10, 2) NULL DEFAULT NULL COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT NULL COMMENT '玩湃币价格/积分',
  `payUserType` int(1) NULL DEFAULT NULL COMMENT '支付用户类型（1=用户，2=管理员）',
  `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已支付）',
  `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
  `payUserId` int(11) NULL DEFAULT NULL COMMENT '支付用户id',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课，3=已换课）',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `payUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '平台手动支付时使用\r\n平台手动支付时使用',
  `salesName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '销售人员(线下购课添加购课订单时使用)',
  `orderType` int(1) NULL DEFAULT NULL COMMENT '订单类型（1=购买订单，2=积分商品兑换订单）',
  `fenzhangNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `fenzhangOrderNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户课程包购买记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_order4
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_order5
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_order5`;
CREATE TABLE `t_course_package_order5`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '业务编号',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentIds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '学员ids',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝，3=玩湃币,4=积分，5=积分+微信，6=积分+支付宝）\n',
  `classHours` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `originalPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价',
  `userCouponId` bigint(20) NULL DEFAULT NULL COMMENT '优惠券id',
  `cashPayment` decimal(10, 2) NULL DEFAULT NULL COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT NULL COMMENT '玩湃币价格/积分',
  `payUserType` int(1) NULL DEFAULT NULL COMMENT '支付用户类型（1=用户，2=管理员）',
  `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已支付）',
  `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
  `payUserId` int(11) NULL DEFAULT NULL COMMENT '支付用户id',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课，3=已换课）',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `payUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '平台手动支付时使用\r\n平台手动支付时使用',
  `salesName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '销售人员(线下购课添加购课订单时使用)',
  `orderType` int(1) NULL DEFAULT NULL COMMENT '订单类型（1=购买订单，2=积分商品兑换订单）',
  `fenzhangNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `fenzhangOrderNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户课程包购买记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_order5
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_order_student
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_order_student`;
CREATE TABLE `t_course_package_order_student`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `totalClassHours` int(11) NULL DEFAULT 0 COMMENT '总课时',
  `laveClassHours` int(11) NULL DEFAULT 0 COMMENT '剩余课时',
  `absencesNumber` int(11) NULL DEFAULT 0 COMMENT '缺课次数',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课3=换课中，4申请退费中，5=已转移6=已赠课）',
  `withdrawalTime` datetime(0) NULL DEFAULT NULL COMMENT '退课时间',
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '退课凭证',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `giftClassHours` int(11) NULL DEFAULT NULL COMMENT '赠送课时数',
  `useTime` datetime(0) NULL DEFAULT NULL COMMENT '课程有效期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 129 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户-学员课程包购买记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_order_student
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_payment
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_payment`;
CREATE TABLE `t_course_package_payment`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '业务编号',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝，3=玩湃币,4=积分，5=积分+微信，6=积分+支付宝）,\n7=手动支付',
  `classHours` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `originalPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价',
  `userCouponId` bigint(20) NULL DEFAULT NULL COMMENT '优惠券id',
  `cashPayment` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT 0 COMMENT '玩湃币价格/积分',
  `totalClassHours` int(11) NULL DEFAULT 0 COMMENT '总课时',
  `laveClassHours` int(11) NULL DEFAULT 0 COMMENT '剩余课时',
  `absencesNumber` int(11) NULL DEFAULT 0 COMMENT '缺课次数',
  `payUserType` int(1) NULL DEFAULT NULL COMMENT '支付用户类型（1=用户，2=管理员）',
  `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已支付）',
  `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
  `payUserId` int(11) NULL DEFAULT NULL COMMENT '支付用户id',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课3=换课中，4申请退费中，5=已转移6=已赠课）',
  `withdrawalTime` datetime(0) NULL DEFAULT NULL COMMENT '退课时间',
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '退课凭证',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `giftClassHours` int(11) NULL DEFAULT NULL COMMENT '赠送课时数',
  `useTime` datetime(0) NULL DEFAULT NULL COMMENT '课程有效期',
  `payUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '平台手动支付时使用',
  `salesName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '销售人员(线下购课添加购课订单时使用)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户课程包购买记录----逐步弃用' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_payment
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_payment1
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_payment1`;
CREATE TABLE `t_course_package_payment1`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '业务编号',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝，3=玩湃币,4=积分，5=积分+微信，6=积分+支付宝）\n',
  `classHours` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `originalPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价',
  `userCouponId` bigint(20) NULL DEFAULT NULL COMMENT '优惠券id',
  `cashPayment` decimal(10, 2) NULL DEFAULT NULL COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT NULL COMMENT '玩湃币价格/积分',
  `totalClassHours` int(11) NULL DEFAULT NULL COMMENT '总课时',
  `laveClassHours` int(11) NULL DEFAULT NULL COMMENT '剩余课时',
  `absencesNumber` int(11) NULL DEFAULT NULL COMMENT '缺课次数',
  `payUserType` int(1) NULL DEFAULT NULL COMMENT '支付用户类型（1=用户，2=管理员）',
  `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已支付）',
  `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
  `payUserId` int(11) NULL DEFAULT NULL COMMENT '支付用户id',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课，3=已换课）',
  `withdrawalTime` datetime(0) NULL DEFAULT NULL COMMENT '退课时间',
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '退课凭证',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `giftClassHours` int(11) NULL DEFAULT NULL COMMENT '赠送课时',
  `useTime` datetime(0) NULL DEFAULT NULL COMMENT '课程有效期',
  `payUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '平台手动支付时使用\r\n平台手动支付时使用',
  `salesName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '销售人员(线下购课添加购课订单时使用)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户课程包购买记录----逐步弃用' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_payment1
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_payment2
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_payment2`;
CREATE TABLE `t_course_package_payment2`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '业务编号',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝，3=玩湃币,4=积分，5=积分+微信，6=积分+支付宝）\n',
  `classHours` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `originalPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价',
  `userCouponId` bigint(20) NULL DEFAULT NULL COMMENT '优惠券id',
  `cashPayment` decimal(10, 2) NULL DEFAULT NULL COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT NULL COMMENT '玩湃币价格/积分',
  `totalClassHours` int(11) NULL DEFAULT NULL COMMENT '总课时',
  `laveClassHours` int(11) NULL DEFAULT NULL COMMENT '剩余课时',
  `absencesNumber` int(11) NULL DEFAULT NULL COMMENT '缺课次数',
  `payUserType` int(1) NULL DEFAULT NULL COMMENT '支付用户类型（1=用户，2=管理员）',
  `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已支付）',
  `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
  `payUserId` int(11) NULL DEFAULT NULL COMMENT '支付用户id',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课）',
  `withdrawalTime` datetime(0) NULL DEFAULT NULL COMMENT '退课时间',
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '退课凭证',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `giftClassHours` int(11) NULL DEFAULT NULL COMMENT '赠送课时',
  `useTime` datetime(0) NULL DEFAULT NULL COMMENT '课程有效期',
  `payUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '平台手动支付时使用',
  `salesName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '销售人员(线下购课添加购课订单时使用)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户课程包购买记录----逐步弃用' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_payment2
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_payment3
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_payment3`;
CREATE TABLE `t_course_package_payment3`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '业务编号',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝，3=玩湃币,4=积分，5=积分+微信，6=积分+支付宝）\n',
  `classHours` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `originalPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价',
  `userCouponId` bigint(20) NULL DEFAULT NULL COMMENT '优惠券id',
  `cashPayment` decimal(10, 2) NULL DEFAULT NULL COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT NULL COMMENT '玩湃币价格/积分',
  `totalClassHours` int(11) NULL DEFAULT NULL COMMENT '总课时',
  `laveClassHours` int(11) NULL DEFAULT NULL COMMENT '剩余课时',
  `absencesNumber` int(11) NULL DEFAULT NULL COMMENT '缺课次数',
  `payUserType` int(1) NULL DEFAULT NULL COMMENT '支付用户类型（1=用户，2=管理员）',
  `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已支付）',
  `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
  `payUserId` int(11) NULL DEFAULT NULL COMMENT '支付用户id',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课）',
  `withdrawalTime` datetime(0) NULL DEFAULT NULL COMMENT '退课时间',
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '退课凭证',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `giftClassHours` int(11) NULL DEFAULT NULL COMMENT '赠送课时',
  `useTime` datetime(0) NULL DEFAULT NULL COMMENT '有效期',
  `payUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '平台手动支付使用',
  `salesName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '销售人员(线下购课添加购课订单时使用)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户课程包购买记录----逐步弃用' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_payment3
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_payment4
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_payment4`;
CREATE TABLE `t_course_package_payment4`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '业务编号',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝，3=玩湃币,4=积分，5=积分+微信，6=积分+支付宝）\n',
  `classHours` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `originalPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价',
  `userCouponId` bigint(20) NULL DEFAULT NULL COMMENT '优惠券id',
  `cashPayment` decimal(10, 2) NULL DEFAULT NULL COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT NULL COMMENT '玩湃币价格/积分',
  `totalClassHours` int(11) NULL DEFAULT NULL COMMENT '总课时',
  `laveClassHours` int(11) NULL DEFAULT NULL COMMENT '剩余课时',
  `absencesNumber` int(11) NULL DEFAULT NULL COMMENT '缺课次数',
  `payUserType` int(1) NULL DEFAULT NULL COMMENT '支付用户类型（1=用户，2=管理员）',
  `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已支付）',
  `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
  `payUserId` int(11) NULL DEFAULT NULL COMMENT '支付用户id',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课）',
  `withdrawalTime` datetime(0) NULL DEFAULT NULL COMMENT '退课时间',
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '退课凭证',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `giftClassHours` int(11) NULL DEFAULT NULL COMMENT '赠送课时',
  `useTime` datetime(0) NULL DEFAULT NULL COMMENT '课程有效期',
  `payUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '平台手动支付使用',
  `salesName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '销售人员(线下购课添加购课订单时使用)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户课程包购买记录----逐步弃用' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_payment4
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_payment5
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_payment5`;
CREATE TABLE `t_course_package_payment5`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '业务编号',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝，3=玩湃币,4=积分，5=积分+微信，6=积分+支付宝）\n',
  `classHours` int(11) NULL DEFAULT NULL COMMENT '课时数',
  `originalPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '原价',
  `userCouponId` bigint(20) NULL DEFAULT NULL COMMENT '优惠券id',
  `cashPayment` decimal(10, 2) NULL DEFAULT NULL COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT NULL COMMENT '玩湃币价格/积分',
  `totalClassHours` int(11) NULL DEFAULT NULL COMMENT '总课时',
  `laveClassHours` int(11) NULL DEFAULT NULL COMMENT '剩余课时',
  `absencesNumber` int(11) NULL DEFAULT NULL COMMENT '缺课次数',
  `payUserType` int(1) NULL DEFAULT NULL COMMENT '支付用户类型（1=用户，2=管理员）',
  `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已支付）',
  `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
  `payUserId` int(11) NULL DEFAULT NULL COMMENT '支付用户id',
  `status` int(1) NULL DEFAULT NULL COMMENT '课程状态（1=正常，2=已退课）',
  `withdrawalTime` datetime(0) NULL DEFAULT NULL COMMENT '退课时间',
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '退课凭证',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `giftClassHours` int(11) NULL DEFAULT NULL COMMENT '赠送课时',
  `useTime` datetime(0) NULL DEFAULT NULL COMMENT '课程有效期',
  `payUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '平台手动支付使用',
  `salesName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '销售人员(线下购课添加购课订单时使用)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户课程包购买记录----逐步弃用' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_payment5
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_payment_config
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_payment_config`;
CREATE TABLE `t_course_package_payment_config`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `classHours` int(11) NULL DEFAULT 0 COMMENT '课时数',
  `cashPayment` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '现金支付价格',
  `playPaiCoin` int(11) NULL DEFAULT 0 COMMENT '玩湃币价格',
  `couponIds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '优惠券ids',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 675 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课包支付配置' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_payment_config
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_scheduling
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_scheduling`;
CREATE TABLE `t_course_package_scheduling`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `type` int(1) NULL DEFAULT NULL COMMENT '1=常规，2=假期，3=体验购课',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `classDate` datetime(0) NULL DEFAULT NULL COMMENT '上课日期',
  `endDate` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后练习课程id',
  `integral` int(11) NULL DEFAULT NULL COMMENT '可获得积分',
  `cancelClasses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '消课凭证（多个分号分隔）',
  `deductClassHour` int(11) NULL DEFAULT NULL COMMENT '扣除课时',
  `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=未开始，2=已开始，3=已结束，4=已取消）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课包排课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_scheduling
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_scheduling1
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_scheduling1`;
CREATE TABLE `t_course_package_scheduling1`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `type` int(1) NULL DEFAULT NULL COMMENT '1=常规，2=假期，3=体验购课',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `classDate` datetime(0) NULL DEFAULT NULL COMMENT '上课日期',
  `endDate` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后练习课程id',
  `integral` int(11) NULL DEFAULT NULL COMMENT '可获得积分',
  `cancelClasses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '消课凭证（多个分号分隔）',
  `deductClassHour` int(11) NULL DEFAULT NULL COMMENT '扣除课时',
  `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=未开始，2=已开始，3=已结束，4=已取消）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课包排课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_scheduling1
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_scheduling2
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_scheduling2`;
CREATE TABLE `t_course_package_scheduling2`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `type` int(1) NULL DEFAULT NULL COMMENT '1=常规，2=假期，3=体验购课',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `classDate` datetime(0) NULL DEFAULT NULL COMMENT '上课日期',
  `endDate` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后练习课程id',
  `integral` int(11) NULL DEFAULT NULL COMMENT '可获得积分',
  `cancelClasses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '消课凭证（多个分号分隔）',
  `deductClassHour` int(11) NULL DEFAULT NULL COMMENT '扣除课时',
  `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=未开始，2=已开始，3=已结束，4=已取消）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课包排课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_scheduling2
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_scheduling3
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_scheduling3`;
CREATE TABLE `t_course_package_scheduling3`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `type` int(1) NULL DEFAULT NULL COMMENT '1=常规，2=假期，3=体验购课',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `classDate` datetime(0) NULL DEFAULT NULL COMMENT '上课日期',
  `endDate` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后练习课程id',
  `integral` int(11) NULL DEFAULT NULL COMMENT '可获得积分',
  `cancelClasses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '消课凭证（多个分号分隔）',
  `deductClassHour` int(11) NULL DEFAULT NULL COMMENT '扣除课时',
  `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=未开始，2=已开始，3=已结束，4=已取消）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课包排课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_scheduling3
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_scheduling4
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_scheduling4`;
CREATE TABLE `t_course_package_scheduling4`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `type` int(1) NULL DEFAULT NULL COMMENT '1=常规，2=假期，3=体验购课',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `classDate` datetime(0) NULL DEFAULT NULL COMMENT '上课日期',
  `endDate` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后练习课程id',
  `integral` int(11) NULL DEFAULT NULL COMMENT '可获得积分',
  `cancelClasses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '消课凭证（多个分号分隔）',
  `deductClassHour` int(11) NULL DEFAULT NULL COMMENT '扣除课时',
  `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=未开始，2=已开始，3=已结束，4=已取消）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课包排课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_scheduling4
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_scheduling5
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_scheduling5`;
CREATE TABLE `t_course_package_scheduling5`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `type` int(1) NULL DEFAULT NULL COMMENT '1=常规，2=假期，3=体验购课',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `classDate` datetime(0) NULL DEFAULT NULL COMMENT '上课日期',
  `endDate` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后练习课程id',
  `integral` int(11) NULL DEFAULT NULL COMMENT '可获得积分',
  `cancelClasses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '消课凭证（多个分号分隔）',
  `deductClassHour` int(11) NULL DEFAULT NULL COMMENT '扣除课时',
  `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=未开始，2=已开始，3=已结束，4=已取消）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课包排课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_scheduling5
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_student
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_student`;
CREATE TABLE `t_course_package_student`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `coursePackagePaymentId` bigint(20) NULL DEFAULT NULL COMMENT '课包购买记录id',
  `coursePackageSchedulingId` bigint(20) NULL DEFAULT NULL COMMENT '排课记录id',
  `signInOrNot` int(1) NULL DEFAULT NULL COMMENT '到课状态（0=否，1=是，2=已请假）',
  `reservationStatus` int(1) NULL DEFAULT NULL COMMENT '预约状态（0=取消，1=预约,2=退款）',
  `insertTime` datetime(0) NULL DEFAULT NULL,
  `type` int(11) NULL DEFAULT 0 COMMENT '1不能请假',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '学员上课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_student
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_student1
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_student1`;
CREATE TABLE `t_course_package_student1`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `coursePackagePaymentId` bigint(20) NULL DEFAULT NULL COMMENT '课包购买记录id',
  `coursePackageSchedulingId` bigint(20) NULL DEFAULT NULL COMMENT '排课记录id',
  `signInOrNot` int(1) NULL DEFAULT NULL COMMENT '到课状态（0=否，1=是）',
  `reservationStatus` int(1) NULL DEFAULT NULL COMMENT '预约状态（0=取消，1=预约）',
  `insertTime` datetime(0) NULL DEFAULT NULL,
  `type` int(1) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '学员上课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_student1
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_student2
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_student2`;
CREATE TABLE `t_course_package_student2`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `coursePackagePaymentId` bigint(20) NULL DEFAULT NULL COMMENT '课包购买记录id',
  `coursePackageSchedulingId` bigint(20) NULL DEFAULT NULL COMMENT '排课记录id',
  `signInOrNot` int(1) NULL DEFAULT NULL COMMENT '到课状态（0=否，1=是）',
  `reservationStatus` int(1) NULL DEFAULT NULL COMMENT '预约状态（0=取消，1=预约）',
  `insertTime` datetime(0) NULL DEFAULT NULL,
  `type` int(1) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '学员上课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_student2
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_student3
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_student3`;
CREATE TABLE `t_course_package_student3`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `coursePackagePaymentId` bigint(20) NULL DEFAULT NULL COMMENT '课包购买记录id',
  `coursePackageSchedulingId` bigint(20) NULL DEFAULT NULL COMMENT '排课记录id',
  `signInOrNot` int(1) NULL DEFAULT NULL COMMENT '到课状态（0=否，1=是）',
  `reservationStatus` int(1) NULL DEFAULT NULL COMMENT '预约状态（0=取消，1=预约）',
  `insertTime` datetime(0) NULL DEFAULT NULL,
  `type` int(1) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '学员上课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_student3
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_student4
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_student4`;
CREATE TABLE `t_course_package_student4`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `coursePackagePaymentId` bigint(20) NULL DEFAULT NULL COMMENT '课包购买记录id',
  `coursePackageSchedulingId` bigint(20) NULL DEFAULT NULL COMMENT '排课记录id',
  `signInOrNot` int(1) NULL DEFAULT NULL COMMENT '到课状态（0=否，1=是）',
  `reservationStatus` int(1) NULL DEFAULT NULL COMMENT '预约状态（0=取消，1=预约）',
  `insertTime` datetime(0) NULL DEFAULT NULL,
  `type` int(1) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '学员上课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_student4
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_student5
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_student5`;
CREATE TABLE `t_course_package_student5`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `studentId` int(11) NULL DEFAULT NULL COMMENT '学员id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `coursePackagePaymentId` bigint(20) NULL DEFAULT NULL COMMENT '课包购买记录id',
  `coursePackageSchedulingId` bigint(20) NULL DEFAULT NULL COMMENT '排课记录id',
  `signInOrNot` int(1) NULL DEFAULT NULL COMMENT '到课状态（0=否，1=是）',
  `reservationStatus` int(1) NULL DEFAULT NULL COMMENT '预约状态（0=取消，1=预约）',
  `insertTime` datetime(0) NULL DEFAULT NULL,
  `type` int(1) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '学员上课记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_student5
-- ----------------------------

-- ----------------------------
-- Table structure for t_course_package_type
-- ----------------------------
DROP TABLE IF EXISTS `t_course_package_type`;
CREATE TABLE `t_course_package_type`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '类型名称',
  `state` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课程包类型' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_course_package_type
-- ----------------------------
INSERT INTO `t_course_package_type` VALUES (34, '23', 3, '2025-09-17 13:54:14');

-- ----------------------------
-- Table structure for t_order
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `paysId` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `orderNum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `isPay` int(11) NULL DEFAULT NULL,
  `payType` int(11) NULL DEFAULT NULL,
  `appUserId` int(11) NULL DEFAULT NULL,
  `price` decimal(10, 2) NULL DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `studentId` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 86 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '----逐步弃用' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_order
-- ----------------------------

-- ----------------------------
-- Table structure for t_post_course_video
-- ----------------------------
DROP TABLE IF EXISTS `t_post_course_video`;
CREATE TABLE `t_post_course_video`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `courseDate` datetime(0) NULL DEFAULT NULL COMMENT '上课日期',
  `courseWeek` int(11) NULL DEFAULT NULL COMMENT '周几',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后视频id',
  `postDate` datetime(0) NULL DEFAULT NULL COMMENT '发布日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课后视频发布记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_post_course_video
-- ----------------------------

-- ----------------------------
-- Table structure for t_post_course_video1
-- ----------------------------
DROP TABLE IF EXISTS `t_post_course_video1`;
CREATE TABLE `t_post_course_video1`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `courseDate` datetime(0) NULL DEFAULT NULL COMMENT '上课日期',
  `courseWeek` int(11) NULL DEFAULT NULL COMMENT '周几',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后视频id',
  `postDate` datetime(0) NULL DEFAULT NULL COMMENT '发布日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课后视频发布记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_post_course_video1
-- ----------------------------

-- ----------------------------
-- Table structure for t_post_course_video2
-- ----------------------------
DROP TABLE IF EXISTS `t_post_course_video2`;
CREATE TABLE `t_post_course_video2`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `courseDate` datetime(0) NULL DEFAULT NULL COMMENT '上课日期',
  `courseWeek` int(11) NULL DEFAULT NULL COMMENT '周几',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后视频id',
  `postDate` datetime(0) NULL DEFAULT NULL COMMENT '发布日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课后视频发布记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_post_course_video2
-- ----------------------------

-- ----------------------------
-- Table structure for t_post_course_video3
-- ----------------------------
DROP TABLE IF EXISTS `t_post_course_video3`;
CREATE TABLE `t_post_course_video3`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `courseDate` datetime(0) NULL DEFAULT NULL COMMENT '上课日期',
  `courseWeek` int(11) NULL DEFAULT NULL COMMENT '周几',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后视频id',
  `postDate` datetime(0) NULL DEFAULT NULL COMMENT '发布日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课后视频发布记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_post_course_video3
-- ----------------------------

-- ----------------------------
-- Table structure for t_post_course_video4
-- ----------------------------
DROP TABLE IF EXISTS `t_post_course_video4`;
CREATE TABLE `t_post_course_video4`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `courseDate` datetime(0) NULL DEFAULT NULL COMMENT '上课日期',
  `courseWeek` int(11) NULL DEFAULT NULL COMMENT '周几',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后视频id',
  `postDate` datetime(0) NULL DEFAULT NULL COMMENT '发布日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课后视频发布记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_post_course_video4
-- ----------------------------

-- ----------------------------
-- Table structure for t_post_course_video5
-- ----------------------------
DROP TABLE IF EXISTS `t_post_course_video5`;
CREATE TABLE `t_post_course_video5`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `courseDate` datetime(0) NULL DEFAULT NULL COMMENT '上课日期',
  `courseWeek` int(11) NULL DEFAULT NULL COMMENT '周几',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后视频id',
  `postDate` datetime(0) NULL DEFAULT NULL COMMENT '发布日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '课后视频发布记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_post_course_video5
-- ----------------------------

-- ----------------------------
-- Table structure for t_user_video_details
-- ----------------------------
DROP TABLE IF EXISTS `t_user_video_details`;
CREATE TABLE `t_user_video_details`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后视频id',
  `state` int(11) NULL DEFAULT NULL COMMENT '状态(1未学习 2已学习)',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户观看视频记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_user_video_details
-- ----------------------------

-- ----------------------------
-- Table structure for t_user_video_details1
-- ----------------------------
DROP TABLE IF EXISTS `t_user_video_details1`;
CREATE TABLE `t_user_video_details1`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后视频id',
  `state` int(11) NULL DEFAULT NULL COMMENT '状态(1未学习 2已学习)',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户观看视频记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_user_video_details1
-- ----------------------------

-- ----------------------------
-- Table structure for t_user_video_details2
-- ----------------------------
DROP TABLE IF EXISTS `t_user_video_details2`;
CREATE TABLE `t_user_video_details2`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后视频id',
  `state` int(11) NULL DEFAULT NULL COMMENT '状态(1未学习 2已学习)',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户观看视频记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_user_video_details2
-- ----------------------------

-- ----------------------------
-- Table structure for t_user_video_details3
-- ----------------------------
DROP TABLE IF EXISTS `t_user_video_details3`;
CREATE TABLE `t_user_video_details3`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后视频id',
  `state` int(11) NULL DEFAULT NULL COMMENT '状态(1未学习 2已学习)',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户观看视频记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_user_video_details3
-- ----------------------------

-- ----------------------------
-- Table structure for t_user_video_details4
-- ----------------------------
DROP TABLE IF EXISTS `t_user_video_details4`;
CREATE TABLE `t_user_video_details4`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后视频id',
  `state` int(11) NULL DEFAULT NULL COMMENT '状态(1未学习 2已学习)',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户观看视频记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_user_video_details4
-- ----------------------------

-- ----------------------------
-- Table structure for t_user_video_details5
-- ----------------------------
DROP TABLE IF EXISTS `t_user_video_details5`;
CREATE TABLE `t_user_video_details5`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `appUserId` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `coursePackageId` int(11) NULL DEFAULT NULL COMMENT '课包id',
  `courseId` int(11) NULL DEFAULT NULL COMMENT '课后视频id',
  `state` int(11) NULL DEFAULT NULL COMMENT '状态(1未学习 2已学习)',
  `insertTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户观看视频记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_user_video_details5
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;
