--
-- Table structure for table `employee_lunch_contract_detail`
--

DROP TABLE IF EXISTS `employee_lunch_contract_detail`;

CREATE TABLE `employee_lunch_contract_detail` (
  `serial_eld` int(11) NOT NULL auto_increment,
  `serial_elc` int(11) NOT NULL,
  `week_days_eld` enum('MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY') NOT NULL,
  `date_eld` date NOT NULL,
  `status_eld` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_eld`),
  KEY `fk_relationship_8123333` (`serial_elc`),
  CONSTRAINT `fk_relationship_8123333` FOREIGN KEY (`serial_elc`) REFERENCES `employee_lunch_contract` (`serial_elc`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;