SC表

/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50549
Source Host           : localhost:3306
Source Database       : ooxx

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

Date: 2019-08-19 16:10:39
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for sc
-- ----------------------------
DROP TABLE IF EXISTS `sc`;
CREATE TABLE `sc` (
  `sno` int(11) NOT NULL,
  `cno` int(11) NOT NULL,
  `score` int(11) DEFAULT NULL,
  PRIMARY KEY (`sno`,`cno`),
  KEY `cno` (`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 ('1', '1', '90');
INSERT INTO `sc` VALUES ('1', '2', '50');
INSERT INTO `sc` VALUES ('1', '3', '66');
INSERT INTO `sc` VALUES ('2', '1', '90');
INSERT INTO `sc` VALUES ('2', '2', '100');
INSERT INTO `sc` VALUES ('2', '3', '86');
INSERT INTO `sc` VALUES ('3', '1', '90');
INSERT INTO `sc` VALUES ('3', '2', '77');
INSERT INTO `sc` VALUES ('3', '3', '57');
INSERT INTO `sc` VALUES ('4', '1', '90');
INSERT INTO `sc` VALUES ('4', '2', '100');
INSERT INTO `sc` VALUES ('4', '3', '78');
INSERT INTO `sc` VALUES ('5', '2', '45');
/*
Navicat MySQL Data Transfer

Source S