CREATE TABLE `COMPETENCE_COURSE_INFORMATION_CHANGE_REQUEST`
(
ID_INTERNAL INTEGER NOT NULL AUTO_INCREMENT,
KEY_ROOT_DOMAIN_OBJECT INTEGER NOT NULL DEFAULT 1,
KEY_COMPETENCE_COURSE INTEGER NOT NULL,
KEY_REQUESTER INTEGER NOT NULL,
KEY_ANALIZED_BY INTEGER,
KEY_EXECUTION_PERIOD INTEGER NOT NULL,
JUSTIFICATION VARCHAR(255) NOT NULL,
REGIME VARCHAR(50),
NAME text,
PROGRAM text,
EVALUATION_METHOD text,
OBJECTIVES text,
NAME_EN text,
PROGRAM_EN text,
EVALUATION_METHOD_EN text,
OBJECTIVES_EN text,
COMPETENCE_COURSE_LEVEL varchar(100),
APPROVED tinyint(1),
THEORETICAL_HOURS DOUBLE,
PROBLEMS_HOURS DOUBLE,
LABORATORIAL_HOURS DOUBLE,
SEMINARY_HOURS DOUBLE,
FIELD_WORK_HOURS DOUBLE,
TRAINING_PERIOD_HOURS DOUBLE,
TUTORIAL_ORIENTATION_HOURS DOUBLE,
AUTONOMOUS_WORK_HOURS DOUBLE,
ECTS_CREDITS DOUBLE,
SECOND_THEORETICAL_HOURS DOUBLE,
SECOND_PROBLEMS_HOURS DOUBLE,
SECOND_LABORATORIAL_HOURS DOUBLE,
SECOND_SEMINARY_HOURS DOUBLE,
SECOND_FIELD_WORK_HOURS DOUBLE,
SECOND_TRAINING_PERIOD_HOURS DOUBLE,
SECOND_TUTORIAL_ORIENTATION_HOURS DOUBLE,
SECOND_AUTONOMOUS_WORK_HOURS DOUBLE,
SECOND_ECTS_CREDITS DOUBLE,
BIBLIOGRAPHIC_REFERENCES LONGTEXT,
PRIMARY KEY (ID_INTERNAL),
KEY KEY_PERSON (KEY_ROOT_DOMAIN_OBJECT),
KEY KEY_COMPETENCE_COURSE (KEY_COMPETENCE_COURSE),
KEY KEY_REQUESTER (KEY_REQUESTER),
KEY KEY_ANALIZED_BY (KEY_ANALIZED_BY),
KEY KEY_EXECUTION_PERIOD (KEY_EXECUTION_PERIOD)
);

