--
-- Table structure for table `year_vacations_dates`
--

DROP TABLE IF EXISTS `year_vacations_dates`;

CREATE TABLE `year_vacations_dates` (
  `serial_yvd` int(11) NOT NULL auto_increment,
  `serial_scy` int(11) NOT NULL,
  `date_yvd` date NOT NULL,
  `status_yvd` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_yvd`),
  KEY `fk_relationship_412002` (`serial_scy`),
  CONSTRAINT `fk_relationship_412002` FOREIGN KEY (`serial_scy`) REFERENCES `school_year` (`serial_scy`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;