--
-- Table structure for table `employee_lunch_contract`
--

DROP TABLE IF EXISTS `employee_lunch_contract`;

CREATE TABLE `employee_lunch_contract` (
  `serial_elc` int(11) NOT NULL auto_increment,
  `serial_cle` int(11) NOT NULL,
  `serial_emp` int(11) NOT NULL,
  `days_elc` set('MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY') NOT NULL,
  `start_date_elc` date NOT NULL,
  `end_date_elc` date NOT NULL,
  `lunch_quantity_elc` int(11) NOT NULL,
  `final_price_elc` decimal(10,2) NOT NULL,
  `status_elc` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_elc`),
  KEY `fk_relationship_8333` (`serial_cle`),
  KEY `fk_relationship_8334` (`serial_emp`),
  CONSTRAINT `fk_relationship_8333` FOREIGN KEY (`serial_cle`) REFERENCES `cat_lunch_employee` (`serial_cle`),
  CONSTRAINT `fk_relationship_8334` FOREIGN KEY (`serial_emp`) REFERENCES `employee` (`serial_emp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;