CREATE TABLE `scale_quantitative_grades` ( `serial_sqg` int(11) NOT NULL AUTO_INCREMENT, `serial_scy` int(11) DEFAULT NULL, `lower_percentage_sqg` decimal(5,2) NOT NULL, `higher_percentage_sqg` decimal(5,2) NOT NULL, `name_sqg` varchar(50) NOT NULL, `code_sqg` varchar(15) NOT NULL, `description_sqg` varchar(200) DEFAULT NULL, `status_sqg` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE', PRIMARY KEY (`serial_sqg`), KEY `fk_relationship_year_sqg` (`serial_scy`), CONSTRAINT `fk_relationship_year_sqg` FOREIGN KEY (`serial_scy`) REFERENCES `school_year` (`serial_scy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;