CREATE TABLE DEGREE_DATA_BY_EXECUTION_YEAR (
    ID_INTERNAL          INT(11) AUTO_INCREMENT,
    KEY_DEGREE           INT(11),
    KEY_EXECUTION_YEAR   INT(11),
    KEY_ROOT_DOMAIN_OBJECT INT(11) NOT NULL DEFAULT 1,
    ECTS_GRADING_SCALE   CHAR(1),
    PERCENTAGE_OF_GRADUATES INT(3),
    GRADES_RANGE         VARCHAR(7),
    CREATION_ENTITY      TEXT,
    CREATION_ENTITY_DATE DATE,
    UPDATE_ENTITY        TEXT,
    UPDATE_ENTITY_DATE   DATE,
	PRIMARY KEY(ID_INTERNAL),
	KEY `KEY_DEGREE` (`KEY_DEGREE`),
	KEY `KEY_EXECUTION_YEAR` (`KEY_EXECUTION_YEAR`),
    KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`)
);
