
CREATE TABLE valoracion(
    idRec smallint unsigned AUTO_INCREMENT,
    categoria char(11) NOT NULL,
    momento varchar(100) NOT NULL,
    descrip varchar(255) NOT NULL,
    Alurec tinyint unsigned NOT NULL,
    Aluenv tinyint unsigned NOT NULL,
    CONSTRAINT pk_valoracion PRIMARY KEY (idRec),
    CONSTRAINT fk_receptor FOREIGN KEY (Alurec) REFERENCES alumno(idAlumno),
    CONSTRAINT fk_emisor FOREIGN KEY (Aluenv) REFERENCES alumno(idAlumno)
);