--
-- Table structure for table `student_subperiod_discipline_course_director`
--
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `student_subperiod_discipline_course_director`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student_subperiod_discipline_course_director` (
  `serial_cdd` int(11) NOT NULL AUTO_INCREMENT,
  `serial_sbp` int(11) DEFAULT NULL,
  `serial_std` int(11) DEFAULT NULL,
  `serial_spt` int(11) DEFAULT NULL,
  `serial_lvl` int(11) DEFAULT NULL,
  `serial_scy` int(11) DEFAULT NULL,
  `serial_set` int(11) DEFAULT NULL,
  `grade_cdd` decimal(8,5) DEFAULT NULL,
  PRIMARY KEY (`serial_cdd`),
  KEY `fk_relationship_7454` (`serial_std`,`serial_spt`,`serial_lvl`,`serial_scy`,`serial_set`),
  KEY `fk_relationship_7456` (`serial_sbp`),
  CONSTRAINT `fk_relationship_7454` FOREIGN KEY (`serial_std`, `serial_spt`, `serial_lvl`, `serial_scy`, `serial_set`) REFERENCES `student_year` (`serial_std`, `serial_spt`, `serial_lvl`, `serial_scy`, `serial_set`),
  CONSTRAINT `fk_relationship_7456` FOREIGN KEY (`serial_sbp`) REFERENCES `subperiod` (`serial_sbp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET FOREIGN_KEY_CHECKS = 1;