/*
Navicat MySQL Data Transfer

Source Server         : MySQL
Source Server Version : 50540
Source Host           : localhost:3306
Source Database       : studentinfomanagement

Target Server Type    : MYSQL
Target Server Version : 50540
File Encoding         : 65001

Date: 2020-12-20 16:04:51
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for class
-- ----------------------------
DROP TABLE IF EXISTS `class`;
CREATE TABLE `class` (
  `Clno` char(12) NOT NULL DEFAULT '',
  `Clname` char(12) DEFAULT NULL,
  `Dno` char(12) DEFAULT NULL,
  PRIMARY KEY (`Clno`),
  KEY `FK_Class_Department` (`Dno`),
  CONSTRAINT `class_ibfk_1` FOREIGN KEY (`Dno`) REFERENCES `department` (`Dno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of class
-- ----------------------------
INSERT INTO `class` VALUES ('20150103', '2015-3班', '201501');
INSERT INTO `class` VALUES ('20150104', '2015-4班', '201501');
INSERT INTO `class` VALUES ('20150201', '2015-1班', '201502');
INSERT INTO `class` VALUES ('20150202', '2015-2班', '201502');
INSERT INTO `class` VALUES ('20150301', '2015-1班', '201503');
INSERT INTO `class` VALUES ('20150302', '2015-2班', '201503');

-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `Cno` char(12) NOT NULL DEFAULT '',
  `Cname` char(12) DEFAULT NULL,
  `Cteacher` char(8) DEFAULT NULL,
  `Ccredit` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`Cno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO `course` VALUES ('1', '高等数学', '张三', '4');
INSERT INTO `course` VALUES ('2', '数据库原理设计', '李四', '3');
INSERT INTO `course` VALUES ('3', 'Java程序设计', '王五', '4');

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `Dno` char(12) NOT NULL DEFAULT '',
  `Dname` char(12) DEFAULT NULL,
  PRIMARY KEY (`Dno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES ('201501', '软件学院');
INSERT INTO `department` VALUES ('201502', '经管学院');
INSERT INTO `department` VALUES ('201503', '人文学院');
INSERT INTO `department` VALUES ('201504', '国际学院');
INSERT INTO `department` VALUES ('201505', '理学院');

-- ----------------------------
-- Table structure for sc
-- ----------------------------
DROP TABLE IF EXISTS `sc`;
CREATE TABLE `sc` (
  `Sno` char(12) NOT NULL DEFAULT '',
  `Cno` char(12) NOT NULL DEFAULT '',
  `Grade` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`Sno`,`Cno`),
  KEY `FK_SC_Course` (`Cno`),
  CONSTRAINT `sc_ibfk_1` FOREIGN KEY (`Sno`) REFERENCES `student` (`Sno`),
  CONSTRAINT `sc_ibfk_2` FOREIGN KEY (`Cno`) REFERENCES `course` (`Cno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sc
-- ----------------------------
INSERT INTO `sc` VALUES ('2015010312', '1', '50');
INSERT INTO `sc` VALUES ('2015010312', '2', '80');
INSERT INTO `sc` VALUES ('2015010312', '3', '70');
INSERT INTO `sc` VALUES ('2015010313', '1', '90');
INSERT INTO `sc` VALUES ('2015010313', '2', '89');
INSERT INTO `sc` VALUES ('2015010313', '3', '59');
INSERT INTO `sc` VALUES ('2015010314', '1', '85');
INSERT INTO `sc` VALUES ('2015010314', '2', '75');
INSERT INTO `sc` VALUES ('2015010314', '3', '95');

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `Sno` char(12) NOT NULL DEFAULT '',
  `Sname` char(8) DEFAULT NULL,
  `Ssex` char(2) DEFAULT NULL,
  `Sage` smallint(6) DEFAULT NULL,
  `Clno` char(12) DEFAULT NULL,
  PRIMARY KEY (`Sno`),
  KEY `FK_Student_Class` (`Clno`),
  CONSTRAINT `student_ibfk_1` FOREIGN KEY (`Clno`) REFERENCES `class` (`Clno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('2015010312', '张明', '男', '20', '20150103');
INSERT INTO `student` VALUES ('2015010313', '秦羽', '女', '19', '20150103');
INSERT INTO `student` VALUES ('2015010314', '刘翔', '男', '19', '20150103');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `username` char(12) NOT NULL DEFAULT '',
  `password` char(12) NOT NULL,
  `level` char(6) DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('admin', '666', '管理员');
INSERT INTO `user` VALUES ('user', '123', '用户');