--
-- Table structure for table `student_lunch_contract`
--

DROP TABLE IF EXISTS `student_lunch_contract`;

CREATE TABLE `student_lunch_contract` (
  `serial_slc` int(11) NOT NULL auto_increment,
  `serial_lyt` int(11) NOT NULL,
  `serial_std` int(11) NOT NULL,
  `days_slc` set('MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY') NOT NULL,
  `start_date_slc` date NOT NULL,
  `end_date_slc` date NOT NULL,
  `lunch_quantity_slc` int(11) NOT NULL,
  `final_price_slc` decimal(10,2) NOT NULL,
  `status_slc` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_slc`),
  KEY `fk_relationship_7003` (`serial_lyt`),
  KEY `fk_relationship_7004` (`serial_std`),
  CONSTRAINT `fk_relationship_7003` FOREIGN KEY (`serial_lyt`) REFERENCES `level_section_year_lunch_type` (`serial_lyt`),
  CONSTRAINT `fk_relationship_7004` FOREIGN KEY (`serial_std`) REFERENCES `student` (`serial_std`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;