--
-- Table structure for table `student_lunch_cancellation`
--

DROP TABLE IF EXISTS `student_lunch_cancellation`;

CREATE TABLE `student_lunch_cancellation` (
  `serial_slt` int(11) NOT NULL auto_increment,
  `serial_slc` int(11) NOT NULL,
  `serial_std` int(11) NOT NULL,
  `day_slt` ENUM('MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY') NOT NULL,
  `date_slt` date NOT NULL,
  `status_slt` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_slt`),
  KEY `fk_relationship_7663` (`serial_slc`),
  KEY `fk_relationship_7664` (`serial_std`),
  CONSTRAINT `fk_relationship_7663` FOREIGN KEY (`serial_slc`) REFERENCES `student_lunch_contract` (`serial_slc`),
  CONSTRAINT `fk_relationship_7664` FOREIGN KEY (`serial_std`) REFERENCES `student` (`serial_std`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;