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