--
-- Table structure for table `subperiod_discipline`
--

SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `subperiod_discipline`;

CREATE TABLE `subperiod_discipline` (
  `serial_sbp` int(11) NOT NULL,
  `serial_std` int(11) NOT NULL,
  `serial_spt` int(11) NOT NULL,
  `serial_lvl` int(11) NOT NULL,
  `serial_scy` int(11) NOT NULL,
  `serial_set` int(11) NOT NULL,
  `supervisor_sbp_grade_dsc` decimal(8,5) DEFAULT NULL,
  `subjects_sbp_grade_dsc` decimal(8,5) DEFAULT NULL,
  `general_sbp_grade_dsc` decimal(8,5) DEFAULT NULL,
  `adjustment_sbp_dsc` decimal(8,5) DEFAULT NULL,
  PRIMARY KEY (`serial_sbp`,`serial_std`,`serial_spt`,`serial_lvl`,`serial_scy`,`serial_set`),
  KEY `fk_relationship_530` (`serial_std`,`serial_spt`,`serial_lvl`,`serial_scy`,`serial_set`),
  CONSTRAINT `fk_relationship_530` 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_501` FOREIGN KEY (`serial_sbp`) REFERENCES `subperiod` (`serial_sbp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET FOREIGN_KEY_CHECKS = 1;