/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : localhost:3306
 Source Schema         : pas

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

 Date: 26/12/2021 12:17:48
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for achievement
-- ----------------------------
DROP TABLE IF EXISTS `achievement`;
CREATE TABLE `achievement`  (
  `achievement_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `achievement_biology` float NULL DEFAULT NULL,
  `achievement_chemistry` float NULL DEFAULT NULL,
  `achievement_chinese` float NULL DEFAULT NULL,
  `achievement_english` float NULL DEFAULT NULL,
  `achievement_geography` float NULL DEFAULT NULL,
  `achievement_history` float NULL DEFAULT NULL,
  `achievement_math` float NULL DEFAULT NULL,
  `achievement_physics` float NULL DEFAULT NULL,
  `achievement_politics` float NULL DEFAULT NULL,
  `exam_info_id` bigint(20) NULL DEFAULT NULL,
  `student_id` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`achievement_id`) USING BTREE,
  INDEX `FKoxnsatg9ogd0a2xo8ginb22tv`(`exam_info_id`) USING BTREE,
  INDEX `FK9ihd6yxt6kpu0t6rg7joajmio`(`student_id`) USING BTREE,
  CONSTRAINT `FK9ihd6yxt6kpu0t6rg7joajmio` FOREIGN KEY (`student_id`) REFERENCES `student` (`student_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKoxnsatg9ogd0a2xo8ginb22tv` FOREIGN KEY (`exam_info_id`) REFERENCES `exam_info` (`exam_info_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of achievement
-- ----------------------------
INSERT INTO `achievement` VALUES (3, NULL, NULL, 100, 50, 66, 78, 100, NULL, 77, 2, 1);
INSERT INTO `achievement` VALUES (4, NULL, NULL, 45, 66, 45, 66, 44, NULL, 77, 2, 2);
INSERT INTO `achievement` VALUES (5, NULL, NULL, 4, 77, 11, 77, 5, NULL, 99, 2, 3);
INSERT INTO `achievement` VALUES (7, NULL, NULL, 50, 50, 50, 50, 50, NULL, 50, 4, 3);

-- ----------------------------
-- Table structure for clazz
-- ----------------------------
DROP TABLE IF EXISTS `clazz`;
CREATE TABLE `clazz`  (
  `clazz_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `clazz_created` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `clazz_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `clazz_type` int(11) NULL DEFAULT NULL,
  `clazz_leader` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`clazz_id`) USING BTREE,
  INDEX `FKnet528p5973rt4eqvgvmyn8q0`(`clazz_leader`) USING BTREE,
  CONSTRAINT `FKnet528p5973rt4eqvgvmyn8q0` FOREIGN KEY (`clazz_leader`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of clazz
-- ----------------------------
INSERT INTO `clazz` VALUES (1, '2021', '1班', 0, 2);
INSERT INTO `clazz` VALUES (2, '2021', '火箭班', 0, 1);

-- ----------------------------
-- Table structure for exam_info
-- ----------------------------
DROP TABLE IF EXISTS `exam_info`;
CREATE TABLE `exam_info`  (
  `exam_info_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `exam_info_created` datetime(6) NULL DEFAULT NULL,
  `exam_info_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `exam_info_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `exam_info_creator` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`exam_info_id`) USING BTREE,
  INDEX `FKhv0r87t7lb77e9yk8s141i7lw`(`exam_info_creator`) USING BTREE,
  CONSTRAINT `FKhv0r87t7lb77e9yk8s141i7lw` FOREIGN KEY (`exam_info_creator`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of exam_info
-- ----------------------------
INSERT INTO `exam_info` VALUES (2, '2021-07-02 14:00:03.771000', '2021级1班上半学期第一次班级模拟考试', '单班考试', 2);
INSERT INTO `exam_info` VALUES (4, '2021-07-10 09:48:53.797000', '2021级火箭班上半学期第一次班级模拟考试', '单班考试', 1);

-- ----------------------------
-- Table structure for exam_info_achievements
-- ----------------------------
DROP TABLE IF EXISTS `exam_info_achievements`;
CREATE TABLE `exam_info_achievements`  (
  `exam_info_exam_info_id` bigint(20) NOT NULL,
  `achievements_achievement_id` bigint(20) NOT NULL,
  UNIQUE INDEX `UK_q2vse5svaxe75n01nvgm7stlt`(`achievements_achievement_id`) USING BTREE,
  INDEX `FK2sipixk668cgwsg8veeufvvy0`(`exam_info_exam_info_id`) USING BTREE,
  CONSTRAINT `FK2sipixk668cgwsg8veeufvvy0` FOREIGN KEY (`exam_info_exam_info_id`) REFERENCES `exam_info` (`exam_info_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKlyf2e6arsetm7qrjn3spyqsn1` FOREIGN KEY (`achievements_achievement_id`) REFERENCES `achievement` (`achievement_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for exam_info_clazz
-- ----------------------------
DROP TABLE IF EXISTS `exam_info_clazz`;
CREATE TABLE `exam_info_clazz`  (
  `exam_info_id` bigint(20) NOT NULL,
  `clazz_id` bigint(20) NOT NULL,
  INDEX `FKmxxeae8y1jo636gj0hhax9m07`(`clazz_id`) USING BTREE,
  INDEX `FKsqto89s4nb3ivuj5s2imn0bbb`(`exam_info_id`) USING BTREE,
  CONSTRAINT `FKmxxeae8y1jo636gj0hhax9m07` FOREIGN KEY (`clazz_id`) REFERENCES `clazz` (`clazz_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKsqto89s4nb3ivuj5s2imn0bbb` FOREIGN KEY (`exam_info_id`) REFERENCES `exam_info` (`exam_info_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of exam_info_clazz
-- ----------------------------
INSERT INTO `exam_info_clazz` VALUES (2, 1);
INSERT INTO `exam_info_clazz` VALUES (4, 2);

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student`  (
  `student_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `student_card` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `student_gender` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `student_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `clazz_id` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`student_id`) USING BTREE,
  UNIQUE INDEX `UK_cj5qldbgdmlai1v8njecx3a5j`(`student_card`) USING BTREE,
  INDEX `FKr6vhwx3i4blsfj07c5ttqwj9p`(`clazz_id`) USING BTREE,
  CONSTRAINT `FKr6vhwx3i4blsfj07c5ttqwj9p` FOREIGN KEY (`clazz_id`) REFERENCES `clazz` (`clazz_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES (1, '111111111111111', '女', '张三', 1);
INSERT INTO `student` VALUES (2, '456798777777777', '男', '李四', 1);
INSERT INTO `student` VALUES (3, '122222222221111', '女', '寒王', 1);

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_desc` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `role_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '管理员', 'ROLE_ADMIN');
INSERT INTO `sys_role` VALUES (2, '教师', 'ROLE_TEACHER');

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_created` datetime(6) NULL DEFAULT NULL,
  `user_last_login` datetime(6) NULL DEFAULT NULL,
  `user_login_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user_state` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE INDEX `UK_ey24pbq3j3q9igv45428obilr`(`user_login_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, '2021-07-18 05:45:24.323000', '2021-12-16 08:29:36.183000', 'admin', '教务处', '$2a$10$qPIhYnH5Q9NOajBYlWYJjOosCN69DquSnp8d4pyUARiaHLPHTHjcu', 1);
INSERT INTO `sys_user` VALUES (2, '2021-07-18 05:45:16.924000', '2021-07-18 05:46:54.795000', '13588888888', '吴建国', '$2a$10$WP8u4FV/N2TTpMTsBxzxiO2W0T0eTt07H8virqvYtRt0/v6dBveDK', 1);
INSERT INTO `sys_user` VALUES (3, '2021-12-16 08:28:36.568000', '2021-12-16 08:28:36.568000', '12345678944', '分摊金', '$2a$10$r0KhjoPCUTJQfDqzotVlNe8wBUTRj9ztvvCKk23nI1Y7tSiH2a8g2', 1);

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `user_id` bigint(20) NOT NULL,
  `role_id` bigint(20) NOT NULL,
  INDEX `FKhh52n8vd4ny9ff4x9fb8v65qx`(`role_id`) USING BTREE,
  INDEX `FKb40xxfch70f5qnyfw8yme1n1s`(`user_id`) USING BTREE,
  CONSTRAINT `FKb40xxfch70f5qnyfw8yme1n1s` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKhh52n8vd4ny9ff4x9fb8v65qx` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES (2, 1);
INSERT INTO `sys_user_role` VALUES (2, 2);
INSERT INTO `sys_user_role` VALUES (1, 1);
INSERT INTO `sys_user_role` VALUES (1, 2);
INSERT INTO `sys_user_role` VALUES (3, 2);

SET FOREIGN_KEY_CHECKS = 1;