
alter table INQUIRY_RESPONSE_PERIOD add column TYPE text;
update INQUIRY_RESPONSE_PERIOD set TYPE = 'STUDENT';

create table TEACHING_INQUIRY (
  `ACTIVE_AND_INTERESSED_STUDENTS_RATIO` int(11),
  `ANSWER_DURATION` bigint(20),
  `CLASSES_AND_OTHER_ACTIVITIES_FREQUENCY` int(11),
  `CLASSES_AND_OTHER_ACTIVITIES_PONCTUALITY` int(11),
  `COMPREHENSION_AND_KNOWLEDGE_OF_C_U` int(11),
  `COMPREHENSION_APPLICATION_OF_C_U` int(11),
  `COOPERATION_AND_COMMUNICATION_CAPACITY` int(11),
  `CRITICAL_SENSE_AND_REFLEXIVE_SPIRIT` int(11),
  `DISTURBING_EVENTS_IN_CLASSES` int(11),
  `DISTURBING_EVENTS_IN_CLASSES_DESCRIPTION` text,
  `ESTABLISHED_SCHEDULE_NOT_SUITABLE_REASON` text,
  `ESTABLISHED_SCHEDULE_SUITABLE` int(11),
  `EVALUATION_METHOD_SUITABLE_FOR_C_U_TEACHING_TYPE_AND_OBJECTIVE` int(11),
  `FINAL_COMMENTS_AND_IMPROOVEMENTS` text,
  `GLOBAL_CLASSIFICATION_OF_THIS_U_C` int(11),
  `GLOBAL_QUALITY_OF_TEACHING_IN_C_U` int(11),
  `ID_INTERNAL` int(11) NOT NULL auto_increment,
  `KEY_EXECUTION_DEGREE` int(11),
  `KEY_PROFESSORSHIP` int(11),
  `KEY_ROOT_DOMAIN_OBJECT` int(11),
  `LABS_CLASSES_ATTENDS_OSCILLATION` int(11),
  `LOAD_AND_CLASS_TYPE_CONTRIBUTION_TO_FULLFILMENT_OF_C_U_PROGRAM` int(11),
  `NEGATIVE_RESULTS_RESOLUTION_AND_IMPROOVEMENT_PLAN_OF_ACTION` text,
  `NUMBER_OF_ELECTRONIC_QUIZZES` int(11),
  `NUMBER_OF_EXAMS` int(11),
  `NUMBER_OF_QUIZZES_AND_MINI_TESTS` int(11),
  `NUMBER_OF_STUDY_VISITS_OR_OTHER_ACTIVITIES_REPORTS` int(11),
  `NUMBER_OF_TESTS` int(11),
  `NUMBER_OF_WORKS_OR_PROJECTS` int(11),
  `PEDAGOGICAL_ACTIVITIES_DEVELOPED` int(11),
  `POSITION_OF_C_U_IN_STUDENT_CURRICULAR_PLAN` int(11),
  `PROBLEMS_CLASSES_ATTENDS_OSCILLATION` int(11),
  `PROJECT_CLASSES_ATTENDS_OSCILLATION` int(11),
  `RELATIVE_PEDAGOGICAL_INITIATIVES` text,
  `RESPONSE_DATE_TIME` timestamp NULL default NULL,
  `SEMINAR_CLASSES_ATTENDS_OSCILLATION` int(11),
  `STUDENTS_PERFORMANCE` int(11),
  `STUDENTS_READY_FOR_FOLLOWING_C_U` int(11),
  `TEACHER_NUMBER_SUITABLE_FOR_C_U_OPERATION` int(11),
  `THEORICAL_CLASSES_ATTENDS_OSCILLATION` int(11),
  `WEAK_AND_STRONG_POINTS_OF_U_C_TEACHING_PROCESS` text,
  `WORK_LOAD_CLASSIFICATION` int(11),
  `WORK_LOAD_CLASSIFICATION_REASONS` text,
  primary key (ID_INTERNAL),
  index (KEY_EXECUTION_DEGREE),
  index (KEY_PROFESSORSHIP),
  index (KEY_ROOT_DOMAIN_OBJECT)
) type=InnoDB ;

create table STUDENT_INQUIRIES_TEACHING_RESULT (
  `ID_INTERNAL` int(11) NOT NULL auto_increment,
  `KEY_EXECUTION_DEGREE` int(11),
  `KEY_PROFESSORSHIP` int(11),
  `KEY_ROOT_DOMAIN_OBJECT` int(11),
  primary key (ID_INTERNAL),
  index (KEY_EXECUTION_DEGREE),
  index (KEY_PROFESSORSHIP),
  index (KEY_ROOT_DOMAIN_OBJECT)
) type=InnoDB ;

