XVdnFxwg

1CREATE TABLE IF NOT EXISTS `dat702_183sa02`.`grade` (
2  `STUDENT_ID` INT(8) NULL DEFAULT NULL,
3  `SECTION_ID` INT(8) NULL DEFAULT NULL,
4  `GRADE_TYPE_CODE` CHAR(2) NULL DEFAULT NULL,
5  `GRADE_CODE_OCCURENCE` INT(3) NOT NULL,
6  `NUMERIC_GRADE` INT(3) NULL DEFAULT NULL,
7  `COMMENTS` VARCHAR(200) NULL DEFAULT NULL,
8  PRIMARY KEY (`GRADE_CODE_OCCURENCE`),
9  INDEX `fk_1` (`GRADE_TYPE_CODE` ASC) VISIBLE,
10  INDEX `fk_2_idx` (`STUDENT_ID` ASC, `SECTION_ID` ASC) VISIBLE,
11  CONSTRAINT `fk_1`
12    FOREIGN KEY (`GRADE_TYPE_CODE`)
13    REFERENCES `dat702_183sa02`.`grade_type_weight` (`GRADE_TYPE_CODE`),
14  CONSTRAINT `fk_2`
15    FOREIGN KEY (`STUDENT_ID` , `SECTION_ID`)
16    REFERENCES `dat702_183sa02`.`enrollment` (`STUDENT_ID` , `STUDENT_ID`)
17    ON DELETE NO ACTION
18    ON UPDATE NO ACTION)
19ENGINE = InnoDB
20DEFAULT CHARACTER SET = latin1