--
-- Table structure for table `student_lunch_contract_detail`
--

DROP TABLE IF EXISTS `student_lunch_contract_detail`;

CREATE TABLE `student_lunch_contract_detail` (
  `serial_sld` int(11) NOT NULL auto_increment,
  `serial_slc` int(11) NOT NULL,
  `week_day_sld` enum('MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY') NOT NULL,
  `date_sld` date NOT NULL,
  `status_sld` enum('ACTIVE','INACTIVE','CANCELLED') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_sld`),
  KEY `fk_relationship_7123003` (`serial_slc`),
  CONSTRAINT `fk_relationship_7123003` FOREIGN KEY (`serial_slc`) REFERENCES `student_lunch_contract` (`serial_slc`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;