/*
MySQL Data Transfer
Source Host: localhost
Source Database: system
Target Host: localhost
Target Database: system
Date: 2018/2/26 21:28:39
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_admin
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
`ano` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
`pwd` varchar(32) DEFAULT NULL,
`home` varchar(20) DEFAULT NULL,
`email` varchar(20) DEFAULT NULL,
`gender` char(5) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ano`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Table structure for t_class
-- ----------------------------
DROP TABLE IF EXISTS `t_class`;
CREATE TABLE `t_class` (
`classno` int(11) unsigned NOT NULL AUTO_INCREMENT,
`cname` varchar(20) DEFAULT NULL,
`cteacher` varchar(20) DEFAULT NULL,
`classroom` int(11) DEFAULT NULL,
PRIMARY KEY (`classno`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Table structure for t_course
-- ----------------------------
DROP TABLE IF EXISTS `t_course`;
CREATE TABLE `t_course` (
`cno` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
`credit` tinyint(5) DEFAULT NULL,
`periodstart` date DEFAULT NULL,
`periodend` date DEFAULT NULL,
PRIMARY KEY (`cno`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Table structure for t_sc
-- ----------------------------
DROP TABLE IF EXISTS `t_sc`;
CREATE TABLE `t_sc` (
`sno` int(11) unsigned NOT NULL DEFAULT '0',
`cno` int(11) unsigned NOT NULL DEFAULT '0',
`tno` int(11) unsigned NOT NULL DEFAULT '0',
`score` tinyint(5) unsigned DEFAULT NULL,
PRIMARY KEY (`sno`,`cno`,`tno`),
KEY `cno` (`cno`),
KEY `tno` (`tno`),
CONSTRAINT `t_sc_ibfk_3` FOREIGN KEY (`tno`) REFERENCES `t_teacher` (`tno`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `t_sc_ibfk_1` FOREIGN KEY (`sno`) REFERENCES `t_student` (`sno`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `t_sc_ibfk_2` FOREIGN KEY (`cno`) REFERENCES `t_course` (`cno`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Table structure for t_student
-- ----------------------------
DROP TABLE IF EXISTS `t_student`;
CREATE TABLE `t_student` (
`sno` int(11) unsigned NOT NULL AUTO_INCREMENT,
`pwd` varchar(20) DEFAULT NULL,
`sname` varchar(20) DEFAULT NULL,
`home` varchar(20) DEFAULT NULL,
`gender` char(5) DEFAULT NULL,
`birth` date DEFAULT NULL,
`classno` int(11) unsigned DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
PRIMARY KEY (`sno`),
KEY `classno` (`classno`),
CONSTRAINT `t_student_ibfk_1` FOREIGN KEY (`classno`) REFERENCES `t_class` (`classno`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Table structure for t_tc
-- ----------------------------
DROP TABLE IF EXISTS `t_tc`;
CREATE TABLE `t_tc` (
`cno` int(11) unsigned NOT NULL DEFAULT '0',
`tno` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`cno`,`tno`),
KEY `tno` (`tno`),
CONSTRAINT `t_tc_ibfk_1` FOREIGN KEY (`cno`) REFERENCES `t_course` (`cno`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `t_tc_ibfk_2` FOREIGN KEY (`tno`) REFERENCES `t_teacher` (`tno`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Table structure for t_teacher
-- ----------------------------
DROP TABLE IF EXISTS `t_teacher`;
CREATE TABLE `t_teacher` (
`tno` int(11) unsigned NOT NULL AUTO_INCREMENT,
`tname` varchar(20) DEFAULT NULL,
`pwd` varchar(20) DEFAULT NULL,
`home` varchar(20) DEFAULT NULL,
`hiredate` date DEFAULT NULL,
`remark` varchar(500) DEFAULT NULL,
PRIMARY KEY (`tno`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records
-- ----------------------------