CREATE TABLE `AVERAGE_RULE` (
  `ID_INTERNAL` int(11) NOT NULL auto_increment,
  `OJB_CONCRETE_CLASS` varchar(250) NOT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) NOT NULL default 1,
  `KEY_EXECUTION_YEAR` int(11) NOT NULL,
  `KEY_DEGREE_CURRICULAR_PLAN` int(11) NOT NULL,
  `CREATION_ENTITY` text,
  `CREATION_ENTITY_DATE` date default NULL,
  `UPDATE_ENTITY` text,
  `UPDATE_ENTITY_DATE` datetime default NULL,
  PRIMARY KEY  (`ID_INTERNAL`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_EXECUTION_YEAR` (`KEY_EXECUTION_YEAR`),
  KEY `KEY_DEGREE_CURRICULAR_PLAN` (`KEY_DEGREE_CURRICULAR_PLAN`)
) TYPE=InnoDB; 
