--
-- Table structure for table `student_period_subject_skill_grade`
--

DROP TABLE IF EXISTS `student_subperiod_subject_skill_grade`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student_subperiod_subject_skill_grade` (
  `serial_sbg` int(11) NOT NULL AUTO_INCREMENT,
`serial_lsc` int(11) DEFAULT NULL,
  `serial_osc` int(11) DEFAULT NULL,
  `serial_yss` int(11) DEFAULT NULL,
`serial_sbp` int(11) DEFAULT NULL,
  `serial_std` int(11) DEFAULT NULL,
  `status_sbg` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_sbg`),
  KEY `fk_relationship_1323` (`serial_sbp`),
  KEY `fk_relationship_3243` (`serial_yss`),
  KEY `fk_relationship_3253` (`serial_osc`),
  KEY `fk_relationship_3263` (`serial_lsc`),
  KEY `fk_relationship_3273` (`serial_std`),
  CONSTRAINT `fk_relationship_1323` FOREIGN KEY (`serial_sbp`) REFERENCES `subperiod` (`serial_sbp`),
  CONSTRAINT `fk_relationship_3243` FOREIGN KEY (`serial_yss`) REFERENCES `year_subject_skills` (`serial_yss`),
  CONSTRAINT `fk_relationship_3253` FOREIGN KEY (`serial_osc`) REFERENCES `level_opt_skill_criteria` (`serial_osc`),
  CONSTRAINT `fk_relationship_3263` FOREIGN KEY (`serial_lsc`) REFERENCES `level_skill_grade_criteria` (`serial_lsc`),
  CONSTRAINT `fk_relationship_3273` FOREIGN KEY (`serial_std`) REFERENCES `student` (`serial_std`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `student_subperiod_subject_skill_grade`
--

LOCK TABLES `student_subperiod_subject_skill_grade` WRITE;
/*!40000 ALTER TABLE `student_subperiod_subject_skill_grade` DISABLE KEYS */;
/*!40000 ALTER TABLE `student_subperiod_subject_skill_grade` ENABLE KEYS */;
UNLOCK TABLES;