DB_51Aspx/sys_leavedb.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : localhost:3306
 Source Schema         : sys_leavedb

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

 Date: 07/06/2022 17:05:29
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_classes
-- ----------------------------
DROP TABLE IF EXISTS `sys_classes`;
CREATE TABLE `sys_classes`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `class_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL COMMENT '班级编号',
  `class_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_croatian_ci NULL DEFAULT NULL COMMENT '名称',
  `dep_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_croatian_ci NULL DEFAULT NULL COMMENT '二级学院编号',
  `major` varchar(11) CHARACTER SET utf8 COLLATE utf8_croatian_ci NULL DEFAULT NULL COMMENT '专业',
  `grade` varchar(10) CHARACTER SET utf8 COLLATE utf8_croatian_ci NULL DEFAULT NULL COMMENT '年级',
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `class_id`(`class_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_croatian_ci COMMENT = '班级表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_classes
-- ----------------------------
INSERT INTO `sys_classes` VALUES (1, 'A201801', '18软件工程1班', 'G1', '软件工程', '2018', '2021-05-04 23:46:22', '2021-05-04 23:46:25');
INSERT INTO `sys_classes` VALUES (2, 'A201802', '18软件工程2班', 'G1', '软件工程', '2018', '2021-05-04 23:47:03', '2021-05-04 23:47:06');
INSERT INTO `sys_classes` VALUES (3, 'A201803', '18软件工程6班', 'G1', '软件工程', '2018', '2021-05-04 23:47:57', '2021-05-04 23:48:01');
INSERT INTO `sys_classes` VALUES (5, 'A201804', '大数据', 'G1', '大数据', '2019', '2022-06-07 15:09:29', '2022-06-07 15:09:37');
INSERT INTO `sys_classes` VALUES (7, 'A201805', '划水', 'G2', '112', '1234', '2022-06-07 16:52:35', '2022-06-07 16:52:35');

-- ----------------------------
-- Table structure for sys_course
-- ----------------------------
DROP TABLE IF EXISTS `sys_course`;
CREATE TABLE `sys_course`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL COMMENT '课程编号',
  `class_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL COMMENT '班号(外键）',
  `course_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_croatian_ci NULL DEFAULT NULL COMMENT '课程名称',
  `year` varchar(10) CHARACTER SET utf8 COLLATE utf8_croatian_ci NULL DEFAULT NULL COMMENT '学年',
  `term` varchar(150) CHARACTER SET utf8 COLLATE utf8_croatian_ci NULL DEFAULT NULL COMMENT '学期',
  `hour` int(2) NULL DEFAULT NULL COMMENT '学时',
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,