CREATE TABLE `TEACHER_STATISTICS` (
	ID_INTERNAL INT(11) NOT NULL,
	REGIME_TYPE VARCHAR(50),
	PERCENTAGE DOUBLE,
	OBSERVATION_TYPE TEXT,
	IS_SPECIAL_ORIENTATION TINYINT(1) DEFAULT 0,
	IS_SPECIAL_POSITION TINYINT(1) DEFAULT 0,
	START_DATE DATE,
	END_DATE DATE,
	KEY_TEACHER INT(11) NOT NULL,
	KEY_ROOT_DOMAIN_OBJECT INT(11) DEFAULT 1,
	CREATION_ENTITY TEXT,
	CREATION_ENTITY_DATE DATE,
	UPDATE_ENTITY TEXT,
	UPDATE_ENTITY_DATE DATETIME,
	PRIMARY KEY(`ID_INTERNAL`),  
	KEY(`KEY_TEACHER`),
	KEY(`KEY_ROOT_DOMAIN_OBJECT`)
)ENGINE=InnoDB DEFAULT CHARSET=latin1;