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

DROP TABLE IF EXISTS `student_refreshments_detail`;

CREATE TABLE `student_refreshments_detail` (
  `serial_sfd` int(11) NOT NULL auto_increment,
  `serial_std` int(11) NOT NULL,
  `serial_scy` int(11) NOT NULL,
  `month_year_sfd` text NOT NULL,
  `start_value_sfd` decimal(10,2) NOT NULL,
  `used_value_sfd` decimal(10,2) NOT NULL,
  `type_sfd` enum('PREPAID','REFRESHMENT') NOT NULL,
  `status_sfd` enum('ACTIVE','INACTIVE','CANCELLED') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_sfd`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;