CREATE TABLE TEACHER_PERSONAL_EXPECTATION (
	ID_INTERNAL int(11) NOT NULL auto_increment,
	ACK_OPT_LOCK int(11) default NULL,
	EDUCATION_MAIN_FOCUS text,
	GRADUATIONS int(3) NOT NULL,
	GRADUATIONS_DESCRIPTION text,
	CIENTIFIC_POS_GRADUATIONS int(3) NOT NULL,
	CIENTIFIC_POS_GRADUATIONS_DESCRIPTION text,
	PROFESSIONAL_POS_GRADUATIONS int(3) NOT NULL,
	PROFESSIONAL_POS_GRADUATIONS_DESCRIPTION text,
	SEMINARIES int(3) NOT NULL,
	SEMINARIES_DESCRIPTION text,
	ORIENTATIONS_MAIN_FOCUS text,
	RESEARCH_AND_DEV_MAIN_FOCUS text,
	RESEARCH_AND_DEV_PROJECTS int(3) NOT NULL,
	JORNAL_ARTICLE_PUBLICATIONS int(3) NOT NULL,
	BOOK_PUBLICATIONS int(3) NOT NULL,
	CONFERENCE_PUBLICATIONS int(3) NOT NULL,
	TECHNICAL_REPORT_PUBLICATIONS int(3) NOT NULL,
	PATENT_PUBLICATIONS int(3) NOT NULL,
	OTHER_PUBLICATIONS int(3) NOT NULL,
	OTHER_PUBLICATIONS_DESCRIPTION text,
	PHD_ORIENTATIONS int(3) NOT NULL,
	MASTER_DEGREE_ORIENTATIONS int(3) NOT NULL,
	FINAL_DEGREE_WORK_ORIENTATIONS int(3) NOT NULL,
	UNIVERSITY_SERVICE_MAIN_FOCUS text,
	DEPARTMENT_ORGANS varchar(250),
	IST_ORGANS varchar(250),
	UTL_ORGANS varchar(250),
	PROFESSIONAL_ACTIVITY_MAIN_FOCUS text,
	CIENTIFIC_COMUNITY_SERVICE varchar(250),
	SOCIETY_SERVICE varchar(250),
	CONSULTING varchar(250),
	COMPANY_SOCIAL_ORGANS varchar(250),
	COMPANY_POSITIONS varchar(250),
	TUTOR_COMMENT text,
	KEY_TEACHER int(11) NOT NULL,
	KEY_EXECUTION_YEAR int(11) NOT NULL,
	PRIMARY KEY (ID_INTERNAL),
	UNIQUE U1 (KEY_TEACHER,KEY_EXECUTION_YEAR)
) Type=InnoDB;
