--
-- Table structure for table `employee_lunch_cancellation`
--

DROP TABLE IF EXISTS `employee_lunch_cancellation`;

CREATE TABLE `employee_lunch_cancellation` (
  `serial_elt` int(11) NOT NULL auto_increment,
  `serial_elc` int(11) NOT NULL,
  `serial_emp` int(11) NOT NULL,
  `day_elt` ENUM('MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY') NOT NULL,
  `date_elt` date NOT NULL,
  `status_elt` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_elt`),
  KEY `fk_relationship_9623` (`serial_elc`),
  KEY `fk_relationship_9624` (`serial_emp`),
  CONSTRAINT `fk_relationship_9623` FOREIGN KEY (`serial_elc`) REFERENCES `employee_lunch_contract` (`serial_elc`),
  CONSTRAINT `fk_relationship_9624` FOREIGN KEY (`serial_emp`) REFERENCES `employee` (`serial_emp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;