8JJNhvNc

1SQL Code:
2        -- -----------------------------------------------------
3        -- Table `EjercicioBI`.`ExpedienteAlumno`
4        -- -----------------------------------------------------
5        CREATE TABLE IF NOT EXISTS `EjercicioBI`.`ExpedienteAlumno` (
6          `Matricula_CedulaEstudiante` INT(8) NOT NULL,
7          `Matricula_idCarrera` INT(4) NOT NULL,
8          `idAsignatura` INT(4) NOT NULL,
9          `idSeccion` INT(2) NOT NULL,
10           `idPeriodo` INT(4) NOT NULL,
11           `idTipoNota` INT(2) NOT NULL,
12          INDEX `fk_ExpedienteAlumno_Matricula1_idx` (`Matricula_CedulaEstudiante` ASC, `Matricula_idCarrera` ASC) VISIBLE,
13           PRIMARY KEY (`Matricula_CedulaEstudiante`, `Matricula_idCarrera`, `idAsignatura`, `idSeccion`, `idPeriodo`),
14           INDEX `fk_ExpedienteAlumno_ProgramacionPeriodo1_idx` (`idAsignatura` ASC, `idSeccion` ASC, `idPeriodo` ASC) VISIBLE,
15           INDEX `fk_ExpedienteAlumno_TipoNota1_idx` (`idTipoNota` ASC) VISIBLE,
16           CONSTRAINT `fk_ExpedienteAlumno_Matricula1`
17             FOREIGN KEY (`Matricula_CedulaEstudiante` , `Matricula_idCarrera`)
18             REFERENCES `EjercicioBI`.`Matricula` (`CedulaEstudiante` , `idCarrera`)
19             ON DELETE NO ACTION
20             ON UPDATE NO ACTION,
21           CONSTRAINT `fk_ExpedienteAlumno_ProgramacionPeriodo1`
22             FOREIGN KEY (`idAsignatura` , `idSeccion` , `idPeriodo`)
23             REFERENCES `EjercicioBI`.`ProgramacionPeriodo` (`idAsignatura` , `idSeccion` , `idPeriodo`)
24             ON DELETE NO ACTION
25             ON UPDATE NO ACTION,
26           CONSTRAINT `fk_ExpedienteAlumno_TipoNota1`
27             FOREIGN KEY (`idTipoNota`)
28             REFERENCES `EjercicioBI`.`TipoNota` (`idTipoNota`)
29             ON DELETE NO ACTION
30             ON UPDATE NO ACTION)
31         ENGINE = InnoDB