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