--
-- Table structure for table `student_subperiod_comment`
--

DROP TABLE IF EXISTS `student_subperiod_comment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student_subperiod_comment` (
  `serial_std` int(11) DEFAULT NULL,
  `serial_sbp` int(11) DEFAULT NULL,
  `comment_ssc` text NOT NULL,
  `serial_usr` int(11) DEFAULT NULL,
  `serial_crs` int(11) DEFAULT NULL,
  KEY `fk_relationship_44315` (`serial_usr`,`serial_crs`),
  KEY `fk_relationship_44316` (`serial_sbp`),
  KEY `fk_relationship_44318` (`serial_std`),
  CONSTRAINT `fk_relationship_44315` FOREIGN KEY (`serial_usr`, `serial_crs`) REFERENCES `user_course_comment_setup` (`serial_usr`, `serial_crs`),
  CONSTRAINT `fk_relationship_44316` FOREIGN KEY (`serial_sbp`) REFERENCES `subperiod` (`serial_sbp`),
  CONSTRAINT `fk_relationship_44318` FOREIGN KEY (`serial_std`) REFERENCES `student` (`serial_std`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;