报表开发1-建表代码

建表代码：

/*
 Navicat Premium Data Transfer

 Source Server         : 本地xy1234
 Source Server Type    : MySQL
 Source Server Version : 80028
 Source Host           : localhost:3306
 Source Schema         : exam

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

 Date: 10/08/2022 16:29:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for class_info
-- ----------------------------
DROP TABLE IF EXISTS `class_info`;
CREATE TABLE `class_info`  (
  `id` int(0) NOT NULL,
  `class_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `teacher_id` int(0) NULL DEFAULT NULL,
  `open_date` date NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of class_info
-- ----------------------------
INSERT INTO `class_info` VALUES (101, '一班', 2001, '2022-05-01');
INSERT INTO `class_info` VALUES (102, '二班', 2002, '2022-05-01');
INSERT INTO `class_info` VALUES (103, '三班', 2003, '2022-05-01');

-- ----------------------------
-- Table structure for score_info
-- ----------------------------
DROP TABLE IF EXISTS `score_info`;
CREATE TABLE `score_info`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '成绩流水号',
  `exam_title` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '考试名称',
  `stu_id` int(0) NULL DEFAULT NULL COMMENT '学生编号',
  `subject_id` int(0) NULL DEFAULT NULL COMMENT '科目编号',
  `exam_score` int(0) NULL DEFAULT NULL COMMENT '考试成绩',
  `exam_date` date NULL DEFAULT NULL COMMENT '考试日期',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of score_info
-- ----------------------------
INSERT INTO `score_info` VALUES (316, '二班java摸底考试', 1, 1400, 111, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (317, '二班java摸底考试', 1, 1300, 46, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (318, '二班java摸底考试', 1, 1200, 68, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (319, '二班java摸底考试', 1, 1100, 71, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (320, '二班java摸底考试', 2, 1400, 121, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (321, '二班java摸底考试', 2, 1300, 61, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (322, '二班java摸底考试', 2, 1200, 113, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (323, '二班java摸底考试', 2, 1100, 54, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (324, '二班java摸底考试', 3, 1400, NULL, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:38:37');
INSERT INTO `score_info` VALUES (325, '二班java摸底考试', 3, 1300, NULL, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:38:37');
INSERT INTO `score_info` VALUES (326, '二班java摸底考试', 3, 1200, NULL, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:38:37');
INSERT INTO `score_info` VALUES (327, '二班java摸底考试', 3, 1100, NULL, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:38:37');
INSERT INTO `score_info` VALUES (328, '二班java摸底考试', 4, 1400, NULL, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:38:37');
INSERT INTO `score_info` VALUES (329, '二班java摸底考试', 4, 1300, NULL, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:38:37');
INSERT INTO `score_info` VALUES (330, '二班java摸底考试', 4, 1200, NULL, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:38:37');
INSERT INTO `score_info` VALUES (331, '二班java摸底考试', 4, 1100, NULL, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:38:37');
INSERT INTO `score_info` VALUES (332, '二班java摸底考试', 5, 1400, 98, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (333, '二班java摸底考试', 5, 1300, 99, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (334, '二班java摸底考试', 5, 1200, 70, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (335, '二班java摸底考试', 5, 1100, 122, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (336, '二班java摸底考试', 6, 1400, 72, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (337, '二班java摸底考试', 6, 1300, 62, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (338, '二班java摸底考试', 6, 1200, 64, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (339, '二班java摸底考试', 6, 1100, 104, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (340, '二班java摸底考试', 7, 1400, 100, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (341, '二班java摸底考试', 7, 1300, 58, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (342, '二班java摸底考试', 7, 1200, 61, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (343, '二班java摸底考试', 7, 1100, 100, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (344, '二班java摸底考试', 8, 1400, 85, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (345, '二班java摸底考试', 8, 1300, 96, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (346, '二班java摸底考试', 8, 1200, 96, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (347, '二班java摸底考试', 8, 1100, 61, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (348, '二班java摸底考试', 9, 1400, 85, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (349, '二班java摸底考试', 9, 1300, 115, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (350, '二班java摸底考试', 9, 1200, 90, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (351, '二班java摸底考试', 9, 1100, 72, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (352, '二班java摸底考试', 10, 1400, 63, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (353, '二班java摸底考试', 10, 1300, 70, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (354, '二班java摸底考试', 10, 1200, 128, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (355, '二班java摸底考试', 10, 1100, 102, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (356, '二班java摸底考试', 11, 1400, 94, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (357, '二班java摸底考试', 11, 1300, 35, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (358, '二班java摸底考试', 11, 1200, 61, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');
INSERT INTO `score_info` VALUES (359, '二班java摸底考试', 11, 1100, 73, '2022-05-16', '2022-08-10 15:38:37', '2022-08-10 15:43:10');

-- ----------------------------
-- Table structure for student_info
-- ----------------------------
DROP TABLE IF EXISTS `student_info`;
CREATE TABLE `student_info`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '学号',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int(0) NULL DEFAULT NULL,
  `gender` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `class_id` int(0) NULL DEFAULT NULL COMMENT '所在班级',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of student_info
-- ----------------------------
INSERT INTO `student_info` VALUES (1, 'a', 24, '男', 101);
INSERT INTO `student_info` VALUES (2, 'b', 24, '男', 101);
INSERT INTO `student_info` VALUES (3, 'c', 24, '女', 101);
INSERT INTO `student_info` VALUES (4, 'd', 24, '男', 102);
INSERT INTO `student_info` VALUES (5, 'e', 24, '男', 102);
INSERT INTO `student_info` VALUES (6, 'f', 24, '男', 102);
INSERT INTO `student_info` VALUES (7, 'g', 24, '男', 102);
INSERT INTO `student_info` VALUES (8, 'h', 24, '女', 103);
INSERT INTO `student_info` VALUES (9, 'i', 24, '男', 103);
INSERT INTO `student_info` VALUES (10, 'j', 24, '男', 103);
INSERT INTO `student_info` VALUES (11, 'k', 24, '女', 103);

-- ----------------------------
-- Table structure for subject_info
-- ----------------------------
DROP TABLE IF EXISTS `subject_info`;
CREATE TABLE `subject_info`  (
  `id` int(0) NOT NULL,
  `subject_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of subject_info
-- ----------------------------
INSERT INTO `subject_info` VALUES (1100, 'java');
INSERT INTO `subject_info` VALUES (1200, 'go');
INSERT INTO `subject_info` VALUES (1300, 'python');
INSERT INTO `subject_info` VALUES (1400, 'c#');

SET FOREIGN_KEY_CHECKS = 1;

 

 

 

 

posted @ 2022-08-10 16:31  xiaoyongdata  阅读(70)  评论(0)    收藏  举报