DROP TABLE IF EXISTS `viu_itas`.`transcript_t`;
CREATE TABLE IF NOT EXISTS `viu_itas`.`transcript_t` (
  `student_id` INT NOT NULL,
  `course_id` VARCHAR(15) NOT NULL,
  `course_fg` FLOAT NULL,
  `course_lg` VARCHAR(2) NULL,
  CONSTRAINT
    PRIMARY KEY (`student_id`, `course_id`),
  CONSTRAINT
    FOREIGN KEY (`student_id`)
    REFERENCES `student_t`(`student_id`),
  CONSTRAINT
    FOREIGN KEY (`course_id`)
    REFERENCES `course_t`(`course_id`));