--
-- Table structure for table `block_content`
--

DROP TABLE IF EXISTS `block_content`;
CREATE TABLE `block_content` (
  `serial_bct` int(11) NOT NULL AUTO_INCREMENT,
  `serial_sbc` int(11) DEFAULT NULL,
  `serial_sbp` int(11) DEFAULT NULL,
  `block_bct` TEXT NULL DEFAULT NULL ,
  `comment_bct` TEXT NULL DEFAULT NULL ,  
  `status_bct` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_bct`),
  KEY `fk_block_content_serial_sbc` (`serial_sbc`),
  KEY `fk_block_content_serial_sbp` (`serial_sbp`),  
  CONSTRAINT `fk_block_content_serial_sbc` FOREIGN KEY (`serial_sbc`) REFERENCES `subject_course` (`serial_sbc`),
  CONSTRAINT `fk_block_content_serial_sbp` FOREIGN KEY (`serial_sbp`) REFERENCES `subperiod` (`serial_sbp`)  
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Table structure for table `block_content_grade_criteria`
--

DROP TABLE IF EXISTS `block_content_grade_criteria`;
CREATE TABLE `block_content_grade_criteria` (
  `serial_bcc` int(11) NOT NULL AUTO_INCREMENT,
  `serial_scy` int(11) DEFAULT NULL,  
  `grade_type_bcc` enum('FULFILLMENT','SCOPE') NOT NULL,
  `name_bcc` varchar(100) NOT NULL,  
  `status_bcc` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_bcc`),  
  CONSTRAINT `fk_block_content_serial_scy` FOREIGN KEY (`serial_scy`) REFERENCES `school_year` (`serial_scy`)  
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



--
-- Table structure for table `block_content_grade`
--
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `block_content_grade`;
CREATE TABLE `block_content_grade` (
  `serial_bcg` int(11) NOT NULL AUTO_INCREMENT,
  `serial_bct` int(11) DEFAULT NULL,
  `serial_bcc` int(11) DEFAULT NULL,  
  `status_bcg` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_bcg`),
  KEY `fk_block_content_grade_serial_bct` (`serial_bct`),
  KEY `fk_block_content_grade_serial_bcc` (`serial_bcc`),  
  CONSTRAINT `fk_block_content_grade_serial_bct` FOREIGN KEY (`serial_bct`) REFERENCES `block_content` (`serial_bct`),
  CONSTRAINT `fk_block_content_grade_serial_bcc` FOREIGN KEY (`serial_bcc`) REFERENCES `block_content_grade_criteria` (`serial_bcc`)  
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET FOREIGN_KEY_CHECKS = 1;



--
-- Table structure for table `subject_course_range_observation`
--

DROP TABLE IF EXISTS `subject_course_range_observation`;
CREATE TABLE `subject_course_range_observation` (
  `serial_sbc` int(11) NOT NULL,
  `serial_qeq` int(11) NOT NULL,
  `serial_prd` int(11) DEFAULT NULL,
  `serial_sbp` int(11) DEFAULT NULL,
  `observation_sbr` TEXT NULL DEFAULT NULL ,      
  KEY `fk_subject_course_range_observation_serial_sbc` (`serial_sbc`),
  KEY `fk_subject_course_range_observation_serial_qeq` (`serial_qeq`),  
  KEY `fk_subject_course_range_observation_serial_prd` (`serial_prd`),
  KEY `fk_subject_course_range_observation_serial_sbp` (`serial_sbp`),
  CONSTRAINT `fk_subject_course_range_observation_serial_sbc` FOREIGN KEY (`serial_sbc`) REFERENCES `subject_course` (`serial_sbc`),
  CONSTRAINT `fk_subject_course_range_observation_serial_qeq` FOREIGN KEY (`serial_qeq`) REFERENCES `qualitative_equivalence` (`serial_qeq`),
  CONSTRAINT `fk_subject_course_range_observation_serial_prd` FOREIGN KEY (`serial_prd`) REFERENCES `period` (`serial_prd`),
  CONSTRAINT `fk_subject_course_range_observation_serial_sbp` FOREIGN KEY (`serial_sbp`) REFERENCES `subperiod` (`serial_sbp`)  
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



--
-- Table structure for table `subject_course_strategy`
--

DROP TABLE IF EXISTS `subject_course_strategy`;
CREATE TABLE `subject_course_strategy` (
  `serial_sbc` int(11) NOT NULL,  
  `serial_prd` int(11) DEFAULT NULL,
  `serial_sbp` int(11) DEFAULT NULL,
  `strategy_sbs` TEXT NULL DEFAULT NULL ,    
  KEY `fk_subject_course_strategy_serial_sbc` (`serial_sbc`),  
  KEY `fk_subject_course_strategy_serial_prd` (`serial_prd`),
  KEY `fk_subject_course_strategy_serial_sbp` (`serial_sbp`),
  CONSTRAINT `fk_subject_course_strategy_serial_sbc` FOREIGN KEY (`serial_sbc`) REFERENCES `subject_course` (`serial_sbc`),  
  CONSTRAINT `fk_subject_course_strategy_serial_prd` FOREIGN KEY (`serial_prd`) REFERENCES `period` (`serial_prd`),
  CONSTRAINT `fk_subject_course_strategy_serial_sbp` FOREIGN KEY (`serial_sbp`) REFERENCES `subperiod` (`serial_sbp`)  
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Table structure for table `academic_area_comment`
--

DROP TABLE IF EXISTS `academic_area_comment`;
CREATE TABLE `academic_area_comment` (
  `serial_aca` int(11) NOT NULL,  
  `serial_prd` int(11) DEFAULT NULL,
  `serial_sbp` int(11) DEFAULT NULL,
  `observation_aac` TEXT NULL DEFAULT NULL ,  
  `approach_aac` TEXT NULL DEFAULT NULL ,    
  KEY `fk_academic_area_comment_serial_aca` (`serial_aca`),  
  KEY `fk_academic_area_comment_serial_prd` (`serial_prd`),
  KEY `fk_academic_area_comment_serial_sbp` (`serial_sbp`),
  CONSTRAINT `fk_academic_area_comment_serial_aca` FOREIGN KEY (`serial_aca`) REFERENCES `academic_area` (`serial_aca`),  
  CONSTRAINT `fk_academic_area_comment_serial_prd` FOREIGN KEY (`serial_prd`) REFERENCES `period` (`serial_prd`),
  CONSTRAINT `fk_academic_area_comment_serial_sbp` FOREIGN KEY (`serial_sbp`) REFERENCES `subperiod` (`serial_sbp`)  
) ENGINE=InnoDB DEFAULT CHARSET=latin1;