PRIMARY KEY (`s_id`)
)
学生成绩表
CREATE TABLE `student_grade` (
`sc_id` int(11) NOT NULL AUTO_INCREMENT,
`s_id` int(11) DEFAULT NULL,
`sj_id` int(11) DEFAULT NULL,
`grade` int(11) NOT NULL,
`sj_date` date NOT NULL,
PRIMARY KEY (`sc_id`),
KEY `FKDCA1CCD39B735348` (`s_id`),
KEY `FKDCA1CCD36A65347` (`sj_id`),
CONSTRAINT `FKDCA1CCD36A65347` FOREIGN KEY (`sj_id`) REFERENCES
`subj` (`sj_id`),
CONSTRAINT `FKDCA1CCD39B735348` FOREIGN KEY (`s_id`) REFERENCES
`student` (`s_id`),
CONSTRAINT `student_grade_ibfk_1` FOREIGN KEY (`s_id`) REFERENCES
`student` (`s_id`),
CONSTRAINT `student_grade_ibfk_2` FOREIGN KEY (`sj_id`) REFERENCES
`subj` (`sj_id`)
)
题库表
CREATE TABLE `exam` (
`exam_id` int(11) NOT NULL AUTO_INCREMENT,
`exam_mg` text COLLATE utf8_bin NOT NULL,
`exam_da` varchar(10) COLLATE utf8_bin NOT NULL,
`exam_type` int(11) NOT NULL,
`exam_grade` int(11) NOT NULL,
`type_a` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`type_b` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`type_c` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`type_d` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`sj_id` int(11) DEFAULT NULL,
`exam_date` date NOT NULL,
PRIMARY KEY (`exam_id`),
KEY `FK2FB81F6A65347` (`sj_id`),
CONSTRAINT `exam_ibfk_1` FOREIGN KEY (`sj_id`) REFERENCES `subj`
(`sj_id`),
2
