-- Table structure for table `CONTEXT`
--

CREATE TABLE `CONTEXT` (
  `CHILD_ORDER` int(11) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_BEGIN_EXECUTION_PERIOD` int(11) DEFAULT NULL,
  `KEY_CHILD_DEGREE_MODULE` int(11) DEFAULT NULL,
  `KEY_CURRICULAR_PERIOD` int(11) DEFAULT NULL,
  `KEY_END_EXECUTION_PERIOD` int(11) DEFAULT NULL,
  `KEY_PARENT_COURSE_GROUP` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_BEGIN_EXECUTION_PERIOD` bigint(20) DEFAULT NULL,
  `OID_CHILD_DEGREE_MODULE` bigint(20) DEFAULT NULL,
  `OID_CURRICULAR_PERIOD` bigint(20) DEFAULT NULL,
  `OID_END_EXECUTION_PERIOD` bigint(20) DEFAULT NULL,
  `OID_PARENT_COURSE_GROUP` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_BEGIN_EXECUTION_PERIOD` (`KEY_BEGIN_EXECUTION_PERIOD`),
  KEY `OID_BEGIN_EXECUTION_PERIOD` (`OID_BEGIN_EXECUTION_PERIOD`),
  KEY `KEY_CHILD_DEGREE_MODULE` (`KEY_CHILD_DEGREE_MODULE`),
  KEY `OID_CHILD_DEGREE_MODULE` (`OID_CHILD_DEGREE_MODULE`),
  KEY `KEY_CURRICULAR_PERIOD` (`KEY_CURRICULAR_PERIOD`),
  KEY `OID_CURRICULAR_PERIOD` (`OID_CURRICULAR_PERIOD`),
  KEY `KEY_END_EXECUTION_PERIOD` (`KEY_END_EXECUTION_PERIOD`),
  KEY `OID_END_EXECUTION_PERIOD` (`OID_END_EXECUTION_PERIOD`),
  KEY `KEY_PARENT_COURSE_GROUP` (`KEY_PARENT_COURSE_GROUP`),
  KEY `OID_PARENT_COURSE_GROUP` (`OID_PARENT_COURSE_GROUP`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CONTEXT`
--


--
-- Table structure for table `CONTRACT_SITUATION`
--

CREATE TABLE `CONTRACT_SITUATION` (
  `END_SITUATION` tinyint(1) DEFAULT NULL,
  `GIAF_ID` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `NAME` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CONTRACT_SITUATION`
--


--
-- Table structure for table `CONTRIBUTOR`
--

CREATE TABLE `CONTRIBUTOR` (
  `CONTRIBUTOR_ADDRESS` longtext,
  `CONTRIBUTOR_NAME` longtext,
  `CONTRIBUTOR_NUMBER` int(11) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CONTRIBUTOR`
--


--
-- Table structure for table `COOPERATION`
--

CREATE TABLE `COOPERATION` (
  `COOPERATION_TYPE` text,
  `END_DATE` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_UNIT` int(11) DEFAULT NULL,
  `NAME` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_UNIT` bigint(20) DEFAULT NULL,
  `START_DATE` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_UNIT` (`KEY_UNIT`),
  KEY `OID_UNIT` (`OID_UNIT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COOPERATION`
--


--
-- Table structure for table `COORDINATOR`
--

CREATE TABLE `COORDINATOR` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EXECUTION_DEGREE` int(11) DEFAULT NULL,
  `KEY_PERSON` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_DEGREE` bigint(20) DEFAULT NULL,
  `OID_PERSON` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `RESPONSIBLE` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXECUTION_DEGREE` (`KEY_EXECUTION_DEGREE`),
  KEY `OID_EXECUTION_DEGREE` (`OID_EXECUTION_DEGREE`),
  KEY `KEY_PERSON` (`KEY_PERSON`),
  KEY `OID_PERSON` (`OID_PERSON`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COORDINATOR`
--


--
-- Table structure for table `COORDINATOR_EXECUTION_DEGREE_COURSES_REPORT`
--

CREATE TABLE `COORDINATOR_EXECUTION_DEGREE_COURSES_REPORT` (
  `BOLONHA_PROCESS_IMPLEMENTATION_REFLECTION` longtext,
  `GLOBAL_COMMENT` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_COORDINATOR` int(11) DEFAULT NULL,
  `KEY_EXECUTION_DEGREE` int(11) DEFAULT NULL,
  `KEY_EXECUTION_INTERVAL` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `LAST_EDITION_DATE` timestamp NULL DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_COORDINATOR` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_DEGREE` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_INTERVAL` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `STEPS_TO_IMPROVE_RESULTS` longtext,
  `TEACHING_BEST_PRACTICES_DEVELOPED_BY_TEACHERS` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_COORDINATOR` (`KEY_COORDINATOR`),
  KEY `OID_COORDINATOR` (`OID_COORDINATOR`),
  KEY `KEY_EXECUTION_DEGREE` (`KEY_EXECUTION_DEGREE`),
  KEY `OID_EXECUTION_DEGREE` (`OID_EXECUTION_DEGREE`),
  KEY `KEY_EXECUTION_INTERVAL` (`KEY_EXECUTION_INTERVAL`),
  KEY `OID_EXECUTION_INTERVAL` (`OID_EXECUTION_INTERVAL`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COORDINATOR_EXECUTION_DEGREE_COURSES_REPORT`
--


--
-- Table structure for table `COST_CENTER`
--

CREATE TABLE `COST_CENTER` (
  `CODE` longtext,
  `DEPARTAMENT` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `SECTION1` longtext,
  `SECTION2` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COST_CENTER`
--


--
-- Table structure for table `COUNTRY`
--

CREATE TABLE `COUNTRY` (
  `CODE` longtext,
  `COUNTRY_NATIONALITY` longtext,
  `DEFAULT_COUNTRY` tinyint(1) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `LOCALIZED_NAME` longtext,
  `NAME` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `THREE_LETTER_CODE` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB AUTO_INCREMENT=288 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COUNTRY`
--

INSERT INTO `COUNTRY` VALUES ('pt','pt10:Portuguesa',1,201,1,NULL,'Portugal',1859720839369,2551210573825,NULL),('ao','pt8:Angolana',0,202,1,NULL,'Angola',1859720839370,2551210573825,NULL),('cv','pt13:Cabo-Verdiana',0,203,1,NULL,'Cabo Verde',1859720839371,2551210573825,NULL),('gw','pt16:Guineense-Bissau',0,204,1,NULL,'Guiné-Bissau',1859720839372,2551210573825,NULL),('mz','pt11:Moçambicana',0,205,1,NULL,'Moçambique',1859720839373,2551210573825,NULL),('st','pt11:São Tomense',0,206,1,NULL,'São Tomé e Principe',1859720839374,2551210573825,NULL),('br','pt10:Brasileira',0,207,1,NULL,'Brasil',1859720839375,2551210573825,NULL),('be','pt5:Belga',0,208,1,NULL,'Bélgica',1859720839376,2551210573825,NULL),('es','pt9:Espanhola',0,209,1,NULL,'Espanha',1859720839377,2551210573825,NULL),('fr','pt8:Francesa',0,210,1,NULL,'França',1859720839378,2551210573825,NULL),('nl','pt9:Holandesa',0,211,1,NULL,'Holanda',1859720839379,2551210573825,NULL),('ie','pt9:Irlandesa',0,212,1,NULL,'Irlanda',1859720839380,2551210573825,NULL),('it','pt8:Italiana',0,213,1,NULL,'Itália',1859720839381,2551210573825,NULL),('lu','pt13:Luxemburguesa',0,214,1,NULL,'Luxemburgo',1859720839382,2551210573825,NULL),('de','pt5:Alemã',0,215,1,NULL,'Alemanha',1859720839383,2551210573825,NULL),('uk','pt9:Britânica',0,216,1,NULL,'Reino Unido',1859720839384,2551210573825,NULL),('gr','pt5:Grega',0,217,1,NULL,'Grécia',1859720839385,2551210573825,NULL),('fi','pt10:Finlandesa',0,218,1,NULL,'Finlândia',1859720839386,2551210573825,NULL),('at','pt9:Austríaca',0,219,1,NULL,'Ãustria',1859720839387,2551210573825,NULL),('no','pt10:Norueguesa',0,220,1,NULL,'Noruega',1859720839388,2551210573825,NULL),('se','pt5:Sueca',0,221,1,NULL,'Suécia',1859720839389,2551210573825,NULL),('pl','pt6:Polaca',0,222,1,NULL,'Polónia',1859720839390,2551210573825,NULL),('ru','pt5:Russa',0,223,1,NULL,'RÃºssia',1859720839391,2551210573825,NULL),('ro','pt6:Romena',0,224,1,NULL,'Roménia',1859720839392,2551210573825,NULL),('ch','pt5:Suiça',0,225,1,NULL,'Suiça',1859720839393,2551210573825,NULL),('za','pt12:Sul-Africana',0,226,1,NULL,'Ãfrica do Sul',1859720839394,2551210573825,NULL),('ma','pt10:Marroquina',0,227,1,NULL,'Marrocos',1859720839395,2551210573825,NULL),('zr','pt8:Zairense',0,228,1,NULL,'Républica do Zaire',1859720839396,2551210573825,NULL),('ke','pt8:Queniana',0,229,1,NULL,'Quénia',1859720839397,2551210573825,NULL),('ly','pt5:Líbia',0,230,1,NULL,'Líbia',1859720839398,2551210573825,NULL),('zw','pt8:Zimbabué',0,231,1,NULL,'Zimbabué',1859720839399,2551210573825,NULL),('ps','pt9:Palestina',0,232,1,NULL,'Palestina',1859720839400,2551210573825,NULL),('ir','pt8:Iraniana',0,233,1,NULL,'Irão',1859720839401,2551210573825,NULL),('pk','pt12:Paquistanesa',0,234,1,NULL,'Paquistão',1859720839402,2551210573825,NULL),('au','pt11:Australiana',0,235,1,NULL,'Austrália',1859720839403,2551210573825,NULL),('us','pt15:Norte Americana',0,236,1,NULL,'Estados Unidos da América',1859720839404,2551210573825,NULL),('py','pt9:Paraguaia',0,237,1,NULL,'Paraguai',1859720839405,2551210573825,NULL),('ca','pt9:Canadiana',0,238,1,NULL,'Canadá',1859720839406,2551210573825,NULL),('ar','pt9:Argentina',0,239,1,NULL,'Argentina',1859720839407,2551210573825,NULL),('cl','pt7:Chilena',0,240,1,NULL,'Chile',1859720839408,2551210573825,NULL),('ec','pt11:Equatoriana',0,241,1,NULL,'Equador',1859720839409,2551210573825,NULL),('ve','pt11:Venezuelana',0,242,1,NULL,'Venezuela',1859720839410,2551210573825,NULL),('mx','pt8:Mexicana',0,243,1,NULL,'México',1859720839411,2551210573825,NULL),('bg','pt7:Bulgara',0,244,1,NULL,'Bulgária',1859720839412,2551210573825,NULL),('co','pt10:Colombiana',0,245,1,NULL,'Colombia',1859720839413,2551210573825,NULL),('sk','pt8:Eslovaca',0,246,1,NULL,'Eslováquia',1859720839414,2551210573825,NULL),('cn','pt7:Chinesa',0,247,1,NULL,'China',1859720839415,2551210573825,NULL),('tp','pt9:Timorense',0,248,1,NULL,'Timor Loro Sae',1859720839416,2551210573825,NULL),('dk','pt12:Dinamarquesa',0,249,1,NULL,'Dinamarca',1859720839417,2551210573825,NULL),('iq','pt9:Iraquiana',0,250,1,NULL,'Iraque',1859720839418,2551210573825,NULL),('pe','pt7:Peruana',0,251,1,NULL,'PerÃº',1859720839419,2551210573825,NULL),('cz','pt5:Checa',0,252,1,NULL,'RepÃºblica Checa',1859720839420,2551210573825,NULL),('tk','pt5:Turca',0,253,1,NULL,'Turquia',1859720839421,2551210573825,NULL),('cs','pt19:Sérvia e Montenegro',0,254,1,NULL,'Sérvia e Montenegro',1859720839422,2551210573825,NULL),('yu','pt9:Jugoslava',0,255,1,NULL,'Jugoslávia',1859720839423,2551210573825,NULL),('in','pt7:Indiana',0,256,1,NULL,'Ãndia',1859720839424,2551210573825,NULL),('ua','pt9:Ucraniana',0,257,1,NULL,'Ucrânia',1859720839425,2551210573825,NULL),('si','pt8:Eslovena',0,258,1,NULL,'Eslovénia',1859720839426,2551210573825,NULL),('vn','pt10:Vietnamita',0,259,1,NULL,'Vietname',1859720839427,2551210573825,NULL),('ee','pt7:Estónia',0,260,1,NULL,'Estónia',1859720839428,2551210573825,NULL),('sn','pt10:Senegalesa',0,261,1,NULL,'Senegal',1859720839429,2551210573825,NULL),('sg','pt9:Singapura',0,262,1,NULL,'Singapura',1859720839430,2551210573825,NULL),('th','pt10:Tailandesa',0,263,1,NULL,'Tailândia',1859720839431,2551210573825,NULL),('bw','pt8:Botswana',0,264,1,NULL,'Botswana',1859720839432,2551210573825,NULL),('bo','pt9:Boliviana',0,265,1,NULL,'Bolívia',1859720839433,2551210573825,NULL),('tn','pt8:Tunisina',0,266,1,NULL,'Tunísia',1859720839434,2551210573825,NULL),('kw','pt6:Kuwait',0,267,1,NULL,'Kuwait',1859720839435,2551210573825,NULL),('cr','pt13:Costariquenho',0,268,1,NULL,'Costa Rica',1859720839436,2551210573825,NULL),('id','pt9:Indonésia',0,269,1,NULL,'Indonésia',1859720839437,2551210573825,NULL),('jp','pt8:Japonesa',0,270,1,NULL,'Japão',1859720839438,2551210573825,NULL),('il','pt9:Israelita',0,271,1,NULL,'Israel',1859720839439,2551210573825,NULL),('gp','pt12:Guatemalteco',0,272,1,NULL,'Guatemala',1859720839440,2551210573825,NULL),('eg','pt7:Egípcia',0,273,1,NULL,'Egipto',1859720839441,2551210573825,NULL),('hu','pt7:Hungara',0,274,1,NULL,'HÃºngria',1859720839442,2551210573825,NULL),('hr','pt6:Croata',0,275,1,NULL,'Croácia',1859720839443,2551210573825,NULL),('mu','pt9:Maurícias',0,276,1,NULL,'Maurícias',1859720839444,2551210573825,NULL),('mt','pt6:Maltês',0,277,1,NULL,'Malta',1859720839445,2551210573825,NULL),('pr','pt13:Portoriquenha',0,278,1,NULL,'Porto Rico',1859720839446,2551210573825,NULL),('cy','pt8:Cipriota',0,279,1,NULL,'Chipre',1859720839447,2551210573825,NULL),('lt','pt7:Lituana',0,280,1,NULL,'Lituânia',1859720839448,2551210573825,NULL),('lv','pt7:Letónia',0,281,1,NULL,'Letónia',1859720839449,2551210573825,NULL),('my','pt6:Malaia',0,282,1,NULL,'Malásia',1859720839450,2551210573825,NULL),('mc','pt8:Macaense',0,283,1,NULL,'Macau',1859720839451,2551210573825,NULL),('mk','pt9:Macedónia',0,284,1,NULL,'Macedónia',1859720839452,2551210573825,NULL),('kr','pt7:Coreana',0,285,1,NULL,'Coreia do Sul',1859720839453,2551210573825,NULL),('mr','pt10:Mauritânia',0,286,1,NULL,'Mauritânia',1859720839454,2551210573825,NULL),('hk','pt9:Hong Kong',0,287,1,NULL,'Hong Kong',1859720839455,2551210573825,NULL);

--
-- Table structure for table `COURSE_EQUIVALENCY`
--

CREATE TABLE `COURSE_EQUIVALENCY` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_CURRICULAR_COURSE` int(11) DEFAULT NULL,
  `KEY_MODALITY` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_SEMINARY` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_CURRICULAR_COURSE` bigint(20) DEFAULT NULL,
  `OID_MODALITY` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_SEMINARY` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_CURRICULAR_COURSE` (`KEY_CURRICULAR_COURSE`),
  KEY `OID_CURRICULAR_COURSE` (`OID_CURRICULAR_COURSE`),
  KEY `KEY_MODALITY` (`KEY_MODALITY`),
  KEY `OID_MODALITY` (`OID_MODALITY`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_SEMINARY` (`KEY_SEMINARY`),
  KEY `OID_SEMINARY` (`OID_SEMINARY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COURSE_EQUIVALENCY`
--


--
-- Table structure for table `COURSE_EQUIVALENCY_THEME`
--

CREATE TABLE `COURSE_EQUIVALENCY_THEME` (
  `KEY_COURSE_EQUIVALENCY` int(11) NOT NULL,
  `KEY_THEME` int(11) NOT NULL,
  `OID_COURSE_EQUIVALENCY` bigint(20) unsigned DEFAULT NULL,
  `OID_THEME` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_COURSE_EQUIVALENCY`,`KEY_THEME`),
  KEY `KEY_COURSE_EQUIVALENCY` (`KEY_COURSE_EQUIVALENCY`),
  KEY `KEY_THEME` (`KEY_THEME`),
  KEY `OID_COURSE_EQUIVALENCY` (`OID_COURSE_EQUIVALENCY`,`OID_THEME`),
  KEY `OID_COURSE_EQUIVALENCY_2` (`OID_COURSE_EQUIVALENCY`),
  KEY `OID_THEME` (`OID_THEME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COURSE_EQUIVALENCY_THEME`
--


--
-- Table structure for table `COURSE_HISTORIC`
--

CREATE TABLE `COURSE_HISTORIC` (
  `APPROVED` int(11) DEFAULT NULL,
  `CURRICULAR_YEAR` longtext,
  `ENROLLED` int(11) DEFAULT NULL,
  `EVALUATED` int(11) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_CURRICULAR_COURSE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_CURRICULAR_COURSE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `SEMESTER` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_CURRICULAR_COURSE` (`KEY_CURRICULAR_COURSE`),
  KEY `OID_CURRICULAR_COURSE` (`OID_CURRICULAR_COURSE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COURSE_HISTORIC`
--


--
-- Table structure for table `COURSE_LOAD`
--

CREATE TABLE `COURSE_LOAD` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EXECUTION_COURSE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_COURSE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `TOTAL_QUANTITY` longtext,
  `TYPE` text,
  `UNIT_QUANTITY` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXECUTION_COURSE` (`KEY_EXECUTION_COURSE`),
  KEY `OID_EXECUTION_COURSE` (`OID_EXECUTION_COURSE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COURSE_LOAD`
--


--
-- Table structure for table `COURSE_LOAD_REQUEST_ENROLMENT`
--

CREATE TABLE `COURSE_LOAD_REQUEST_ENROLMENT` (
  `KEY_COURSE_LOAD_REQUEST` int(11) NOT NULL,
  `KEY_ENROLMENT` int(11) NOT NULL,
  `OID_COURSE_LOAD_REQUEST` bigint(20) unsigned DEFAULT NULL,
  `OID_ENROLMENT` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_COURSE_LOAD_REQUEST`,`KEY_ENROLMENT`),
  KEY `KEY_COURSE_LOAD_REQUEST` (`KEY_COURSE_LOAD_REQUEST`),
  KEY `KEY_ENROLMENT` (`KEY_ENROLMENT`),
  KEY `OID_COURSE_LOAD_REQUEST` (`OID_COURSE_LOAD_REQUEST`,`OID_ENROLMENT`),
  KEY `OID_COURSE_LOAD_REQUEST_2` (`OID_COURSE_LOAD_REQUEST`),
  KEY `OID_ENROLMENT` (`OID_ENROLMENT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COURSE_LOAD_REQUEST_ENROLMENT`
--


--
-- Table structure for table `COURSE_LOAD_SHIFT`
--

CREATE TABLE `COURSE_LOAD_SHIFT` (
  `KEY_COURSE_LOAD` int(11) NOT NULL,
  `KEY_SHIFT` int(11) NOT NULL,
  `OID_COURSE_LOAD` bigint(20) unsigned DEFAULT NULL,
  `OID_SHIFT` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_COURSE_LOAD`,`KEY_SHIFT`),
  KEY `KEY_COURSE_LOAD` (`KEY_COURSE_LOAD`),
  KEY `KEY_SHIFT` (`KEY_SHIFT`),
  KEY `OID_COURSE_LOAD` (`OID_COURSE_LOAD`,`OID_SHIFT`),
  KEY `OID_COURSE_LOAD_2` (`OID_COURSE_LOAD`),
  KEY `OID_SHIFT` (`OID_SHIFT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COURSE_LOAD_SHIFT`
--


--
-- Table structure for table `COURSE_REPORT`
--

CREATE TABLE `COURSE_REPORT` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EXECUTION_COURSE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `LAST_MODIFICATION_DATE_DATE_TIME` timestamp NULL DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_COURSE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `REPORT` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXECUTION_COURSE` (`KEY_EXECUTION_COURSE`),
  KEY `OID_EXECUTION_COURSE` (`OID_EXECUTION_COURSE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COURSE_REPORT`
--


--
-- Table structure for table `CREDITS`
--

CREATE TABLE `CREDITS` (
  `GIVEN_CREDITS` double DEFAULT NULL,
  `GRADE` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EXECUTION_PERIOD` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_STUDENT_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_PERIOD` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_STUDENT_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXECUTION_PERIOD` (`KEY_EXECUTION_PERIOD`),
  KEY `OID_EXECUTION_PERIOD` (`OID_EXECUTION_PERIOD`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_STUDENT_CURRICULAR_PLAN` (`KEY_STUDENT_CURRICULAR_PLAN`),
  KEY `OID_STUDENT_CURRICULAR_PLAN` (`OID_STUDENT_CURRICULAR_PLAN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CREDITS`
--


--
-- Table structure for table `CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES`
--

CREATE TABLE `CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES` (
  `KEY_CURRICULAR_COURSE` int(11) NOT NULL,
  `KEY_CREDITS_DISMISSAL` int(11) NOT NULL,
  `OID_CURRICULAR_COURSE` bigint(20) unsigned DEFAULT NULL,
  `OID_CREDITS_DISMISSAL` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_CURRICULAR_COURSE`,`KEY_CREDITS_DISMISSAL`),
  KEY `KEY_CURRICULAR_COURSE` (`KEY_CURRICULAR_COURSE`),
  KEY `KEY_CREDITS_DISMISSAL` (`KEY_CREDITS_DISMISSAL`),
  KEY `OID_CURRICULAR_COURSE` (`OID_CURRICULAR_COURSE`,`OID_CREDITS_DISMISSAL`),
  KEY `OID_CURRICULAR_COURSE_2` (`OID_CURRICULAR_COURSE`),
  KEY `OID_CREDITS_DISMISSAL` (`OID_CREDITS_DISMISSAL`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES`
--


--
-- Table structure for table `CREDITS_IN_ANY_SECUNDARY_AREA`
--

CREATE TABLE `CREDITS_IN_ANY_SECUNDARY_AREA` (
  `GIVEN_CREDITS` int(11) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ENROLMENT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_STUDENT_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ENROLMENT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_STUDENT_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ENROLMENT` (`KEY_ENROLMENT`),
  KEY `OID_ENROLMENT` (`OID_ENROLMENT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_STUDENT_CURRICULAR_PLAN` (`KEY_STUDENT_CURRICULAR_PLAN`),
  KEY `OID_STUDENT_CURRICULAR_PLAN` (`OID_STUDENT_CURRICULAR_PLAN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CREDITS_IN_ANY_SECUNDARY_AREA`
--


--
-- Table structure for table `CREDITS_IN_SCIENTIFIC_AREA`
--

CREATE TABLE `CREDITS_IN_SCIENTIFIC_AREA` (
  `GIVEN_CREDITS` int(11) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ENROLMENT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_SCIENTIFIC_AREA` int(11) DEFAULT NULL,
  `KEY_STUDENT_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ENROLMENT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_SCIENTIFIC_AREA` bigint(20) DEFAULT NULL,
  `OID_STUDENT_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ENROLMENT` (`KEY_ENROLMENT`),
  KEY `OID_ENROLMENT` (`OID_ENROLMENT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_SCIENTIFIC_AREA` (`KEY_SCIENTIFIC_AREA`),
  KEY `OID_SCIENTIFIC_AREA` (`OID_SCIENTIFIC_AREA`),
  KEY `KEY_STUDENT_CURRICULAR_PLAN` (`KEY_STUDENT_CURRICULAR_PLAN`),
  KEY `OID_STUDENT_CURRICULAR_PLAN` (`OID_STUDENT_CURRICULAR_PLAN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CREDITS_IN_SCIENTIFIC_AREA`
--


--
-- Table structure for table `CREDIT_LINE`
--

CREATE TABLE `CREDIT_LINE` (
  `CREDITS` double DEFAULT NULL,
  `END` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EXECUTION_PERIOD` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_TEACHER` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_PERIOD` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_TEACHER` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `POSITION` longtext,
  `REASON` longtext,
  `START` text,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXECUTION_PERIOD` (`KEY_EXECUTION_PERIOD`),
  KEY `OID_EXECUTION_PERIOD` (`OID_EXECUTION_PERIOD`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_TEACHER` (`KEY_TEACHER`),
  KEY `OID_TEACHER` (`OID_TEACHER`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CREDIT_LINE`
--


--
-- Table structure for table `CREDIT_NOTE`
--

CREATE TABLE `CREDIT_NOTE` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_RECEIPT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `NUMBER` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_RECEIPT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `STATE` text,
  `WHEN_CREATED` timestamp NULL DEFAULT NULL,
  `WHEN_UPDATED` timestamp NULL DEFAULT NULL,
  `YEAR` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EMPLOYEE` (`KEY_EMPLOYEE`),
  KEY `OID_EMPLOYEE` (`OID_EMPLOYEE`),
  KEY `KEY_RECEIPT` (`KEY_RECEIPT`),
  KEY `OID_RECEIPT` (`OID_RECEIPT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CREDIT_NOTE`
--


--
-- Table structure for table `CREDIT_NOTE_ENTRY`
--

CREATE TABLE `CREDIT_NOTE_ENTRY` (
  `AMOUNT` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ACCOUNTING_ENTRY` int(11) DEFAULT NULL,
  `KEY_ADJUSTMENT_ACCOUNTING_ENTRY` int(11) DEFAULT NULL,
  `KEY_CREDIT_NOTE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ACCOUNTING_ENTRY` bigint(20) DEFAULT NULL,
  `OID_ADJUSTMENT_ACCOUNTING_ENTRY` bigint(20) DEFAULT NULL,
  `OID_CREDIT_NOTE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ACCOUNTING_ENTRY` (`KEY_ACCOUNTING_ENTRY`),
  KEY `OID_ACCOUNTING_ENTRY` (`OID_ACCOUNTING_ENTRY`),
  KEY `KEY_ADJUSTMENT_ACCOUNTING_ENTRY` (`KEY_ADJUSTMENT_ACCOUNTING_ENTRY`),
  KEY `OID_ADJUSTMENT_ACCOUNTING_ENTRY` (`OID_ADJUSTMENT_ACCOUNTING_ENTRY`),
  KEY `KEY_CREDIT_NOTE` (`KEY_CREDIT_NOTE`),
  KEY `OID_CREDIT_NOTE` (`OID_CREDIT_NOTE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CREDIT_NOTE_ENTRY`
--


--
-- Table structure for table `CRON_REGISTRY`
--

CREATE TABLE `CRON_REGISTRY` (
  `BUILD_VERSION` timestamp NULL DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CRON_REGISTRY`
--


--
-- Table structure for table `CRON_SCRIPT_INVOCATION`
--

CREATE TABLE `CRON_SCRIPT_INVOCATION` (
  `END_TIME` timestamp NULL DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_CRON_SCRIPT_STATE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `LOG` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_CRON_SCRIPT_STATE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `SERVER_I_D` longtext,
  `START_TIME` timestamp NULL DEFAULT NULL,
  `SUCCESSFUL` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_CRON_SCRIPT_STATE` (`KEY_CRON_SCRIPT_STATE`),
  KEY `OID_CRON_SCRIPT_STATE` (`OID_CRON_SCRIPT_STATE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CRON_SCRIPT_INVOCATION`
--


--
-- Table structure for table `CRON_SCRIPT_STATE`
--

CREATE TABLE `CRON_SCRIPT_STATE` (
  `ABSOLUTE_EXECUTION_ORDER` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CONTEXT` longblob,
  `CRON_SCRIPT_CLASSNAME` longtext,
  `EMAILS` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `INVOCATION_PERIOD` longblob,
  `IS_CURRENTLY_RUNNING` tinyint(1) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `REGISTRATION_DATE` timestamp NULL DEFAULT NULL,
  `RUN_NOW` tinyint(1) DEFAULT NULL,
  `WHEN_TO_SEND_EMAIL` text,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CRON_SCRIPT_STATE`
--


--
-- Table structure for table `CURRICULAR_COURSE_EQUIVALENCE`
--

CREATE TABLE `CURRICULAR_COURSE_EQUIVALENCE` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DEGREE_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `KEY_EQUIVALENT_CURRICULAR_COURSE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DEGREE_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OID_EQUIVALENT_CURRICULAR_COURSE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DEGREE_CURRICULAR_PLAN` (`KEY_DEGREE_CURRICULAR_PLAN`),
  KEY `OID_DEGREE_CURRICULAR_PLAN` (`OID_DEGREE_CURRICULAR_PLAN`),
  KEY `KEY_EQUIVALENT_CURRICULAR_COURSE` (`KEY_EQUIVALENT_CURRICULAR_COURSE`),
  KEY `OID_EQUIVALENT_CURRICULAR_COURSE` (`OID_EQUIVALENT_CURRICULAR_COURSE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CURRICULAR_COURSE_EQUIVALENCE`
--


--
-- Table structure for table `CURRICULAR_COURSE_EXECUTION_COURSE`
--

CREATE TABLE `CURRICULAR_COURSE_EXECUTION_COURSE` (
  `KEY_CURRICULAR_COURSE` int(11) NOT NULL,
  `KEY_EXECUTION_COURSE` int(11) NOT NULL,
  `OID_CURRICULAR_COURSE` bigint(20) unsigned DEFAULT NULL,
  `OID_EXECUTION_COURSE` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_CURRICULAR_COURSE`,`KEY_EXECUTION_COURSE`),
  KEY `KEY_CURRICULAR_COURSE` (`KEY_CURRICULAR_COURSE`),
  KEY `KEY_EXECUTION_COURSE` (`KEY_EXECUTION_COURSE`),
  KEY `OID_CURRICULAR_COURSE` (`OID_CURRICULAR_COURSE`,`OID_EXECUTION_COURSE`),
  KEY `OID_CURRICULAR_COURSE_2` (`OID_CURRICULAR_COURSE`),
  KEY `OID_EXECUTION_COURSE` (`OID_EXECUTION_COURSE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CURRICULAR_COURSE_EXECUTION_COURSE`
--


--
-- Table structure for table `CURRICULAR_COURSE_SCOPE`
--

CREATE TABLE `CURRICULAR_COURSE_SCOPE` (
  `ANOTATION` longtext,
  `BEGIN_YEAR_MONTH_DAY` longtext,
  `END_YEAR_MONTH_DAY` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_BRANCH` int(11) DEFAULT NULL,
  `KEY_CURRICULAR_COURSE` int(11) DEFAULT NULL,
  `KEY_CURRICULAR_SEMESTER` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_BRANCH` bigint(20) DEFAULT NULL,
  `OID_CURRICULAR_COURSE` bigint(20) DEFAULT NULL,
  `OID_CURRICULAR_SEMESTER` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_BRANCH` (`KEY_BRANCH`),
  KEY `OID_BRANCH` (`OID_BRANCH`),
  KEY `KEY_CURRICULAR_COURSE` (`KEY_CURRICULAR_COURSE`),
  KEY `OID_CURRICULAR_COURSE` (`OID_CURRICULAR_COURSE`),
  KEY `KEY_CURRICULAR_SEMESTER` (`KEY_CURRICULAR_SEMESTER`),
  KEY `OID_CURRICULAR_SEMESTER` (`OID_CURRICULAR_SEMESTER`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CURRICULAR_COURSE_SCOPE`
--


--
-- Table structure for table `CURRICULAR_PERIOD`
--

CREATE TABLE `CURRICULAR_PERIOD` (
  `ACADEMIC_PERIOD` longtext,
  `CHILD_ORDER` int(11) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DEGREE_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `KEY_PARENT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DEGREE_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OID_PARENT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DEGREE_CURRICULAR_PLAN` (`KEY_DEGREE_CURRICULAR_PLAN`),
  KEY `OID_DEGREE_CURRICULAR_PLAN` (`OID_DEGREE_CURRICULAR_PLAN`),
  KEY `KEY_PARENT` (`KEY_PARENT`),
  KEY `OID_PARENT` (`OID_PARENT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CURRICULAR_PERIOD`
--


--
-- Table structure for table `CURRICULAR_RULE`
--

CREATE TABLE `CURRICULAR_RULE` (
  `ACADEMIC_PERIOD` longtext,
  `BOLONHA_DEGREE_TYPE` text,
  `COMPOSITE_RULE_TYPE` text,
  `CREDITS` double DEFAULT NULL,
  `CURRICULAR_PERIOD_ORDER` int(11) DEFAULT NULL,
  `CURRICULAR_RULE_TYPE` text,
  `EVEN` tinyint(1) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_BEGIN` int(11) DEFAULT NULL,
  `KEY_CONTEXT_COURSE_GROUP` int(11) DEFAULT NULL,
  `KEY_DEGREE` int(11) DEFAULT NULL,
  `KEY_DEGREE_MODULE_TO_APPLY_RULE` int(11) DEFAULT NULL,
  `KEY_DEPARTMENT_UNIT` int(11) DEFAULT NULL,
  `KEY_END` int(11) DEFAULT NULL,
  `KEY_EXCLUSIVE_DEGREE_MODULE` int(11) DEFAULT NULL,
  `KEY_NOT_RULE` int(11) DEFAULT NULL,
  `KEY_PARENT_COMPOSITE_RULE` int(11) DEFAULT NULL,
  `KEY_PRECEDENCE_DEGREE_MODULE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_WRAPPED_RULE` int(11) DEFAULT NULL,
  `MAXIMUM_CREDITS` double DEFAULT NULL,
  `MAXIMUM_LIMIT` int(11) DEFAULT NULL,
  `MAXIMUM_YEAR` int(11) DEFAULT NULL,
  `MINIMUM_CREDITS` double DEFAULT NULL,
  `MINIMUM_LIMIT` int(11) DEFAULT NULL,
  `MINIMUM_YEAR` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_BEGIN` bigint(20) DEFAULT NULL,
  `OID_CONTEXT_COURSE_GROUP` bigint(20) DEFAULT NULL,
  `OID_DEGREE` bigint(20) DEFAULT NULL,
  `OID_DEGREE_MODULE_TO_APPLY_RULE` bigint(20) DEFAULT NULL,
  `OID_DEPARTMENT_UNIT` bigint(20) DEFAULT NULL,
  `OID_END` bigint(20) DEFAULT NULL,
  `OID_EXCLUSIVE_DEGREE_MODULE` bigint(20) DEFAULT NULL,
  `OID_NOT_RULE` bigint(20) DEFAULT NULL,
  `OID_PARENT_COMPOSITE_RULE` bigint(20) DEFAULT NULL,
  `OID_PRECEDENCE_DEGREE_MODULE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_WRAPPED_RULE` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_BEGIN` (`KEY_BEGIN`),
  KEY `OID_BEGIN` (`OID_BEGIN`),
  KEY `KEY_CONTEXT_COURSE_GROUP` (`KEY_CONTEXT_COURSE_GROUP`),
  KEY `OID_CONTEXT_COURSE_GROUP` (`OID_CONTEXT_COURSE_GROUP`),
  KEY `KEY_DEGREE` (`KEY_DEGREE`),
  KEY `OID_DEGREE` (`OID_DEGREE`),
  KEY `KEY_DEGREE_MODULE_TO_APPLY_RULE` (`KEY_DEGREE_MODULE_TO_APPLY_RULE`),
  KEY `OID_DEGREE_MODULE_TO_APPLY_RULE` (`OID_DEGREE_MODULE_TO_APPLY_RULE`),
  KEY `KEY_DEPARTMENT_UNIT` (`KEY_DEPARTMENT_UNIT`),
  KEY `OID_DEPARTMENT_UNIT` (`OID_DEPARTMENT_UNIT`),
  KEY `KEY_END` (`KEY_END`),
  KEY `OID_END` (`OID_END`),
  KEY `KEY_EXCLUSIVE_DEGREE_MODULE` (`KEY_EXCLUSIVE_DEGREE_MODULE`),
  KEY `OID_EXCLUSIVE_DEGREE_MODULE` (`OID_EXCLUSIVE_DEGREE_MODULE`),
  KEY `KEY_NOT_RULE` (`KEY_NOT_RULE`),
  KEY `OID_NOT_RULE` (`OID_NOT_RULE`),
  KEY `KEY_PARENT_COMPOSITE_RULE` (`KEY_PARENT_COMPOSITE_RULE`),
  KEY `OID_PARENT_COMPOSITE_RULE` (`OID_PARENT_COMPOSITE_RULE`),
  KEY `KEY_PRECEDENCE_DEGREE_MODULE` (`KEY_PRECEDENCE_DEGREE_MODULE`),
  KEY `OID_PRECEDENCE_DEGREE_MODULE` (`OID_PRECEDENCE_DEGREE_MODULE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_WRAPPED_RULE` (`KEY_WRAPPED_RULE`),
  KEY `OID_WRAPPED_RULE` (`OID_WRAPPED_RULE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CURRICULAR_RULE`
--


--
-- Table structure for table `CURRICULAR_SEMESTER`
--

CREATE TABLE `CURRICULAR_SEMESTER` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_CURRICULAR_YEAR` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_CURRICULAR_YEAR` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `SEMESTER` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_CURRICULAR_YEAR` (`KEY_CURRICULAR_YEAR`),
  KEY `OID_CURRICULAR_YEAR` (`OID_CURRICULAR_YEAR`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB AUTO_INCREMENT=211 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CURRICULAR_SEMESTER`
--

INSERT INTO `CURRICULAR_SEMESTER` VALUES (201,201,1,442381631689,146028888265,2551210573825,1),(202,201,1,442381631690,146028888265,2551210573825,2),(203,202,1,442381631691,146028888266,2551210573825,1),(204,202,1,442381631692,146028888266,2551210573825,2),(205,203,1,442381631693,146028888267,2551210573825,1),(206,203,1,442381631694,146028888267,2551210573825,2),(207,204,1,442381631695,146028888268,2551210573825,1),(208,204,1,442381631696,146028888268,2551210573825,2),(209,205,1,442381631697,146028888269,2551210573825,1),(210,205,1,442381631698,146028888269,2551210573825,2);

--
-- Table structure for table `CURRICULAR_YEAR`
--

CREATE TABLE `CURRICULAR_YEAR` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `YEAR` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB AUTO_INCREMENT=206 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CURRICULAR_YEAR`
--

INSERT INTO `CURRICULAR_YEAR` VALUES (201,1,146028888265,2551210573825,1),(202,1,146028888266,2551210573825,2),(203,1,146028888267,2551210573825,3),(204,1,146028888268,2551210573825,4),(205,1,146028888269,2551210573825,5);

--
-- Table structure for table `CURRICULUM`
--

CREATE TABLE `CURRICULUM` (
  `GENERAL_OBJECTIVES` longtext,
  `GENERAL_OBJECTIVES_EN` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_CURRICULAR_COURSE` int(11) DEFAULT NULL,
  `KEY_PERSON_WHO_ALTERED` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `LAST_MODIFICATION_DATE_DATE_TIME` timestamp NULL DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_CURRICULAR_COURSE` bigint(20) DEFAULT NULL,
  `OID_PERSON_WHO_ALTERED` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OPERACIONAL_OBJECTIVES` longtext,
  `OPERACIONAL_OBJECTIVES_EN` longtext,
  `PROGRAM` longtext,
  `PROGRAM_EN` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_CURRICULAR_COURSE` (`KEY_CURRICULAR_COURSE`),
  KEY `OID_CURRICULAR_COURSE` (`OID_CURRICULAR_COURSE`),
  KEY `KEY_PERSON_WHO_ALTERED` (`KEY_PERSON_WHO_ALTERED`),
  KEY `OID_PERSON_WHO_ALTERED` (`OID_PERSON_WHO_ALTERED`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CURRICULUM`
--


--
-- Table structure for table `CURRICULUM_LINE_LOG`
--

CREATE TABLE `CURRICULUM_LINE_LOG` (
  `ACTION` int(11) DEFAULT NULL,
  `CREDITS` longtext,
  `DATE_DATE_TIME` timestamp NULL DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DEGREE_MODULE` int(11) DEFAULT NULL,
  `KEY_EXECUTION_PERIOD` int(11) DEFAULT NULL,
  `KEY_OPTIONAL_CURRICULAR_COURSE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_STUDENT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DEGREE_MODULE` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_PERIOD` bigint(20) DEFAULT NULL,
  `OID_OPTIONAL_CURRICULAR_COURSE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_STUDENT` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `SOURCE_DESCRIPTION` longtext,
  `WHO` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DEGREE_MODULE` (`KEY_DEGREE_MODULE`),
  KEY `OID_DEGREE_MODULE` (`OID_DEGREE_MODULE`),
  KEY `KEY_EXECUTION_PERIOD` (`KEY_EXECUTION_PERIOD`),
  KEY `OID_EXECUTION_PERIOD` (`OID_EXECUTION_PERIOD`),
  KEY `KEY_OPTIONAL_CURRICULAR_COURSE` (`KEY_OPTIONAL_CURRICULAR_COURSE`),
  KEY `OID_OPTIONAL_CURRICULAR_COURSE` (`OID_OPTIONAL_CURRICULAR_COURSE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_STUDENT` (`KEY_STUDENT`),
  KEY `OID_STUDENT` (`OID_STUDENT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CURRICULUM_LINE_LOG`
--


--
-- Table structure for table `CURRICULUM_MODULE`
--

CREATE TABLE `CURRICULUM_MODULE` (
  `CREATED_BY` longtext,
  `CREATION_DATE_DATE_TIME` timestamp NULL DEFAULT NULL,
  `ECTS_CREDITS` double DEFAULT NULL,
  `ENROLLMENT_STATE` text,
  `ENROLMENT_CONDITION` text,
  `ENROLMENT_EVALUATION_TYPE` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `IS_EXTRA_CURRICULAR` tinyint(1) DEFAULT NULL,
  `IS_FIRST_TIME` tinyint(1) DEFAULT NULL,
  `KEY_CONCLUSION_PROCESS` int(11) DEFAULT NULL,
  `KEY_CREDITS` int(11) DEFAULT NULL,
  `KEY_CURRICULUM_GROUP` int(11) DEFAULT NULL,
  `KEY_DEGREE_MODULE` int(11) DEFAULT NULL,
  `KEY_EXECUTION_PERIOD` int(11) DEFAULT NULL,
  `KEY_OPTIONAL_CURRICULAR_COURSE` int(11) DEFAULT NULL,
  `KEY_PARENT_STUDENT_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_STUDENT_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_CONCLUSION_PROCESS` bigint(20) DEFAULT NULL,
  `OID_CREDITS` bigint(20) DEFAULT NULL,
  `OID_CURRICULUM_GROUP` bigint(20) DEFAULT NULL,
  `OID_DEGREE_MODULE` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_PERIOD` bigint(20) DEFAULT NULL,
  `OID_OPTIONAL_CURRICULAR_COURSE` bigint(20) DEFAULT NULL,
  `OID_PARENT_STUDENT_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_STUDENT_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `USED_IN_SEPARATION_CYCLE` tinyint(1) DEFAULT NULL,
  `WEIGTH` double DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_CONCLUSION_PROCESS` (`KEY_CONCLUSION_PROCESS`),
  KEY `OID_CONCLUSION_PROCESS` (`OID_CONCLUSION_PROCESS`),
  KEY `KEY_CREDITS` (`KEY_CREDITS`),
  KEY `OID_CREDITS` (`OID_CREDITS`),
  KEY `KEY_CURRICULUM_GROUP` (`KEY_CURRICULUM_GROUP`),
  KEY `OID_CURRICULUM_GROUP` (`OID_CURRICULUM_GROUP`),
  KEY `KEY_DEGREE_MODULE` (`KEY_DEGREE_MODULE`),
  KEY `OID_DEGREE_MODULE` (`OID_DEGREE_MODULE`),
  KEY `KEY_EXECUTION_PERIOD` (`KEY_EXECUTION_PERIOD`),
  KEY `OID_EXECUTION_PERIOD` (`OID_EXECUTION_PERIOD`),
  KEY `KEY_OPTIONAL_CURRICULAR_COURSE` (`KEY_OPTIONAL_CURRICULAR_COURSE`),
  KEY `OID_OPTIONAL_CURRICULAR_COURSE` (`OID_OPTIONAL_CURRICULAR_COURSE`),
  KEY `KEY_PARENT_STUDENT_CURRICULAR_PLAN` (`KEY_PARENT_STUDENT_CURRICULAR_PLAN`),
  KEY `OID_PARENT_STUDENT_CURRICULAR_PLAN` (`OID_PARENT_STUDENT_CURRICULAR_PLAN`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_STUDENT_CURRICULAR_PLAN` (`KEY_STUDENT_CURRICULAR_PLAN`),
  KEY `OID_STUDENT_CURRICULAR_PLAN` (`OID_STUDENT_CURRICULAR_PLAN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CURRICULUM_MODULE`
--


--
-- Table structure for table `DEGREE`
--

CREATE TABLE `DEGREE` (
  `CODE` longtext,
  `ECTS_CREDITS` double DEFAULT NULL,
  `GRADE_SCALE` text,
  `ID_CARD_NAME` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_PHD_PROGRAM` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_SENDER` int(11) DEFAULT NULL,
  `KEY_SITE` int(11) DEFAULT NULL,
  `KEY_UNIT` int(11) DEFAULT NULL,
  `MINISTRY_CODE` longtext,
  `NAME_EN` longtext,
  `NOME` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_PHD_PROGRAM` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_SENDER` bigint(20) DEFAULT NULL,
  `OID_SITE` bigint(20) DEFAULT NULL,
  `OID_UNIT` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `PREVAILING_SCIENTIFIC_AREA` longtext,
  `SIGLA` longtext,
  `TIPO_CURSO` text,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_PHD_PROGRAM` (`KEY_PHD_PROGRAM`),
  KEY `OID_PHD_PROGRAM` (`OID_PHD_PROGRAM`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_SENDER` (`KEY_SENDER`),
  KEY `OID_SENDER` (`OID_SENDER`),
  KEY `KEY_SITE` (`KEY_SITE`),
  KEY `OID_SITE` (`OID_SITE`),
  KEY `KEY_UNIT` (`KEY_UNIT`),
  KEY `OID_UNIT` (`OID_UNIT`)
) ENGINE=InnoDB AUTO_INCREMENT=1203 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DEGREE`
--

INSERT INTO `DEGREE` VALUES (NULL,NULL,NULL,NULL,1202,NULL,1,NULL,54289,NULL,NULL,NULL,'Curso de Unidades Isoladas',850403525810,NULL,2551210573825,NULL,2220498146321,NULL,'net.sourceforge.fenixedu.domain.EmptyDegree',NULL,NULL,'EMPTY');

--
-- Table structure for table `DEGREE_CONTEXT`
--

CREATE TABLE `DEGREE_CONTEXT` (
  `BEGIN_INTERVAL` longtext,
  `END_INTERVAL` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DEGREE_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DEGREE_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `PERIOD` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DEGREE_CURRICULAR_PLAN` (`KEY_DEGREE_CURRICULAR_PLAN`),
  KEY `OID_DEGREE_CURRICULAR_PLAN` (`OID_DEGREE_CURRICULAR_PLAN`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DEGREE_CONTEXT`
--


--
-- Table structure for table `DEGREE_CURRICULAR_PLAN`
--

CREATE TABLE `DEGREE_CURRICULAR_PLAN` (
  `ANOTATION` longtext,
  `APPLY_PREVIOUS_YEARS_ENROLMENT_RULE` tinyint(1) DEFAULT NULL,
  `CURRICULAR_PLAN_MEMBERS_GROUP` longtext,
  `CURRICULAR_STAGE` text,
  `DEGREE_DURATION` int(11) DEFAULT NULL,
  `DESCRIPTION` longtext,
  `DESCRIPTION_EN` longtext,
  `END_DATE_YEAR_MONTH_DAY` longtext,
  `GRADE_SCALE` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `INITIAL_DATE_YEAR_MONTH_DAY` longtext,
  `KEY_DEGREE` int(11) DEFAULT NULL,
  `KEY_DEGREE_STRUCTURE` int(11) DEFAULT NULL,
  `KEY_EQUIVALENCE_PLAN` int(11) DEFAULT NULL,
  `KEY_ROOT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_SERVICE_AGREEMENT_TEMPLATE` int(11) DEFAULT NULL,
  `MARK_TYPE` int(11) DEFAULT NULL,
  `MINIMAL_YEAR_FOR_OPTIONAL_COURSES` int(11) DEFAULT NULL,
  `NAME` longtext,
  `NEEDED_CREDITS` double DEFAULT NULL,
  `NUMERUS_CLAUSUS` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DEGREE` bigint(20) DEFAULT NULL,
  `OID_DEGREE_STRUCTURE` bigint(20) DEFAULT NULL,
  `OID_EQUIVALENCE_PLAN` bigint(20) DEFAULT NULL,
  `OID_ROOT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_SERVICE_AGREEMENT_TEMPLATE` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `STATE` text,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DEGREE` (`KEY_DEGREE`),
  KEY `OID_DEGREE` (`OID_DEGREE`),
  KEY `KEY_DEGREE_STRUCTURE` (`KEY_DEGREE_STRUCTURE`),
  KEY `OID_DEGREE_STRUCTURE` (`OID_DEGREE_STRUCTURE`),
  KEY `KEY_EQUIVALENCE_PLAN` (`KEY_EQUIVALENCE_PLAN`),
  KEY `OID_EQUIVALENCE_PLAN` (`OID_EQUIVALENCE_PLAN`),
  KEY `KEY_ROOT` (`KEY_ROOT`),
  KEY `OID_ROOT` (`OID_ROOT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_SERVICE_AGREEMENT_TEMPLATE` (`KEY_SERVICE_AGREEMENT_TEMPLATE`),
  KEY `OID_SERVICE_AGREEMENT_TEMPLATE` (`OID_SERVICE_AGREEMENT_TEMPLATE`)
) ENGINE=InnoDB AUTO_INCREMENT=602 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DEGREE_CURRICULAR_PLAN`
--

INSERT INTO `DEGREE_CURRICULAR_PLAN` VALUES (NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,601,NULL,1202,NULL,NULL,NULL,1,NULL,NULL,NULL,'Plano Curricular de Unidades Isoladas',NULL,NULL,438086664793,850403525810,NULL,NULL,NULL,2551210573825,NULL,'net.sourceforge.fenixedu.domain.EmptyDegreeCurricularPlan',NULL);

--
-- Table structure for table `DEGREE_INFO`
--

CREATE TABLE `DEGREE_INFO` (
  `ADDITIONAL_INFO` longtext,
  `DESCRIPTION` longtext,
  `DRIFTS_FIRST` int(11) DEFAULT NULL,
  `DRIFTS_INITIAL` int(11) DEFAULT NULL,
  `DRIFTS_SECOND` int(11) DEFAULT NULL,
  `GRATUITY` longtext,
  `HISTORY` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DEGREE` int(11) DEFAULT NULL,
  `KEY_DEGREE_INFO_CANDIDACY` int(11) DEFAULT NULL,
  `KEY_DEGREE_INFO_FUTURE` int(11) DEFAULT NULL,
  `KEY_EXECUTION_YEAR` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `LINKS` longtext,
  `MARK_AVERAGE` double DEFAULT NULL,
  `MARK_MAX` double DEFAULT NULL,
  `MARK_MIN` double DEFAULT NULL,
  `NAME` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DEGREE` bigint(20) DEFAULT NULL,
  `OID_DEGREE_INFO_CANDIDACY` bigint(20) DEFAULT NULL,
  `OID_DEGREE_INFO_FUTURE` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_YEAR` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OPERATIONAL_REGIME` longtext,
  `SCHOOL_CALENDAR` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DEGREE` (`KEY_DEGREE`),
  KEY `OID_DEGREE` (`OID_DEGREE`),
  KEY `KEY_DEGREE_INFO_CANDIDACY` (`KEY_DEGREE_INFO_CANDIDACY`),
  KEY `OID_DEGREE_INFO_CANDIDACY` (`OID_DEGREE_INFO_CANDIDACY`),
  KEY `KEY_DEGREE_INFO_FUTURE` (`KEY_DEGREE_INFO_FUTURE`),
  KEY `OID_DEGREE_INFO_FUTURE` (`OID_DEGREE_INFO_FUTURE`),
  KEY `KEY_EXECUTION_YEAR` (`KEY_EXECUTION_YEAR`),
  KEY `OID_EXECUTION_YEAR` (`OID_EXECUTION_YEAR`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DEGREE_INFO`
--


--
-- Table structure for table `DEGREE_INFO_CANDIDACY`
--

CREATE TABLE `DEGREE_INFO_CANDIDACY` (
  `ACCESS_REQUISITES` longtext,
  `CANDIDACY_DOCUMENTS` longtext,
  `CANDIDACY_PERIOD` longtext,
  `ENROLMENT_PERIOD` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DEGREE_INFO` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DEGREE_INFO` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `SELECTION_RESULT_DEADLINE` longtext,
  `TEST_INGRESSION` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DEGREE_INFO` (`KEY_DEGREE_INFO`),
  KEY `OID_DEGREE_INFO` (`OID_DEGREE_INFO`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DEGREE_INFO_CANDIDACY`
--


--
-- Table structure for table `DEGREE_INFO_FUTURE`
--

CREATE TABLE `DEGREE_INFO_FUTURE` (
  `CLASSIFICATIONS` longtext,
  `DESIGNED_FOR` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DEGREE_INFO` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OBJECTIVES` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DEGREE_INFO` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `PROFESSIONAL_EXITS` longtext,
  `QUALIFICATION_LEVEL` longtext,
  `RECOGNITIONS` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DEGREE_INFO` (`KEY_DEGREE_INFO`),
  KEY `OID_DEGREE_INFO` (`OID_DEGREE_INFO`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DEGREE_INFO_FUTURE`
--


--
-- Table structure for table `DEGREE_MODULE`
--

CREATE TABLE `DEGREE_MODULE` (
  `ACRONYM` longtext,
  `BASIC` tinyint(1) DEFAULT NULL,
  `CODE` longtext,
  `CREDITS` double DEFAULT NULL,
  `CURRICULAR_COURSE_EXECUTION_SCOPE` int(11) DEFAULT NULL,
  `CURRICULAR_STAGE` text,
  `CYCLE_TYPE` text,
  `ECTS_CREDITS` double DEFAULT NULL,
  `ENROLLMENT_ALLOWED` tinyint(1) DEFAULT NULL,
  `ENROLLMENT_WEIGTH` int(11) DEFAULT NULL,
  `GRADE_SCALE` text,
  `GRADUATE_TITLE_SUFFIX` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_COMPETENCE_COURSE` int(11) DEFAULT NULL,
  `KEY_DEGREE_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `KEY_PARENT_DEGREE_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_SCIENTIFIC_AREA` int(11) DEFAULT NULL,
  `KEY_STUDENT_COURSE_REPORT` int(11) DEFAULT NULL,
  `KEY_UNIVERSITY` int(11) DEFAULT NULL,
  `LAB_HOURS` double DEFAULT NULL,
  `MANDATORY` tinyint(1) DEFAULT NULL,
  `MANDATORY_ENROLLMENT` tinyint(1) DEFAULT NULL,
  `MAXIMUM_VALUE_FOR_ACUMULATED_ENROLLMENTS` int(11) DEFAULT NULL,
  `MINIMUM_VALUE_FOR_ACUMULATED_ENROLLMENTS` int(11) DEFAULT NULL,
  `NAME` longtext,
  `NAME_EN` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_COMPETENCE_COURSE` bigint(20) DEFAULT NULL,
  `OID_DEGREE_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OID_PARENT_DEGREE_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_SCIENTIFIC_AREA` bigint(20) DEFAULT NULL,
  `OID_STUDENT_COURSE_REPORT` bigint(20) DEFAULT NULL,
  `OID_UNIVERSITY` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `PRATICAL_HOURS` double DEFAULT NULL,
  `PREREQUISITES` longtext,
  `PREREQUISITES_EN` longtext,
  `REGIME_TYPE` text,
  `THEORETICAL_HOURS` double DEFAULT NULL,
  `THEO_PRAT_HOURS` double DEFAULT NULL,
  `TYPE` text,
  `WEIGTH` double DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_COMPETENCE_COURSE` (`KEY_COMPETENCE_COURSE`),
  KEY `OID_COMPETENCE_COURSE` (`OID_COMPETENCE_COURSE`),
  KEY `KEY_DEGREE_CURRICULAR_PLAN` (`KEY_DEGREE_CURRICULAR_PLAN`),
  KEY `OID_DEGREE_CURRICULAR_PLAN` (`OID_DEGREE_CURRICULAR_PLAN`),
  KEY `KEY_PARENT_DEGREE_CURRICULAR_PLAN` (`KEY_PARENT_DEGREE_CURRICULAR_PLAN`),
  KEY `OID_PARENT_DEGREE_CURRICULAR_PLAN` (`OID_PARENT_DEGREE_CURRICULAR_PLAN`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_SCIENTIFIC_AREA` (`KEY_SCIENTIFIC_AREA`),
  KEY `OID_SCIENTIFIC_AREA` (`OID_SCIENTIFIC_AREA`),
  KEY `KEY_STUDENT_COURSE_REPORT` (`KEY_STUDENT_COURSE_REPORT`),
  KEY `OID_STUDENT_COURSE_REPORT` (`OID_STUDENT_COURSE_REPORT`),
  KEY `KEY_UNIVERSITY` (`KEY_UNIVERSITY`),
  KEY `OID_UNIVERSITY` (`OID_UNIVERSITY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DEGREE_MODULE`
--


--
-- Table structure for table `DELEGATE`
--

CREATE TABLE `DELEGATE` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DELEGATE_FUNCTION` int(11) DEFAULT NULL,
  `KEY_REGISTRATION` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DELEGATE_FUNCTION` bigint(20) DEFAULT NULL,
  `OID_REGISTRATION` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DELEGATE_FUNCTION` (`KEY_DELEGATE_FUNCTION`),
  KEY `OID_DELEGATE_FUNCTION` (`OID_DELEGATE_FUNCTION`),
  KEY `KEY_REGISTRATION` (`KEY_REGISTRATION`),
  KEY `OID_REGISTRATION` (`OID_REGISTRATION`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DELEGATE`
--


--
-- Table structure for table `DELEGATE_ELECTION`
--

CREATE TABLE `DELEGATE_ELECTION` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_CANDIDACY_PERIOD` int(11) DEFAULT NULL,
  `KEY_CURRICULAR_YEAR` int(11) DEFAULT NULL,
  `KEY_DEGREE` int(11) DEFAULT NULL,
  `KEY_ELECTED_STUDENT` int(11) DEFAULT NULL,
  `KEY_EXECUTION_YEAR` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_VOTING_PERIOD` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_CANDIDACY_PERIOD` bigint(20) DEFAULT NULL,
  `OID_CURRICULAR_YEAR` bigint(20) DEFAULT NULL,
  `OID_DEGREE` bigint(20) DEFAULT NULL,
  `OID_ELECTED_STUDENT` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_YEAR` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_VOTING_PERIOD` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `SENT_RESULTS_TO_CANDIDATES` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_CANDIDACY_PERIOD` (`KEY_CANDIDACY_PERIOD`),
  KEY `OID_CANDIDACY_PERIOD` (`OID_CANDIDACY_PERIOD`),
  KEY `KEY_CURRICULAR_YEAR` (`KEY_CURRICULAR_YEAR`),
  KEY `OID_CURRICULAR_YEAR` (`OID_CURRICULAR_YEAR`),
  KEY `KEY_DEGREE` (`KEY_DEGREE`),
  KEY `OID_DEGREE` (`OID_DEGREE`),
  KEY `KEY_ELECTED_STUDENT` (`KEY_ELECTED_STUDENT`),
  KEY `OID_ELECTED_STUDENT` (`OID_ELECTED_STUDENT`),
  KEY `KEY_EXECUTION_YEAR` (`KEY_EXECUTION_YEAR`),
  KEY `OID_EXECUTION_YEAR` (`OID_EXECUTION_YEAR`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_VOTING_PERIOD` (`KEY_VOTING_PERIOD`),
  KEY `OID_VOTING_PERIOD` (`OID_VOTING_PERIOD`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DELEGATE_ELECTION`
--


--
-- Table structure for table `DELEGATE_ELECTION_CANDIDATES_STUDENT`
--

CREATE TABLE `DELEGATE_ELECTION_CANDIDATES_STUDENT` (
  `KEY_DELEGATE_ELECTION` int(11) NOT NULL,
  `KEY_STUDENT` int(11) NOT NULL,
  `OID_DELEGATE_ELECTION` bigint(20) unsigned DEFAULT NULL,
  `OID_STUDENT` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_DELEGATE_ELECTION`,`KEY_STUDENT`),
  KEY `KEY_DELEGATE_ELECTION` (`KEY_DELEGATE_ELECTION`),
  KEY `KEY_STUDENT` (`KEY_STUDENT`),
  KEY `OID_DELEGATE_ELECTION` (`OID_DELEGATE_ELECTION`,`OID_STUDENT`),
  KEY `OID_DELEGATE_ELECTION_2` (`OID_DELEGATE_ELECTION`),
  KEY `OID_STUDENT` (`OID_STUDENT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DELEGATE_ELECTION_CANDIDATES_STUDENT`
--


--
-- Table structure for table `DELEGATE_ELECTION_PERIOD`
--

CREATE TABLE `DELEGATE_ELECTION_PERIOD` (
  `END_DATE` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DELEGATE_ELECTION` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DELEGATE_ELECTION` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `START_DATE` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DELEGATE_ELECTION` (`KEY_DELEGATE_ELECTION`),
  KEY `OID_DELEGATE_ELECTION` (`OID_DELEGATE_ELECTION`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DELEGATE_ELECTION_PERIOD`
--


--
-- Table structure for table `DELEGATE_ELECTION_STUDENT`
--

CREATE TABLE `DELEGATE_ELECTION_STUDENT` (
  `KEY_DELEGATE_ELECTION` int(11) NOT NULL,
  `KEY_STUDENT` int(11) NOT NULL,
  `OID_DELEGATE_ELECTION` bigint(20) unsigned DEFAULT NULL,
  `OID_STUDENT` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_DELEGATE_ELECTION`,`KEY_STUDENT`),
  KEY `KEY_DELEGATE_ELECTION` (`KEY_DELEGATE_ELECTION`),
  KEY `KEY_STUDENT` (`KEY_STUDENT`),
  KEY `OID_DELEGATE_ELECTION` (`OID_DELEGATE_ELECTION`,`OID_STUDENT`),
  KEY `OID_DELEGATE_ELECTION_2` (`OID_DELEGATE_ELECTION`),
  KEY `OID_STUDENT` (`OID_STUDENT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DELEGATE_ELECTION_STUDENT`
--


--
-- Table structure for table `DELEGATE_ELECTION_VOTE`
--

CREATE TABLE `DELEGATE_ELECTION_VOTE` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DELEGATE_ELECTION` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_STUDENT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DELEGATE_ELECTION` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_STUDENT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DELEGATE_ELECTION` (`KEY_DELEGATE_ELECTION`),
  KEY `OID_DELEGATE_ELECTION` (`OID_DELEGATE_ELECTION`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_STUDENT` (`KEY_STUDENT`),
  KEY `OID_STUDENT` (`OID_STUDENT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DELEGATE_ELECTION_VOTE`
--


--
-- Table structure for table `DELEGATE_ELECTION_VOTING_STUDENT`
--

CREATE TABLE `DELEGATE_ELECTION_VOTING_STUDENT` (
  `KEY_DELEGATE_ELECTION` int(11) NOT NULL,
  `KEY_STUDENT` int(11) NOT NULL,
  `OID_DELEGATE_ELECTION` bigint(20) unsigned DEFAULT NULL,
  `OID_STUDENT` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_DELEGATE_ELECTION`,`KEY_STUDENT`),
  KEY `KEY_DELEGATE_ELECTION` (`KEY_DELEGATE_ELECTION`),
  KEY `KEY_STUDENT` (`KEY_STUDENT`),
  KEY `OID_DELEGATE_ELECTION` (`OID_DELEGATE_ELECTION`,`OID_STUDENT`),
  KEY `OID_DELEGATE_ELECTION_2` (`OID_DELEGATE_ELECTION`),
  KEY `OID_STUDENT` (`OID_STUDENT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DELEGATE_ELECTION_VOTING_STUDENT`
--


--
-- Table structure for table `DELETE_FILE_LOG`
--

CREATE TABLE `DELETE_FILE_LOG` (
  `EXTERNAL_STORAGE_IDENTIFICATION` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `REQUESTOR_IST_USERNAME` longtext,
  `REQUEST_TIME` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DELETE_FILE_LOG`
--


--
-- Table structure for table `DELETE_FILE_REQUEST`
--

CREATE TABLE `DELETE_FILE_REQUEST` (
  `DELETE_ITEM` tinyint(1) DEFAULT NULL,
  `EXTERNAL_STORAGE_IDENTIFICATION` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `REQUESTOR_IST_USERNAME` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DELETE_FILE_REQUEST`
--


--
-- Table structure for table `DEPARTMENT`
--

CREATE TABLE `DEPARTMENT` (
  `CODE` longtext,
  `COMPETENCE_COURSE_MEMBERS_GROUP` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DEPARTMENT_UNIT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `NAME` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DEPARTMENT_UNIT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `REAL_NAME` longtext,
  `REAL_NAME_EN` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DEPARTMENT_UNIT` (`KEY_DEPARTMENT_UNIT`),
  KEY `OID_DEPARTMENT_UNIT` (`OID_DEPARTMENT_UNIT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DEPARTMENT`
--


--
-- Table structure for table `DEPARTMENT_DEGREE`
--

CREATE TABLE `DEPARTMENT_DEGREE` (
  `KEY_DEPARTMENT` int(11) NOT NULL,
  `KEY_DEGREE` int(11) NOT NULL,
  `OID_DEPARTMENT` bigint(20) unsigned DEFAULT NULL,
  `OID_DEGREE` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_DEPARTMENT`,`KEY_DEGREE`),
  KEY `KEY_DEPARTMENT` (`KEY_DEPARTMENT`),
  KEY `KEY_DEGREE` (`KEY_DEGREE`),
  KEY `OID_DEPARTMENT` (`OID_DEPARTMENT`,`OID_DEGREE`),
  KEY `OID_DEPARTMENT_2` (`OID_DEPARTMENT`),
  KEY `OID_DEGREE` (`OID_DEGREE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DEPARTMENT_DEGREE`
--


--
-- Table structure for table `DEPLOY_NOTIFIER`
--

CREATE TABLE `DEPLOY_NOTIFIER` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `NOTIFY_USERS` tinyint(1) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `TIME_STAMP` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DEPLOY_NOTIFIER`
--


--
-- Table structure for table `DISCOUNT`
--

CREATE TABLE `DISCOUNT` (
  `AMOUNT` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EVENT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EVENT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `USERNAME` longtext,
  `WHEN_CREATED` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EVENT` (`KEY_EVENT`),
  KEY `OID_EVENT` (`OID_EVENT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DISCOUNT`
--


--
-- Table structure for table `DISTRIBUTED_TEST`
--

CREATE TABLE `DISTRIBUTED_TEST` (
  `BEGIN_DATE_DATE_YEAR_MONTH_DAY` longtext,
  `BEGIN_HOUR_DATE_HOUR_MINUTE_SECOND` time DEFAULT NULL,
  `CORRECTION_AVAILABILITY` int(11) DEFAULT NULL,
  `END_DATE_DATE_YEAR_MONTH_DAY` longtext,
  `END_HOUR_DATE_HOUR_MINUTE_SECOND` time DEFAULT NULL,
  `EVALUATION_TITLE` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `IMS_FEEDBACK` tinyint(1) DEFAULT NULL,
  `KEY_ONLINE_TEST` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_TEST_SCOPE` int(11) DEFAULT NULL,
  `NUMBER_OF_QUESTIONS` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ONLINE_TEST` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_TEST_SCOPE` bigint(20) DEFAULT NULL,
  `TEST_INFORMATION` longtext,
  `TEST_TYPE` int(11) DEFAULT NULL,
  `TITLE` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ONLINE_TEST` (`KEY_ONLINE_TEST`),
  KEY `OID_ONLINE_TEST` (`OID_ONLINE_TEST`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_TEST_SCOPE` (`KEY_TEST_SCOPE`),
  KEY `OID_TEST_SCOPE` (`OID_TEST_SCOPE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DISTRIBUTED_TEST`
--


--
-- Table structure for table `DISTRICT`
--

CREATE TABLE `DISTRICT` (
  `CODE` varchar(20) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT '1',
  `NAME` text,
  `OID` bigint(20) unsigned DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  UNIQUE KEY `CODE` (`CODE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID` (`OID`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DISTRICT`
--

INSERT INTO `DISTRICT` VALUES ('99',1,1,'Estrangeiro',219043332097,1043677052929),('03',2,1,'Braga',NULL,NULL),('04',3,1,'Bragança',NULL,NULL),('05',4,1,'Castelo Branco',NULL,NULL),('06',5,1,'Coimbra',NULL,NULL),('07',6,1,'Ã‰vora',NULL,NULL),('08',7,1,'Faro',NULL,NULL),('09',8,1,'Guarda',NULL,NULL),('10',9,1,'Leiria',NULL,NULL),('11',10,1,'Lisboa',NULL,NULL),('12',11,1,'Portalegre',NULL,NULL),('13',12,1,'Porto',NULL,NULL),('14',13,1,'Santarém',NULL,NULL),('15',14,1,'SetÃºbal',NULL,NULL),('16',15,1,'Viana do Castelo',NULL,NULL),('17',16,1,'Vila Real',NULL,NULL),('18',17,1,'Viseu',NULL,NULL),('31',18,1,'Ilha da Madeira',NULL,NULL),('32',19,1,'Ilha de Porto Santo',NULL,NULL),('41',20,1,'Ilha de Santa Maria',NULL,NULL),('42',21,1,'Ilha de São Miguel',NULL,NULL),('43',22,1,'Ilha Terceira',NULL,NULL),('44',23,1,'Ilha da Graciosa',NULL,NULL),('45',24,1,'Ilha de São Jorge',NULL,NULL),('46',25,1,'Ilha do Pico',NULL,NULL),('47',26,1,'Ilha do Faial',NULL,NULL),('48',27,1,'Ilha das Flores',NULL,NULL),('49',28,1,'Ilha do Corvo',NULL,NULL),('01',29,1,'Aveiro',NULL,NULL),('02',30,1,'Beja',NULL,NULL);

--
-- Table structure for table `DISTRICT_SUBDIVISION`
--

CREATE TABLE `DISTRICT_SUBDIVISION` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `CODE` varchar(2) NOT NULL,
  `KEY_DISTRICT` int(11) NOT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) NOT NULL,
  `NAME` varchar(255) NOT NULL,
  `OID` bigint(20) unsigned DEFAULT NULL,
  `OID_DISTRICT` bigint(20) unsigned DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  UNIQUE KEY `KEY_DISTRICT_2` (`KEY_DISTRICT`,`CODE`),
  UNIQUE KEY `KEY_DISTRICT_3` (`KEY_DISTRICT`,`NAME`),
  KEY `KEY_DISTRICT` (`KEY_DISTRICT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID` (`OID`),
  KEY `OID_DISTRICT` (`OID_DISTRICT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB AUTO_INCREMENT=543 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DISTRICT_SUBDIVISION`
--

INSERT INTO `DISTRICT_SUBDIVISION` VALUES (32,'07',6,1,'Mora',NULL,NULL,NULL),(33,'08',6,1,'Mourão',NULL,NULL,NULL),(34,'09',6,1,'Portel',NULL,NULL,NULL),(35,'10',6,1,'Redondo',NULL,NULL,NULL),(36,'11',6,1,'Reguengos de Monsaraz',NULL,NULL,NULL),(37,'12',6,1,'Vendas Novas',NULL,NULL,NULL),(38,'13',6,1,'Viana do Alentejo',NULL,NULL,NULL),(39,'14',6,1,'Vila Viçosa',NULL,NULL,NULL),(40,'01',7,1,'Albufeira',NULL,NULL,NULL),(41,'02',7,1,'Alcoutim',NULL,NULL,NULL),(42,'03',7,1,'Aljezur',NULL,NULL,NULL),(43,'04',7,1,'Castro Marim',NULL,NULL,NULL),(44,'05',7,1,'Faro',NULL,NULL,NULL),(45,'06',7,1,'Lagoa (Algarve)',NULL,NULL,NULL),(46,'07',7,1,'Lagos',NULL,NULL,NULL),(47,'08',7,1,'Loulé',NULL,NULL,NULL),(48,'09',7,1,'Monchique',NULL,NULL,NULL),(49,'10',7,1,'Olhão',NULL,NULL,NULL),(50,'11',7,1,'Portimão',NULL,NULL,NULL),(51,'12',7,1,'São Brás de Alportel',NULL,NULL,NULL),(52,'13',7,1,'Silves',NULL,NULL,NULL),(53,'14',7,1,'Tavira',NULL,NULL,NULL),(54,'15',7,1,'Vila do Bispo',NULL,NULL,NULL),(55,'16',7,1,'Vila Real de Santo António',NULL,NULL,NULL),(56,'01',8,1,'Aguiar da Beira',NULL,NULL,NULL),(57,'02',8,1,'Almeida',NULL,NULL,NULL),(58,'03',8,1,'Celorico da Beira',NULL,NULL,NULL),(59,'04',8,1,'Figueira de Castelo Rodrigo',NULL,NULL,NULL),(60,'05',8,1,'Fornos de Algodres',NULL,NULL,NULL),(61,'06',8,1,'Gouveia',NULL,NULL,NULL),(62,'07',8,1,'Guarda',NULL,NULL,NULL),(63,'08',8,1,'Manteigas',NULL,NULL,NULL),(64,'09',8,1,'Meda',NULL,NULL,NULL),(65,'10',8,1,'Pinhel',NULL,NULL,NULL),(66,'11',8,1,'Sabugal',NULL,NULL,NULL),(67,'12',8,1,'Seia',NULL,NULL,NULL),(68,'13',8,1,'Trancoso',NULL,NULL,NULL),(69,'14',8,1,'Vila Nova de Foz CÃ´a',NULL,NULL,NULL),(70,'01',9,1,'Alcobaça',NULL,NULL,NULL),(71,'02',9,1,'Alvaiázere',NULL,NULL,NULL),(72,'03',9,1,'Ansião',NULL,NULL,NULL),(73,'04',9,1,'Batalha',NULL,NULL,NULL),(74,'05',9,1,'Bombarral',NULL,NULL,NULL),(75,'06',9,1,'Caldas da Rainha',NULL,NULL,NULL),(76,'07',9,1,'Castanheira de Pêra',NULL,NULL,NULL),(77,'08',9,1,'Figueiró dos Vinhos',NULL,NULL,NULL),(78,'09',9,1,'Leiria',NULL,NULL,NULL),(79,'10',9,1,'Marinha Grande',NULL,NULL,NULL),(80,'01',29,1,'Ãgueda',NULL,NULL,NULL),(81,'02',29,1,'Albergaria-a-Velha',NULL,NULL,NULL),(82,'11',9,1,'Nazaré',NULL,NULL,NULL),(83,'12',9,1,'Ã“bidos',NULL,NULL,NULL),(84,'13',9,1,'Pedrógão Grande',NULL,NULL,NULL),(85,'14',9,1,'Peniche',NULL,NULL,NULL),(86,'15',9,1,'Pombal',NULL,NULL,NULL),(87,'16',9,1,'Porto de Mós',NULL,NULL,NULL),(88,'01',10,1,'Alenquer',NULL,NULL,NULL),(89,'02',10,1,'Arruda dos Vinhos',NULL,NULL,NULL),(90,'03',10,1,'Azambuja',NULL,NULL,NULL),(91,'04',10,1,'Cadaval',NULL,NULL,NULL),(92,'05',10,1,'Cascais',NULL,NULL,NULL),(93,'06',10,1,'Lisboa',NULL,NULL,NULL),(94,'07',10,1,'Loures',NULL,NULL,NULL),(95,'08',10,1,'Lourinhã',NULL,NULL,NULL),(96,'09',10,1,'Mafra',NULL,NULL,NULL),(97,'10',10,1,'Oeiras',NULL,NULL,NULL),(98,'11',10,1,'Sintra',NULL,NULL,NULL),(99,'12',10,1,'Sobral de Monte Agraço',NULL,NULL,NULL),(100,'13',10,1,'Torres Vedras',NULL,NULL,NULL),(101,'14',10,1,'Vila Franca de Xira',NULL,NULL,NULL),(102,'15',10,1,'Amadora',NULL,NULL,NULL),(103,'16',10,1,'Odivelas',NULL,NULL,NULL),(104,'01',11,1,'Alter do Chão',NULL,NULL,NULL),(105,'02',11,1,'Arronches',NULL,NULL,NULL),(106,'03',11,1,'Avis',NULL,NULL,NULL),(107,'04',11,1,'Campo Maior',NULL,NULL,NULL),(108,'05',11,1,'Castelo de Vide',NULL,NULL,NULL),(109,'06',11,1,'Crato',NULL,NULL,NULL),(110,'07',11,1,'Elvas',NULL,NULL,NULL),(111,'08',11,1,'Fronteira',NULL,NULL,NULL),(112,'09',11,1,'Gavião',NULL,NULL,NULL),(113,'10',11,1,'Marvão',NULL,NULL,NULL),(114,'11',11,1,'Monforte',NULL,NULL,NULL),(115,'12',11,1,'Nisa',NULL,NULL,NULL),(116,'13',11,1,'Ponte de Sor',NULL,NULL,NULL),(117,'14',11,1,'Portalegre',NULL,NULL,NULL),(118,'15',11,1,'Sousel',NULL,NULL,NULL),(119,'01',12,1,'Amarante',NULL,NULL,NULL),(120,'02',12,1,'Baião',NULL,NULL,NULL),(121,'03',12,1,'Felgueiras',NULL,NULL,NULL),(122,'04',12,1,'Gondomar',NULL,NULL,NULL),(123,'05',12,1,'Lousada',NULL,NULL,NULL),(124,'06',12,1,'Maia',NULL,NULL,NULL),(125,'07',12,1,'Marco de Canaveses',NULL,NULL,NULL),(126,'08',12,1,'Matosinhos',NULL,NULL,NULL),(127,'09',12,1,'Paços de Ferreira',NULL,NULL,NULL),(128,'10',12,1,'Paredes',NULL,NULL,NULL),(129,'11',12,1,'Penafiel',NULL,NULL,NULL),(130,'12',12,1,'Porto',NULL,NULL,NULL),(131,'13',12,1,'Póvoa de Varzim',NULL,NULL,NULL),(132,'14',12,1,'Santo Tirso',NULL,NULL,NULL),(133,'15',12,1,'Valongo',NULL,NULL,NULL),(134,'16',12,1,'Vila do Conde',NULL,NULL,NULL),(135,'17',12,1,'Vila Nova de Gaia',NULL,NULL,NULL),(136,'18',12,1,'Trofa',NULL,NULL,NULL),(137,'01',13,1,'Abrantes',NULL,NULL,NULL),(138,'02',13,1,'Alcanena',NULL,NULL,NULL),(139,'03',13,1,'Almeirim',NULL,NULL,NULL),(140,'04',13,1,'Alpiarça',NULL,NULL,NULL),(141,'05',13,1,'Benavente',NULL,NULL,NULL),(142,'06',13,1,'Cartaxo',NULL,NULL,NULL),(143,'07',13,1,'Chamusca',NULL,NULL,NULL),(144,'08',13,1,'Constância',NULL,NULL,NULL),(145,'09',13,1,'Coruche',NULL,NULL,NULL),(146,'10',13,1,'Entroncamento',NULL,NULL,NULL),(147,'11',13,1,'Ferreira do Zêzere',NULL,NULL,NULL),(148,'12',13,1,'Golegã',NULL,NULL,NULL),(149,'13',13,1,'Mação',NULL,NULL,NULL),(150,'14',13,1,'Rio Maior',NULL,NULL,NULL),(151,'15',13,1,'Salvaterra de Magos',NULL,NULL,NULL),(152,'16',13,1,'Santarém',NULL,NULL,NULL),(153,'17',13,1,'Sardoal',NULL,NULL,NULL),(154,'18',13,1,'Tomar',NULL,NULL,NULL),(155,'19',13,1,'Torres Novas',NULL,NULL,NULL),(156,'20',13,1,'Vila Nova da Barquinha',NULL,NULL,NULL),(157,'21',13,1,'Ourém',NULL,NULL,NULL),(158,'01',14,1,'Alcácer do Sal',NULL,NULL,NULL),(159,'02',14,1,'Alcochete',NULL,NULL,NULL),(160,'03',14,1,'Almada',NULL,NULL,NULL),(161,'04',14,1,'Barreiro',NULL,NULL,NULL),(162,'05',14,1,'Grândola',NULL,NULL,NULL),(163,'06',14,1,'Moita',NULL,NULL,NULL),(164,'07',14,1,'Montijo',NULL,NULL,NULL),(165,'08',14,1,'Palmela',NULL,NULL,NULL),(166,'09',14,1,'Santiago do Cacém',NULL,NULL,NULL),(167,'10',14,1,'Seixal',NULL,NULL,NULL),(168,'11',14,1,'Sesimbra',NULL,NULL,NULL),(169,'12',14,1,'SetÃºbal',NULL,NULL,NULL),(170,'13',14,1,'Sines',NULL,NULL,NULL),(171,'01',15,1,'Arcos de Valdevez',NULL,NULL,NULL),(172,'02',15,1,'Caminha',NULL,NULL,NULL),(173,'03',15,1,'Melgaço',NULL,NULL,NULL),(174,'04',15,1,'Monção',NULL,NULL,NULL),(175,'05',15,1,'Paredes de Coura',NULL,NULL,NULL),(176,'06',15,1,'Ponte da Barca',NULL,NULL,NULL),(177,'07',15,1,'Ponte de Lima',NULL,NULL,NULL),(178,'08',15,1,'Valença',NULL,NULL,NULL),(179,'09',15,1,'Viana do Castelo',NULL,NULL,NULL),(180,'10',15,1,'Vila Nova de Cerveira',NULL,NULL,NULL),(181,'01',16,1,'Alijó',NULL,NULL,NULL),(182,'02',16,1,'Boticas',NULL,NULL,NULL),(183,'03',16,1,'Chaves',NULL,NULL,NULL),(184,'04',16,1,'Mesão Frio',NULL,NULL,NULL),(185,'05',16,1,'Mondim de Basto',NULL,NULL,NULL),(186,'06',16,1,'Montalegre',NULL,NULL,NULL),(187,'07',16,1,'Murça',NULL,NULL,NULL),(188,'08',16,1,'Peso da Régua',NULL,NULL,NULL),(189,'09',16,1,'Ribeira de Pena',NULL,NULL,NULL),(190,'10',16,1,'Sabrosa',NULL,NULL,NULL),(191,'11',16,1,'Santa Marta de Penaguião',NULL,NULL,NULL),(192,'12',16,1,'Valpaços',NULL,NULL,NULL),(193,'13',16,1,'Vila Pouca de Aguiar',NULL,NULL,NULL),(194,'14',16,1,'Vila Real',NULL,NULL,NULL),(195,'01',17,1,'Armamar',NULL,NULL,NULL),(196,'02',17,1,'Carregal do Sal',NULL,NULL,NULL),(197,'03',17,1,'Castro Daire',NULL,NULL,NULL),(198,'04',17,1,'Cinfães',NULL,NULL,NULL),(199,'05',17,1,'Lamego',NULL,NULL,NULL),(200,'06',17,1,'Mangualde',NULL,NULL,NULL),(201,'07',17,1,'Moimenta da Beira',NULL,NULL,NULL),(202,'08',17,1,'Mortágua',NULL,NULL,NULL),(203,'09',17,1,'Nelas',NULL,NULL,NULL),(204,'10',17,1,'Oliveira de Frades',NULL,NULL,NULL),(205,'11',17,1,'Penalva do Castelo',NULL,NULL,NULL),(206,'12',17,1,'Penedono',NULL,NULL,NULL),(207,'13',17,1,'Resende',NULL,NULL,NULL),(208,'14',17,1,'Santa Comba Dão',NULL,NULL,NULL),(209,'15',17,1,'São João da Pesqueira',NULL,NULL,NULL),(210,'16',17,1,'São Pedro do Sul',NULL,NULL,NULL),(211,'17',17,1,'Sátão',NULL,NULL,NULL),(212,'18',17,1,'Sernancelhe',NULL,NULL,NULL),(213,'19',17,1,'Tabuaço',NULL,NULL,NULL),(214,'20',17,1,'Tarouca',NULL,NULL,NULL),(215,'21',17,1,'Tondela',NULL,NULL,NULL),(216,'22',17,1,'Vila Nova de Paiva',NULL,NULL,NULL),(217,'23',17,1,'Viseu',NULL,NULL,NULL),(218,'24',17,1,'Vouzela',NULL,NULL,NULL),(219,'01',18,1,'Calheta (Madeira)',NULL,NULL,NULL),(220,'02',18,1,'Câmara de Lobos',NULL,NULL,NULL),(221,'03',18,1,'Funchal',NULL,NULL,NULL),(222,'04',18,1,'Machico',NULL,NULL,NULL),(223,'05',18,1,'Ponta do Sol',NULL,NULL,NULL),(224,'06',18,1,'Porto Moniz',NULL,NULL,NULL),(225,'07',18,1,'Ribeira Brava',NULL,NULL,NULL),(226,'08',18,1,'Santa Cruz',NULL,NULL,NULL),(227,'09',18,1,'Santana',NULL,NULL,NULL),(228,'10',18,1,'São Vicente',NULL,NULL,NULL),(229,'01',19,1,'Porto Santo',NULL,NULL,NULL),(230,'01',20,1,'Vila do Porto',NULL,NULL,NULL),(231,'01',21,1,'Lagoa (São Miguel)',NULL,NULL,NULL),(232,'02',21,1,'Nordeste',NULL,NULL,NULL),(233,'03',21,1,'Ponta Delgada',NULL,NULL,NULL),(234,'04',21,1,'Povoação',NULL,NULL,NULL),(235,'05',21,1,'Ribeira Grande',NULL,NULL,NULL),(236,'06',21,1,'Vila Franca do Campo',NULL,NULL,NULL),(237,'01',22,1,'Angra do Heroísmo',NULL,NULL,NULL),(238,'02',22,1,'Praia da Vitória',NULL,NULL,NULL),(239,'01',23,1,'Santa Cruz da Graciosa',NULL,NULL,NULL),(240,'01',24,1,'Calheta (São Jorge)',NULL,NULL,NULL),(241,'02',24,1,'Velas',NULL,NULL,NULL),(242,'01',25,1,'Lajes do Pico',NULL,NULL,NULL),(243,'02',25,1,'Madalena',NULL,NULL,NULL),(244,'03',25,1,'São Roque do Pico',NULL,NULL,NULL),(245,'01',26,1,'Horta',NULL,NULL,NULL),(246,'01',27,1,'Lajes das Flores',NULL,NULL,NULL),(247,'02',27,1,'Santa Cruz das Flores',NULL,NULL,NULL),(248,'01',28,1,'Corvo',NULL,NULL,NULL),(249,'03',29,1,'Anadia',NULL,NULL,NULL),(250,'04',29,1,'Arouca',NULL,NULL,NULL),(251,'05',29,1,'Aveiro',NULL,NULL,NULL),(252,'06',29,1,'Castelo de Paiva',NULL,NULL,NULL),(253,'07',29,1,'Espinho',NULL,NULL,NULL),(254,'08',29,1,'Estarreja',NULL,NULL,NULL),(255,'09',29,1,'Santa Maria da Feira',NULL,NULL,NULL),(256,'10',29,1,'Ãlhavo',NULL,NULL,NULL),(257,'11',29,1,'Mealhada',NULL,NULL,NULL),(258,'12',29,1,'Murtosa',NULL,NULL,NULL),(259,'13',29,1,'Oliveira de Azeméis',NULL,NULL,NULL),(260,'14',29,1,'Oliveira do Bairro',NULL,NULL,NULL),(261,'15',29,1,'Ovar',NULL,NULL,NULL),(262,'16',29,1,'São João da Madeira',NULL,NULL,NULL),(263,'17',29,1,'Sever do Vouga',NULL,NULL,NULL),(264,'18',29,1,'Vagos',NULL,NULL,NULL),(265,'19',29,1,'Vale de Cambra',NULL,NULL,NULL),(266,'01',30,1,'Aljustrel',NULL,NULL,NULL),(267,'02',30,1,'AlmodÃ´var',NULL,NULL,NULL),(268,'03',30,1,'Alvito',NULL,NULL,NULL),(269,'04',30,1,'Barrancos',NULL,NULL,NULL),(270,'05',30,1,'Beja',NULL,NULL,NULL),(271,'06',30,1,'Castro Verde',NULL,NULL,NULL),(272,'07',30,1,'Cuba',NULL,NULL,NULL),(273,'08',30,1,'Ferreira do Alentejo',NULL,NULL,NULL),(274,'09',30,1,'Mértola',NULL,NULL,NULL),(275,'10',30,1,'Moura',NULL,NULL,NULL),(276,'11',30,1,'Odemira',NULL,NULL,NULL),(277,'12',30,1,'Ourique',NULL,NULL,NULL),(278,'13',30,1,'Serpa',NULL,NULL,NULL),(279,'14',30,1,'Vidigueira',NULL,NULL,NULL),(280,'01',2,1,'Amares',NULL,NULL,NULL),(281,'02',2,1,'Barcelos',NULL,NULL,NULL),(282,'03',2,1,'Braga',NULL,NULL,NULL),(283,'04',2,1,'Cabeceiras de Basto',NULL,NULL,NULL),(284,'05',2,1,'Celorico de Basto',NULL,NULL,NULL),(285,'06',2,1,'Esposende',NULL,NULL,NULL),(286,'07',2,1,'Fafe',NULL,NULL,NULL),(287,'08',2,1,'Guimarães',NULL,NULL,NULL),(288,'09',2,1,'Póvoa de Lanhoso',NULL,NULL,NULL),(289,'10',2,1,'Terras de Bouro',NULL,NULL,NULL),(290,'11',2,1,'Vieira do Minho',NULL,NULL,NULL),(291,'12',2,1,'Vila Nova de Famalicão',NULL,NULL,NULL),(292,'13',2,1,'Vila Verde',NULL,NULL,NULL),(293,'14',2,1,'Vizela',NULL,NULL,NULL),(294,'01',3,1,'Alfandega da Fé',NULL,NULL,NULL),(295,'02',3,1,'Bragança',NULL,NULL,NULL),(296,'03',3,1,'Carrazeda de Ansiães',NULL,NULL,NULL),(297,'04',3,1,'Freixo Espada Ã  Cinta',NULL,NULL,NULL),(298,'05',3,1,'Macedo de Cavaleiros',NULL,NULL,NULL),(299,'06',3,1,'Miranda do Douro',NULL,NULL,NULL),(300,'07',3,1,'Mirandela',NULL,NULL,NULL),(301,'08',3,1,'Mogadouro',NULL,NULL,NULL),(302,'09',3,1,'Torre de Moncorvo',NULL,NULL,NULL),(303,'10',3,1,'Vila Flor',NULL,NULL,NULL),(304,'11',3,1,'Vimioso',NULL,NULL,NULL),(305,'12',3,1,'Vinhais',NULL,NULL,NULL),(306,'01',4,1,'Belmonte',NULL,NULL,NULL),(307,'02',4,1,'Castelo Branco',NULL,NULL,NULL),(308,'03',4,1,'Covilhã',NULL,NULL,NULL),(309,'04',4,1,'Fundão',NULL,NULL,NULL),(310,'05',4,1,'Idanha-a-Nova',NULL,NULL,NULL),(311,'06',4,1,'Oleiros',NULL,NULL,NULL),(312,'07',4,1,'Penamacor',NULL,NULL,NULL),(313,'08',4,1,'Proença-a-Nova',NULL,NULL,NULL),(314,'09',4,1,'Sertã',NULL,NULL,NULL),(315,'10',4,1,'Vila de Rei',NULL,NULL,NULL),(316,'11',4,1,'Vila Velha de Rodão',NULL,NULL,NULL),(317,'01',5,1,'Arganil',NULL,NULL,NULL),(318,'02',5,1,'Cantanhede',NULL,NULL,NULL),(319,'03',5,1,'Coimbra',NULL,NULL,NULL),(320,'04',5,1,'Condeixa-a-Nova',NULL,NULL,NULL),(321,'05',5,1,'Figueira da Foz',NULL,NULL,NULL),(322,'06',5,1,'Góis',NULL,NULL,NULL),(323,'07',5,1,'Lousã',NULL,NULL,NULL),(324,'08',5,1,'Mira',NULL,NULL,NULL),(325,'09',5,1,'Miranda do Corvo',NULL,NULL,NULL),(326,'10',5,1,'Montemor-o-Velho',NULL,NULL,NULL),(327,'11',5,1,'Oliveira do Hospital',NULL,NULL,NULL),(328,'12',5,1,'Pampilhosa da Serra',NULL,NULL,NULL),(329,'13',5,1,'Penacova',NULL,NULL,NULL),(330,'14',5,1,'Penela',NULL,NULL,NULL),(331,'15',5,1,'Soure',NULL,NULL,NULL),(332,'16',5,1,'Tábua',NULL,NULL,NULL),(333,'17',5,1,'Vila Nova de Poiares',NULL,NULL,NULL),(334,'01',6,1,'Alandroal',NULL,NULL,NULL),(335,'02',6,1,'Arraiolos',NULL,NULL,NULL),(336,'03',6,1,'Borba',NULL,NULL,NULL),(337,'04',6,1,'Estremoz',NULL,NULL,NULL),(338,'05',6,1,'Ã‰vora',NULL,NULL,NULL),(339,'06',6,1,'Montemor-o-Novo',NULL,NULL,NULL);

--
-- Table structure for table `DOMAIN_OBJECT_ACTION_LOG`
--

CREATE TABLE `DOMAIN_OBJECT_ACTION_LOG` (
  `ACTION` longtext,
  `DOMAIN_OBJECT_CLASS_NAME` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `INSTANT` timestamp NULL DEFAULT NULL,
  `KEY_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_PERSON` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_PERSON` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `PERSON_USERNAME` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_PERSON` (`KEY_PERSON`),
  KEY `OID_PERSON` (`OID_PERSON`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DOMAIN_OBJECT_ACTION_LOG`
--


--
-- Table structure for table `DOMAIN_OBJECT_ACTION_LOG_ENTRY`
--

CREATE TABLE `DOMAIN_OBJECT_ACTION_LOG_ENTRY` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DOMAIN_OBJECT_ACTION_LOG` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `NAME` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DOMAIN_OBJECT_ACTION_LOG` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `VALUE` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DOMAIN_OBJECT_ACTION_LOG` (`KEY_DOMAIN_OBJECT_ACTION_LOG`),
  KEY `OID_DOMAIN_OBJECT_ACTION_LOG` (`OID_DOMAIN_OBJECT_ACTION_LOG`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DOMAIN_OBJECT_ACTION_LOG_ENTRY`
--


--
-- Table structure for table `EDUCATION_AREA`
--

CREATE TABLE `EDUCATION_AREA` (
  `CODE` longtext,
  `DESCRIPTION` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_PARENT_AREA` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_PARENT_AREA` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_PARENT_AREA` (`KEY_PARENT_AREA`),
  KEY `OID_PARENT_AREA` (`OID_PARENT_AREA`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EDUCATION_AREA`
--


--
-- Table structure for table `EMAIL`
--

CREATE TABLE `EMAIL` (
  `BCC_ADDRESSES` longtext,
  `BODY` longtext,
  `CC_ADDRESSES` longtext,
  `FROM_ADDRESS` longtext,
  `FROM_NAME` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `REPLY_TOS` longtext,
  `SUBJECT` longtext,
  `TO_ADDRESSES` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMAIL`
--


--
-- Table structure for table `EMPLOYEE`
--

CREATE TABLE `EMPLOYEE` (
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CREATION_DATE` timestamp NULL DEFAULT NULL,
  `EMPLOYEE_NUMBER` int(11) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ASSIDUOUSNESS` int(11) DEFAULT NULL,
  `KEY_PERSON` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ASSIDUOUSNESS` bigint(20) DEFAULT NULL,
  `OID_PERSON` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `WORKING_HOURS` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ASSIDUOUSNESS` (`KEY_ASSIDUOUSNESS`),
  KEY `OID_ASSIDUOUSNESS` (`OID_ASSIDUOUSNESS`),
  KEY `KEY_PERSON` (`KEY_PERSON`),
  KEY `OID_PERSON` (`OID_PERSON`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE`
--


--
-- Table structure for table `EMPLOYEE_BONUS_INSTALLMENT`
--

CREATE TABLE `EMPLOYEE_BONUS_INSTALLMENT` (
  `BONUS_TYPE` text,
  `COST_CENTER_CODE` int(11) DEFAULT NULL,
  `EXPLORATION_UNIT` int(11) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ANUAL_BONUS_INSTALLMENT` int(11) DEFAULT NULL,
  `KEY_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ANUAL_BONUS_INSTALLMENT` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `SUB_COST_CENTER_CODE` longtext,
  `VALUE` double DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ANUAL_BONUS_INSTALLMENT` (`KEY_ANUAL_BONUS_INSTALLMENT`),
  KEY `OID_ANUAL_BONUS_INSTALLMENT` (`OID_ANUAL_BONUS_INSTALLMENT`),
  KEY `KEY_EMPLOYEE` (`KEY_EMPLOYEE`),
  KEY `OID_EMPLOYEE` (`OID_EMPLOYEE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE_BONUS_INSTALLMENT`
--


--
-- Table structure for table `EMPLOYEE_CONTRACT_SITUATION`
--

CREATE TABLE `EMPLOYEE_CONTRACT_SITUATION` (
  `ANULATION_DATE` timestamp NULL DEFAULT NULL,
  `BEGIN_DATE` text,
  `CREATION_DATE` timestamp NULL DEFAULT NULL,
  `END_DATE` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `IMPORTATION_DATE` timestamp NULL DEFAULT NULL,
  `KEY_CONTRACT_SITUATION` int(11) DEFAULT NULL,
  `KEY_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_PROFESSIONAL_CATEGORY` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `MODIFIED_DATE` timestamp NULL DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_CONTRACT_SITUATION` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_PROFESSIONAL_CATEGORY` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `STEP` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_CONTRACT_SITUATION` (`KEY_CONTRACT_SITUATION`),
  KEY `OID_CONTRACT_SITUATION` (`OID_CONTRACT_SITUATION`),
  KEY `KEY_EMPLOYEE` (`KEY_EMPLOYEE`),
  KEY `OID_EMPLOYEE` (`OID_EMPLOYEE`),
  KEY `KEY_PROFESSIONAL_CATEGORY` (`KEY_PROFESSIONAL_CATEGORY`),
  KEY `OID_PROFESSIONAL_CATEGORY` (`OID_PROFESSIONAL_CATEGORY`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE_CONTRACT_SITUATION`
--


--
-- Table structure for table `EMPLOYEE_EXTRA_WORK_AUTHORIZATION`
--

CREATE TABLE `EMPLOYEE_EXTRA_WORK_AUTHORIZATION` (
  `AUXILIAR_PERSONEL` tinyint(1) DEFAULT NULL,
  `EXECUTIVE_AUXILIAR_PERSONEL` tinyint(1) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ASSIDUOUSNESS` int(11) DEFAULT NULL,
  `KEY_EXTRA_WORK_AUTHORIZATION` int(11) DEFAULT NULL,
  `KEY_MODIFIED_BY` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `LAST_MODIFIED_DATE` timestamp NULL DEFAULT NULL,
  `NIGHT_EXTRA_WORK` tinyint(1) DEFAULT NULL,
  `NORMAL_EXTRA_WORK` tinyint(1) DEFAULT NULL,
  `NORMAL_EXTRA_WORK_PLUS_ONE_HUNDRED_HOURS` tinyint(1) DEFAULT NULL,
  `NORMAL_EXTRA_WORK_PLUS_TWO_HOURS` tinyint(1) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ASSIDUOUSNESS` bigint(20) DEFAULT NULL,
  `OID_EXTRA_WORK_AUTHORIZATION` bigint(20) DEFAULT NULL,
  `OID_MODIFIED_BY` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `WEEKLY_REST_EXTRA_WORK` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ASSIDUOUSNESS` (`KEY_ASSIDUOUSNESS`),
  KEY `OID_ASSIDUOUSNESS` (`OID_ASSIDUOUSNESS`),
  KEY `KEY_EXTRA_WORK_AUTHORIZATION` (`KEY_EXTRA_WORK_AUTHORIZATION`),
  KEY `OID_EXTRA_WORK_AUTHORIZATION` (`OID_EXTRA_WORK_AUTHORIZATION`),
  KEY `KEY_MODIFIED_BY` (`KEY_MODIFIED_BY`),
  KEY `OID_MODIFIED_BY` (`OID_MODIFIED_BY`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE_EXTRA_WORK_AUTHORIZATION`
--


--
-- Table structure for table `EMPLOYEE_FUNCTIONS_ACCUMULATION`
--

CREATE TABLE `EMPLOYEE_FUNCTIONS_ACCUMULATION` (
  `ANULATION_DATE` timestamp NULL DEFAULT NULL,
  `BEGIN_DATE` text,
  `CREATION_DATE` timestamp NULL DEFAULT NULL,
  `END_DATE` text,
  `HOURS` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `IMPORTATION_DATE` timestamp NULL DEFAULT NULL,
  `KEY_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_FUNCTIONS_ACCUMULATION` int(11) DEFAULT NULL,
  `KEY_PROFESSIONAL_REGIME` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `MODIFIED_DATE` timestamp NULL DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_FUNCTIONS_ACCUMULATION` bigint(20) DEFAULT NULL,
  `OID_PROFESSIONAL_REGIME` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EMPLOYEE` (`KEY_EMPLOYEE`),
  KEY `OID_EMPLOYEE` (`OID_EMPLOYEE`),
  KEY `KEY_FUNCTIONS_ACCUMULATION` (`KEY_FUNCTIONS_ACCUMULATION`),
  KEY `OID_FUNCTIONS_ACCUMULATION` (`OID_FUNCTIONS_ACCUMULATION`),
  KEY `KEY_PROFESSIONAL_REGIME` (`KEY_PROFESSIONAL_REGIME`),
  KEY `OID_PROFESSIONAL_REGIME` (`OID_PROFESSIONAL_REGIME`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE_FUNCTIONS_ACCUMULATION`
--


--
-- Table structure for table `EMPLOYEE_HISTORIC`
--

CREATE TABLE `EMPLOYEE_HISTORIC` (
  `BEGIN_DATE_YEAR_MONTH_DAY` longtext,
  `CALENDAR` longtext,
  `END_DATE_YEAR_MONTH_DAY` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_MAILING_COST_CENTER` int(11) DEFAULT NULL,
  `KEY_RESPONSABLE_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_SALARY_COST_CENTER` int(11) DEFAULT NULL,
  `KEY_WORKING_PLACE_COST_CENTER` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_MAILING_COST_CENTER` bigint(20) DEFAULT NULL,
  `OID_RESPONSABLE_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_SALARY_COST_CENTER` bigint(20) DEFAULT NULL,
  `OID_WORKING_PLACE_COST_CENTER` bigint(20) DEFAULT NULL,
  `WHEN_DATE_TIME` timestamp NULL DEFAULT NULL,
  `WHO` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EMPLOYEE` (`KEY_EMPLOYEE`),
  KEY `OID_EMPLOYEE` (`OID_EMPLOYEE`),
  KEY `KEY_MAILING_COST_CENTER` (`KEY_MAILING_COST_CENTER`),
  KEY `OID_MAILING_COST_CENTER` (`OID_MAILING_COST_CENTER`),
  KEY `KEY_RESPONSABLE_EMPLOYEE` (`KEY_RESPONSABLE_EMPLOYEE`),
  KEY `OID_RESPONSABLE_EMPLOYEE` (`OID_RESPONSABLE_EMPLOYEE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_SALARY_COST_CENTER` (`KEY_SALARY_COST_CENTER`),
  KEY `OID_SALARY_COST_CENTER` (`OID_SALARY_COST_CENTER`),
  KEY `KEY_WORKING_PLACE_COST_CENTER` (`KEY_WORKING_PLACE_COST_CENTER`),
  KEY `OID_WORKING_PLACE_COST_CENTER` (`OID_WORKING_PLACE_COST_CENTER`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE_HISTORIC`
--


--
-- Table structure for table `EMPLOYEE_MONTHLY_BONUS_INSTALLMENT`
--

CREATE TABLE `EMPLOYEE_MONTHLY_BONUS_INSTALLMENT` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EMPLOYEE_BONUS_INSTALLMENT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE_BONUS_INSTALLMENT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `PARTIAL_YEAR_MONTH` longtext,
  `VALUE` double DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EMPLOYEE_BONUS_INSTALLMENT` (`KEY_EMPLOYEE_BONUS_INSTALLMENT`),
  KEY `OID_EMPLOYEE_BONUS_INSTALLMENT` (`OID_EMPLOYEE_BONUS_INSTALLMENT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE_MONTHLY_BONUS_INSTALLMENT`
--


--
-- Table structure for table `EMPLOYEE_PROFESSIONAL_CATEGORY`
--

CREATE TABLE `EMPLOYEE_PROFESSIONAL_CATEGORY` (
  `ANULATION_DATE` timestamp NULL DEFAULT NULL,
  `BEGIN_DATE` text,
  `CREATION_DATE` timestamp NULL DEFAULT NULL,
  `END_DATE` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `IMPORTATION_DATE` timestamp NULL DEFAULT NULL,
  `KEY_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_PROFESSIONAL_CATEGORY` int(11) DEFAULT NULL,
  `KEY_PROFESSIONAL_REGIME` int(11) DEFAULT NULL,
  `KEY_PROFESSIONAL_RELATION` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `LEVEL` longtext,
  `MODIFIED_DATE` timestamp NULL DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_PROFESSIONAL_CATEGORY` bigint(20) DEFAULT NULL,
  `OID_PROFESSIONAL_REGIME` bigint(20) DEFAULT NULL,
  `OID_PROFESSIONAL_RELATION` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `STEP` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EMPLOYEE` (`KEY_EMPLOYEE`),
  KEY `OID_EMPLOYEE` (`OID_EMPLOYEE`),
  KEY `KEY_PROFESSIONAL_CATEGORY` (`KEY_PROFESSIONAL_CATEGORY`),
  KEY `OID_PROFESSIONAL_CATEGORY` (`OID_PROFESSIONAL_CATEGORY`),
  KEY `KEY_PROFESSIONAL_REGIME` (`KEY_PROFESSIONAL_REGIME`),
  KEY `OID_PROFESSIONAL_REGIME` (`OID_PROFESSIONAL_REGIME`),
  KEY `KEY_PROFESSIONAL_RELATION` (`KEY_PROFESSIONAL_RELATION`),
  KEY `OID_PROFESSIONAL_RELATION` (`OID_PROFESSIONAL_RELATION`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE_PROFESSIONAL_CATEGORY`
--


--
-- Table structure for table `EMPLOYEE_PROFESSIONAL_CONTRACT`
--

CREATE TABLE `EMPLOYEE_PROFESSIONAL_CONTRACT` (
  `ANULATION_DATE` timestamp NULL DEFAULT NULL,
  `BEGIN_DATE` text,
  `CREATION_DATE` timestamp NULL DEFAULT NULL,
  `END_DATE` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `IMPORTATION_DATE` timestamp NULL DEFAULT NULL,
  `KEY_CONTRACT_SITUATION` int(11) DEFAULT NULL,
  `KEY_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `MODIFIED_DATE` timestamp NULL DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_CONTRACT_SITUATION` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_CONTRACT_SITUATION` (`KEY_CONTRACT_SITUATION`),
  KEY `OID_CONTRACT_SITUATION` (`OID_CONTRACT_SITUATION`),
  KEY `KEY_EMPLOYEE` (`KEY_EMPLOYEE`),
  KEY `OID_EMPLOYEE` (`OID_EMPLOYEE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE_PROFESSIONAL_CONTRACT`
--


--
-- Table structure for table `EMPLOYEE_PROFESSIONAL_EXEMPTION`
--

CREATE TABLE `EMPLOYEE_PROFESSIONAL_EXEMPTION` (
  `ANULATION_DATE` timestamp NULL DEFAULT NULL,
  `BEGIN_DATE` text,
  `CREATION_DATE` timestamp NULL DEFAULT NULL,
  `END_DATE` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `IMPORTATION_DATE` timestamp NULL DEFAULT NULL,
  `KEY_COUNTRY` int(11) DEFAULT NULL,
  `KEY_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_GRANT_OWNER_EQUIVALENT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_SERVICE_EXEMPTION` int(11) DEFAULT NULL,
  `LOCAL` longtext,
  `MODIFIED_DATE` timestamp NULL DEFAULT NULL,
  `MOTIVE` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_COUNTRY` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_GRANT_OWNER_EQUIVALENT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_SERVICE_EXEMPTION` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_COUNTRY` (`KEY_COUNTRY`),
  KEY `OID_COUNTRY` (`OID_COUNTRY`),
  KEY `KEY_EMPLOYEE` (`KEY_EMPLOYEE`),
  KEY `OID_EMPLOYEE` (`OID_EMPLOYEE`),
  KEY `KEY_GRANT_OWNER_EQUIVALENT` (`KEY_GRANT_OWNER_EQUIVALENT`),
  KEY `OID_GRANT_OWNER_EQUIVALENT` (`OID_GRANT_OWNER_EQUIVALENT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_SERVICE_EXEMPTION` (`KEY_SERVICE_EXEMPTION`),
  KEY `OID_SERVICE_EXEMPTION` (`OID_SERVICE_EXEMPTION`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE_PROFESSIONAL_EXEMPTION`
--


--
-- Table structure for table `EMPLOYEE_PROFESSIONAL_REGIME`
--

CREATE TABLE `EMPLOYEE_PROFESSIONAL_REGIME` (
  `ANULATION_DATE` timestamp NULL DEFAULT NULL,
  `BEGIN_DATE` text,
  `CREATION_DATE` timestamp NULL DEFAULT NULL,
  `END_DATE` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `IMPORTATION_DATE` timestamp NULL DEFAULT NULL,
  `KEY_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_PROFESSIONAL_REGIME` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `MODIFIED_DATE` timestamp NULL DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_PROFESSIONAL_REGIME` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EMPLOYEE` (`KEY_EMPLOYEE`),
  KEY `OID_EMPLOYEE` (`OID_EMPLOYEE`),
  KEY `KEY_PROFESSIONAL_REGIME` (`KEY_PROFESSIONAL_REGIME`),
  KEY `OID_PROFESSIONAL_REGIME` (`OID_PROFESSIONAL_REGIME`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE_PROFESSIONAL_REGIME`
--


--
-- Table structure for table `EMPLOYEE_PROFESSIONAL_RELATION`
--

CREATE TABLE `EMPLOYEE_PROFESSIONAL_RELATION` (
  `ANULATION_DATE` timestamp NULL DEFAULT NULL,
  `BEGIN_DATE` text,
  `CREATION_DATE` timestamp NULL DEFAULT NULL,
  `END_DATE` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `IMPORTATION_DATE` timestamp NULL DEFAULT NULL,
  `KEY_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_PROFESSIONAL_CATEGORY` int(11) DEFAULT NULL,
  `KEY_PROFESSIONAL_RELATION` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `MODIFIED_DATE` timestamp NULL DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_PROFESSIONAL_CATEGORY` bigint(20) DEFAULT NULL,
  `OID_PROFESSIONAL_RELATION` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EMPLOYEE` (`KEY_EMPLOYEE`),
  KEY `OID_EMPLOYEE` (`OID_EMPLOYEE`),
  KEY `KEY_PROFESSIONAL_CATEGORY` (`KEY_PROFESSIONAL_CATEGORY`),
  KEY `OID_PROFESSIONAL_CATEGORY` (`OID_PROFESSIONAL_CATEGORY`),
  KEY `KEY_PROFESSIONAL_RELATION` (`KEY_PROFESSIONAL_RELATION`),
  KEY `OID_PROFESSIONAL_RELATION` (`OID_PROFESSIONAL_RELATION`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE_PROFESSIONAL_RELATION`
--


--
-- Table structure for table `ENROLMENT_EVALUATION`
--

CREATE TABLE `ENROLMENT_EVALUATION` (
  `CHECK_SUM` longtext,
  `ENROLMENT_EVALUATION_STATE` int(11) DEFAULT NULL,
  `ENROLMENT_EVALUATION_TYPE` text,
  `EXAM_DATE_YEAR_MONTH_DAY` longtext,
  `GRADE` longtext,
  `GRADE_AVAILABLE_DATE_YEAR_MONTH_DAY` longtext,
  `GRADE_VALUE` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_ENROLMENT` int(11) DEFAULT NULL,
  `KEY_EXECUTION_PERIOD` int(11) DEFAULT NULL,
  `KEY_IMPROVEMENT_OF_APPROVED_ENROLMENT_EVENT` int(11) DEFAULT NULL,
  `KEY_MARK_SHEET` int(11) DEFAULT NULL,
  `KEY_PERSON_RESPONSIBLE_FOR_GRADE` int(11) DEFAULT NULL,
  `KEY_RECTIFICATION` int(11) DEFAULT NULL,
  `KEY_RECTIFIED` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OBSERVATION` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_ENROLMENT` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_PERIOD` bigint(20) DEFAULT NULL,
  `OID_IMPROVEMENT_OF_APPROVED_ENROLMENT_EVENT` bigint(20) DEFAULT NULL,
  `OID_MARK_SHEET` bigint(20) DEFAULT NULL,
  `OID_PERSON_RESPONSIBLE_FOR_GRADE` bigint(20) DEFAULT NULL,
  `OID_RECTIFICATION` bigint(20) DEFAULT NULL,
  `OID_RECTIFIED` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `WHEN_DATE_TIME` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EMPLOYEE` (`KEY_EMPLOYEE`),
  KEY `OID_EMPLOYEE` (`OID_EMPLOYEE`),
  KEY `KEY_ENROLMENT` (`KEY_ENROLMENT`),
  KEY `OID_ENROLMENT` (`OID_ENROLMENT`),
  KEY `KEY_EXECUTION_PERIOD` (`KEY_EXECUTION_PERIOD`),
  KEY `OID_EXECUTION_PERIOD` (`OID_EXECUTION_PERIOD`),
  KEY `KEY_IMPROVEMENT_OF_APPROVED_ENROLMENT_EVENT` (`KEY_IMPROVEMENT_OF_APPROVED_ENROLMENT_EVENT`),
  KEY `OID_IMPROVEMENT_OF_APPROVED_ENROLMENT_EVENT` (`OID_IMPROVEMENT_OF_APPROVED_ENROLMENT_EVENT`),
  KEY `KEY_MARK_SHEET` (`KEY_MARK_SHEET`),
  KEY `OID_MARK_SHEET` (`OID_MARK_SHEET`),
  KEY `KEY_PERSON_RESPONSIBLE_FOR_GRADE` (`KEY_PERSON_RESPONSIBLE_FOR_GRADE`),
  KEY `OID_PERSON_RESPONSIBLE_FOR_GRADE` (`OID_PERSON_RESPONSIBLE_FOR_GRADE`),
  KEY `KEY_RECTIFICATION` (`KEY_RECTIFICATION`),
  KEY `OID_RECTIFICATION` (`OID_RECTIFICATION`),
  KEY `KEY_RECTIFIED` (`KEY_RECTIFIED`),
  KEY `OID_RECTIFIED` (`OID_RECTIFIED`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ENROLMENT_EVALUATION`
--


--
-- Table structure for table `ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE`
--

CREATE TABLE `ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE` (
  `KEY_ENROLMENT` int(11) NOT NULL,
  `KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE` int(11) NOT NULL,
  `OID_ENROLMENT` bigint(20) unsigned DEFAULT NULL,
  `OID_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_ENROLMENT`,`KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE`),
  KEY `KEY_ENROLMENT` (`KEY_ENROLMENT`),
  KEY `KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE` (`KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE`),
  KEY `OID_ENROLMENT` (`OID_ENROLMENT`,`OID_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE`),
  KEY `OID_ENROLMENT_2` (`OID_ENROLMENT`),
  KEY `OID_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE` (`OID_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE`
--


--
-- Table structure for table `ENROLMENT_PERIOD`
--

CREATE TABLE `ENROLMENT_PERIOD` (
  `END_DATE_DATE_TIME` timestamp NULL DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DEGREE_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `KEY_EXECUTION_PERIOD` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DEGREE_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_PERIOD` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `START_DATE_DATE_TIME` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DEGREE_CURRICULAR_PLAN` (`KEY_DEGREE_CURRICULAR_PLAN`),
  KEY `OID_DEGREE_CURRICULAR_PLAN` (`OID_DEGREE_CURRICULAR_PLAN`),
  KEY `KEY_EXECUTION_PERIOD` (`KEY_EXECUTION_PERIOD`),
  KEY `OID_EXECUTION_PERIOD` (`OID_EXECUTION_PERIOD`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ENROLMENT_PERIOD`
--


--
-- Table structure for table `ENROLMENT_WRAPPER`
--

CREATE TABLE `ENROLMENT_WRAPPER` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_CREDITS` int(11) DEFAULT NULL,
  `KEY_ENROLMENT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_CREDITS` bigint(20) DEFAULT NULL,
  `OID_ENROLMENT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_CREDITS` (`KEY_CREDITS`),
  KEY `OID_CREDITS` (`OID_CREDITS`),
  KEY `KEY_ENROLMENT` (`KEY_ENROLMENT`),
  KEY `OID_ENROLMENT` (`OID_ENROLMENT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ENROLMENT_WRAPPER`
--


--
-- Table structure for table `ENTRY`
--

CREATE TABLE `ENTRY` (
  `ENTRY_TYPE` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ACCOUNT` int(11) DEFAULT NULL,
  `KEY_ACCOUNTING_TRANSACTION` int(11) DEFAULT NULL,
  `KEY_ADJUSTMENT_CREDIT_NOTE_ENTRY` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ACCOUNT` bigint(20) DEFAULT NULL,
  `OID_ACCOUNTING_TRANSACTION` bigint(20) DEFAULT NULL,
  `OID_ADJUSTMENT_CREDIT_NOTE_ENTRY` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `ORIGINAL_AMOUNT` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ACCOUNT` (`KEY_ACCOUNT`),
  KEY `OID_ACCOUNT` (`OID_ACCOUNT`),
  KEY `KEY_ACCOUNTING_TRANSACTION` (`KEY_ACCOUNTING_TRANSACTION`),
  KEY `OID_ACCOUNTING_TRANSACTION` (`OID_ACCOUNTING_TRANSACTION`),
  KEY `KEY_ADJUSTMENT_CREDIT_NOTE_ENTRY` (`KEY_ADJUSTMENT_CREDIT_NOTE_ENTRY`),
  KEY `OID_ADJUSTMENT_CREDIT_NOTE_ENTRY` (`OID_ADJUSTMENT_CREDIT_NOTE_ENTRY`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ENTRY`
--


--
-- Table structure for table `EQUIVALENCE_PLAN`
--

CREATE TABLE `EQUIVALENCE_PLAN` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DEGREE_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `KEY_OLD_STUDENT_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_SOURCE_DEGREE_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DEGREE_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OID_OLD_STUDENT_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_SOURCE_DEGREE_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DEGREE_CURRICULAR_PLAN` (`KEY_DEGREE_CURRICULAR_PLAN`),
  KEY `OID_DEGREE_CURRICULAR_PLAN` (`OID_DEGREE_CURRICULAR_PLAN`),
  KEY `KEY_OLD_STUDENT_CURRICULAR_PLAN` (`KEY_OLD_STUDENT_CURRICULAR_PLAN`),
  KEY `OID_OLD_STUDENT_CURRICULAR_PLAN` (`OID_OLD_STUDENT_CURRICULAR_PLAN`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_SOURCE_DEGREE_CURRICULAR_PLAN` (`KEY_SOURCE_DEGREE_CURRICULAR_PLAN`),
  KEY `OID_SOURCE_DEGREE_CURRICULAR_PLAN` (`OID_SOURCE_DEGREE_CURRICULAR_PLAN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EQUIVALENCE_PLAN`
--


--
-- Table structure for table `EQUIVALENCE_PLAN_ENTRY`
--

CREATE TABLE `EQUIVALENCE_PLAN_ENTRY` (
  `ECTS_CREDITS` double DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EQUIVALENCE_PLAN` int(11) DEFAULT NULL,
  `KEY_PREVIOUS_COURSE_GROUP_FOR_NEW_DEGREE_MODULES` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `NEW_DEGREE_MODULES_OPERATOR` text,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EQUIVALENCE_PLAN` bigint(20) DEFAULT NULL,
  `OID_PREVIOUS_COURSE_GROUP_FOR_NEW_DEGREE_MODULES` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `SOURCE_DEGREE_MODULES_OPERATOR` text,
  `TRANSITIVE_SOURCE` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EQUIVALENCE_PLAN` (`KEY_EQUIVALENCE_PLAN`),
  KEY `OID_EQUIVALENCE_PLAN` (`OID_EQUIVALENCE_PLAN`),
  KEY `KEY_PREVIOUS_COURSE_GROUP_FOR_NEW_DEGREE_MODULES` (`KEY_PREVIOUS_COURSE_GROUP_FOR_NEW_DEGREE_MODULES`),
  KEY `OID_PREVIOUS_COURSE_GROUP_FOR_NEW_DEGREE_MODULES` (`OID_PREVIOUS_COURSE_GROUP_FOR_NEW_DEGREE_MODULES`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EQUIVALENCE_PLAN_ENTRY`
--


--
-- Table structure for table `EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE`
--

CREATE TABLE `EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE` (
  `KEY_DEGREE_MODULE` int(11) NOT NULL,
  `KEY_EQUIVALENCE_PLAN_ENTRY` int(11) NOT NULL,
  `OID_DEGREE_MODULE` bigint(20) unsigned DEFAULT NULL,
  `OID_EQUIVALENCE_PLAN_ENTRY` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_DEGREE_MODULE`,`KEY_EQUIVALENCE_PLAN_ENTRY`),
  KEY `KEY_DEGREE_MODULE` (`KEY_DEGREE_MODULE`),
  KEY `KEY_EQUIVALENCE_PLAN_ENTRY` (`KEY_EQUIVALENCE_PLAN_ENTRY`),
  KEY `OID_DEGREE_MODULE` (`OID_DEGREE_MODULE`,`OID_EQUIVALENCE_PLAN_ENTRY`),
  KEY `OID_DEGREE_MODULE_2` (`OID_DEGREE_MODULE`),
  KEY `OID_EQUIVALENCE_PLAN_ENTRY` (`OID_EQUIVALENCE_PLAN_ENTRY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE`
--


--
-- Table structure for table `EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE`
--

CREATE TABLE `EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE` (
  `KEY_DEGREE_MODULE` int(11) NOT NULL,
  `KEY_EQUIVALENCE_PLAN_ENTRY` int(11) NOT NULL,
  `OID_DEGREE_MODULE` bigint(20) unsigned DEFAULT NULL,
  `OID_EQUIVALENCE_PLAN_ENTRY` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_DEGREE_MODULE`,`KEY_EQUIVALENCE_PLAN_ENTRY`),
  KEY `KEY_DEGREE_MODULE` (`KEY_DEGREE_MODULE`),
  KEY `KEY_EQUIVALENCE_PLAN_ENTRY` (`KEY_EQUIVALENCE_PLAN_ENTRY`),
  KEY `OID_DEGREE_MODULE` (`OID_DEGREE_MODULE`,`OID_EQUIVALENCE_PLAN_ENTRY`),
  KEY `OID_DEGREE_MODULE_2` (`OID_DEGREE_MODULE`),
  KEY `OID_EQUIVALENCE_PLAN_ENTRY` (`OID_EQUIVALENCE_PLAN_ENTRY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE`
--


--
-- Table structure for table `ERROR_LOG`
--

CREATE TABLE `ERROR_LOG` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EXCEPTION` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXCEPTION` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `STACK_TRACE` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXCEPTION` (`KEY_EXCEPTION`),
  KEY `OID_EXCEPTION` (`OID_EXCEPTION`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ERROR_LOG`
--

INSERT INTO `ERROR_LOG` VALUES (1,1,1,901943132161,4170413244417,2551210573825,'StackTrace: \n net.sourceforge.fenixedu.presentationTier.Action.CreateContentsContextAction.getInitialMenuEntry(CreateContentsContextAction.java:83)\nnet.sourceforge.fenixedu.presentationTier.Action.CreateContentsContextAction.execute(CreateContentsContextAction.java:37)\norg.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)\npt.ist.fenixWebFramework.renderers.plugin.RenderersRequestProcessor.processActionPerform(RenderersRequestProcessor.java:125)\norg.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)\npt.ist.fenixWebFramework.renderers.plugin.RenderersRequestProcessor.process(RenderersRequestProcessor.java:60)\norg.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)\norg.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)\njavax.servlet.http.HttpServlet.service(HttpServlet.java:617)\njavax.servlet.http.HttpServlet.service(HttpServlet.java:717)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\nnet.sourceforge.fenixedu.presentationTier.servlets.filters.MissingCandidacyInformationFilter.doFilter(MissingCandidacyInformationFilter.java:69)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\nnet.sourceforge.fenixedu.presentationTier.servlets.filters.ContentFilter.doFilter(ContentFilter.java:49)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\nnet.sourceforge.fenixedu.presentationTier.servlets.filters.functionalities.CheckAvailabilityFilter.doFilter(CheckAvailabilityFilter.java:74)\nnet.sourceforge.fenixedu.presentationTier.servlets.filters.functionalities.CheckAvailabilityFilter.doFilter(CheckAvailabilityFilter.java:64)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\npt.ist.fenixWebFramework.servlets.filters.contentRewrite.RequestChecksumFilter.applyFilter(RequestChecksumFilter.java:70)\npt.ist.fenixWebFramework.servlets.filters.contentRewrite.RequestChecksumFilter.doFilter(RequestChecksumFilter.java:48)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\nnet.sourceforge.fenixedu.presentationTier.servlets.filters.GeneralForwardFilter.doFilter(GeneralForwardFilter.java:102)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\npt.ist.fenixWebFramework.servlets.filters.contentRewrite.RequestRewriterFilter.continueChainAndWriteResponse(RequestRewriterFilter.java:171)\npt.ist.fenixWebFramework.servlets.filters.contentRewrite.RequestRewriterFilter.doFilter(RequestRewriterFilter.java:165)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\nnet.sourceforge.fenixedu.presentationTier.servlets.filters.ContextFilter.doFilter(ContextFilter.java:50)\nnet.sourceforge.fenixedu.presentationTier.servlets.filters.ContextFilter.doFilter(ContextFilter.java:32)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\npt.ist.fenixWebFramework.servlets.filters.ProfilingFilter.doFilter(ProfilingFilter.java:35)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\npt.ist.fenixWebFramework.servlets.filters.RequestWrapperFilter.doFilter(RequestWrapperFilter.java:197)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\npt.ist.fenixWebFramework.servlets.filters.I18NFilter.doFilter(I18NFilter.java:66)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\nnet.sourceforge.fenixedu.presentationTier.servlets.filters.UncaughtExceptionFilter.doFilter(UncaughtExceptionFilter.java:27)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\npt.ist.fenixWebFramework.servlets.filters.SetUserViewFilter.doFilter(SetUserViewFilter.java:55)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\npt.ist.fenixWebFramework.servlets.filters.CloseTransactionFilter.doFilter(CloseTransactionFilter.java:34)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\npt.ist.fenixWebFramework.servlets.filters.PathAccessControlFilter.doFilter(PathAccessControlFilter.java:112)\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\norg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\norg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\norg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)\norg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)\norg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)\norg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\norg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\norg.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)\norg.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)\norg.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)\njava.lang.Thread.run(Thread.java:619)\n');

--
-- Table structure for table `EVALUATION`
--

CREATE TABLE `EVALUATION` (
  `BEGINNING_DATE_HOUR_MINUTE_SECOND` time DEFAULT NULL,
  `CREATION_DATE_TIME` timestamp NULL DEFAULT NULL,
  `DAY_DATE_YEAR_MONTH_DAY` longtext,
  `DESCRIPTION` longtext,
  `END_DATE_HOUR_MINUTE_SECOND` time DEFAULT NULL,
  `ENROLLMENT_BEGIN_DAY_DATE_YEAR_MONTH_DAY` longtext,
  `ENROLLMENT_BEGIN_TIME_DATE_HOUR_MINUTE_SECOND` time DEFAULT NULL,
  `ENROLLMENT_END_DAY_DATE_YEAR_MONTH_DAY` longtext,
  `ENROLLMENT_END_TIME_DATE_HOUR_MINUTE_SECOND` time DEFAULT NULL,
  `GRADE_SCALE` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_DISTRIBUTED_TEST` int(11) DEFAULT NULL,
  `KEY_GROUPING` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `MAX_SUBMISSIONS_TO_KEEP` int(11) DEFAULT NULL,
  `NAME` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_DISTRIBUTED_TEST` bigint(20) DEFAULT NULL,
  `OID_GROUPING` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `ONLINE_SUBMISSIONS_ALLOWED` tinyint(1) DEFAULT NULL,
  `PROJECT_BEGIN_DATE_TIME` timestamp NULL DEFAULT NULL,
  `PROJECT_END_DATE_TIME` timestamp NULL DEFAULT NULL,
  `PUBLISHMENT_MESSAGE` longtext,
  `SEASON` int(11) DEFAULT NULL,
  `VIGILANTS_REPORT` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_DISTRIBUTED_TEST` (`KEY_DISTRIBUTED_TEST`),
  KEY `OID_DISTRIBUTED_TEST` (`OID_DISTRIBUTED_TEST`),
  KEY `KEY_GROUPING` (`KEY_GROUPING`),
  KEY `OID_GROUPING` (`OID_GROUPING`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EVALUATION`
--


--
-- Table structure for table `EVALUATION_COMPLAIN`
--

CREATE TABLE `EVALUATION_COMPLAIN` (
  `DESCRIPTION` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EXECUTION_COURSE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_STUDENT` int(11) DEFAULT NULL,
  `KEY_TEACHER` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_COURSE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_STUDENT` bigint(20) DEFAULT NULL,
  `OID_TEACHER` bigint(20) DEFAULT NULL,
  `STUDENT_EVALUATION_COMPLAIN_DATE_YEAR_MONTH_DAY` longtext,
  `TEACHER_ANSWER` longtext,
  `TEACHER_ANSWER_DATE_YEAR_MONTH_DAY` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXECUTION_COURSE` (`KEY_EXECUTION_COURSE`),
  KEY `OID_EXECUTION_COURSE` (`OID_EXECUTION_COURSE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_STUDENT` (`KEY_STUDENT`),
  KEY `OID_STUDENT` (`OID_STUDENT`),
  KEY `KEY_TEACHER` (`KEY_TEACHER`),
  KEY `OID_TEACHER` (`OID_TEACHER`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EVALUATION_COMPLAIN`
--


--
-- Table structure for table `EVALUATION_EXECUTION_COURSE`
--

CREATE TABLE `EVALUATION_EXECUTION_COURSE` (
  `KEY_EVALUATION` int(11) NOT NULL,
  `KEY_EXECUTION_COURSE` int(11) NOT NULL,
  `OID_EVALUATION` bigint(20) unsigned DEFAULT NULL,
  `OID_EXECUTION_COURSE` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_EVALUATION`,`KEY_EXECUTION_COURSE`),
  KEY `KEY_EVALUATION` (`KEY_EVALUATION`),
  KEY `KEY_EXECUTION_COURSE` (`KEY_EXECUTION_COURSE`),
  KEY `OID_EVALUATION` (`OID_EVALUATION`,`OID_EXECUTION_COURSE`),
  KEY `OID_EVALUATION_2` (`OID_EVALUATION`),
  KEY `OID_EXECUTION_COURSE` (`OID_EXECUTION_COURSE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EVALUATION_EXECUTION_COURSE`
--


--
-- Table structure for table `EVALUATION_METHOD`
--

CREATE TABLE `EVALUATION_METHOD` (
  `EVALUATION_ELEMENTS` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EXECUTION_COURSE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_COURSE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXECUTION_COURSE` (`KEY_EXECUTION_COURSE`),
  KEY `OID_EXECUTION_COURSE` (`OID_EXECUTION_COURSE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EVALUATION_METHOD`
--


--
-- Table structure for table `EVENT`
--

CREATE TABLE `EVENT` (
  `CANCEL_JUSTIFICATION` longtext,
  `EVENT_STATE` text,
  `EVENT_STATE_DATE` timestamp NULL DEFAULT NULL,
  `EVENT_TYPE` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ACADEMIC_SERVICE_REQUEST` int(11) DEFAULT NULL,
  `KEY_ADMINISTRATIVE_OFFICE` int(11) DEFAULT NULL,
  `KEY_CANDIDACY` int(11) DEFAULT NULL,
  `KEY_CANDIDACY_PROCESS` int(11) DEFAULT NULL,
  `KEY_EMPLOYEE_RESPONSIBLE_FOR_CANCEL` int(11) DEFAULT NULL,
  `KEY_EXECUTION_PERIOD` int(11) DEFAULT NULL,
  `KEY_EXECUTION_YEAR` int(11) DEFAULT NULL,
  `KEY_GRATUITY_PAYMENT_PLAN` int(11) DEFAULT NULL,
  `KEY_INDIVIDUAL_CANDIDACY` int(11) DEFAULT NULL,
  `KEY_PERSON` int(11) DEFAULT NULL,
  `KEY_REGISTRATION` int(11) DEFAULT NULL,
  `KEY_RESIDENCE_MONTH` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_STUDENT_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `NUMBER_OF_DELAY_DAYS` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ACADEMIC_SERVICE_REQUEST` bigint(20) DEFAULT NULL,
  `OID_ADMINISTRATIVE_OFFICE` bigint(20) DEFAULT NULL,
  `OID_CANDIDACY` bigint(20) DEFAULT NULL,
  `OID_CANDIDACY_PROCESS` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE_RESPONSIBLE_FOR_CANCEL` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_PERIOD` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_YEAR` bigint(20) DEFAULT NULL,
  `OID_GRATUITY_PAYMENT_PLAN` bigint(20) DEFAULT NULL,
  `OID_INDIVIDUAL_CANDIDACY` bigint(20) DEFAULT NULL,
  `OID_PERSON` bigint(20) DEFAULT NULL,
  `OID_REGISTRATION` bigint(20) DEFAULT NULL,
  `OID_RESIDENCE_MONTH` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_STUDENT_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `PAST_ADMINISTRATIVE_OFFICE_FEE_AND_INSURANCE_AMOUNT` longtext,
  `PAST_AMOUNT` longtext,
  `PAST_DEGREE_GRATUITY_AMOUNT` longtext,
  `PAYMENT_END_DATE` longtext,
  `ROOM` longtext,
  `ROOM_VALUE` longtext,
  `WHEN_OCCURED` timestamp NULL DEFAULT NULL,
  `WHEN_SENT_LETTER` text,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ACADEMIC_SERVICE_REQUEST` (`KEY_ACADEMIC_SERVICE_REQUEST`),
  KEY `OID_ACADEMIC_SERVICE_REQUEST` (`OID_ACADEMIC_SERVICE_REQUEST`),
  KEY `KEY_ADMINISTRATIVE_OFFICE` (`KEY_ADMINISTRATIVE_OFFICE`),
  KEY `OID_ADMINISTRATIVE_OFFICE` (`OID_ADMINISTRATIVE_OFFICE`),
  KEY `KEY_CANDIDACY` (`KEY_CANDIDACY`),
  KEY `OID_CANDIDACY` (`OID_CANDIDACY`),
  KEY `KEY_CANDIDACY_PROCESS` (`KEY_CANDIDACY_PROCESS`),
  KEY `OID_CANDIDACY_PROCESS` (`OID_CANDIDACY_PROCESS`),
  KEY `KEY_EMPLOYEE_RESPONSIBLE_FOR_CANCEL` (`KEY_EMPLOYEE_RESPONSIBLE_FOR_CANCEL`),
  KEY `OID_EMPLOYEE_RESPONSIBLE_FOR_CANCEL` (`OID_EMPLOYEE_RESPONSIBLE_FOR_CANCEL`),
  KEY `KEY_EXECUTION_PERIOD` (`KEY_EXECUTION_PERIOD`),
  KEY `OID_EXECUTION_PERIOD` (`OID_EXECUTION_PERIOD`),
  KEY `KEY_EXECUTION_YEAR` (`KEY_EXECUTION_YEAR`),
  KEY `OID_EXECUTION_YEAR` (`OID_EXECUTION_YEAR`),
  KEY `KEY_GRATUITY_PAYMENT_PLAN` (`KEY_GRATUITY_PAYMENT_PLAN`),
  KEY `OID_GRATUITY_PAYMENT_PLAN` (`OID_GRATUITY_PAYMENT_PLAN`),
  KEY `KEY_INDIVIDUAL_CANDIDACY` (`KEY_INDIVIDUAL_CANDIDACY`),
  KEY `OID_INDIVIDUAL_CANDIDACY` (`OID_INDIVIDUAL_CANDIDACY`),
  KEY `KEY_PERSON` (`KEY_PERSON`),
  KEY `OID_PERSON` (`OID_PERSON`),
  KEY `KEY_REGISTRATION` (`KEY_REGISTRATION`),
  KEY `OID_REGISTRATION` (`OID_REGISTRATION`),
  KEY `KEY_RESIDENCE_MONTH` (`KEY_RESIDENCE_MONTH`),
  KEY `OID_RESIDENCE_MONTH` (`OID_RESIDENCE_MONTH`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_STUDENT_CURRICULAR_PLAN` (`KEY_STUDENT_CURRICULAR_PLAN`),
  KEY `OID_STUDENT_CURRICULAR_PLAN` (`OID_STUDENT_CURRICULAR_PLAN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EVENT`
--


--
-- Table structure for table `EVENT_CONFERENCE_ARTICLES_ASSOCIATION`
--

CREATE TABLE `EVENT_CONFERENCE_ARTICLES_ASSOCIATION` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_CONFERENCE_ARTICLE` int(11) DEFAULT NULL,
  `KEY_EVENT_EDITION` int(11) DEFAULT NULL,
  `KEY_PERSON` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_CONFERENCE_ARTICLE` bigint(20) DEFAULT NULL,
  `OID_EVENT_EDITION` bigint(20) DEFAULT NULL,
  `OID_PERSON` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_CONFERENCE_ARTICLE` (`KEY_CONFERENCE_ARTICLE`),
  KEY `OID_CONFERENCE_ARTICLE` (`OID_CONFERENCE_ARTICLE`),
  KEY `KEY_EVENT_EDITION` (`KEY_EVENT_EDITION`),
  KEY `OID_EVENT_EDITION` (`OID_EVENT_EDITION`),
  KEY `KEY_PERSON` (`KEY_PERSON`),
  KEY `OID_PERSON` (`OID_PERSON`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EVENT_CONFERENCE_ARTICLES_ASSOCIATION`
--


--
-- Table structure for table `EVENT_EDITION`
--

CREATE TABLE `EVENT_EDITION` (
  `EDITION` longtext,
  `END_DATE` longtext,
  `EVENT_LOCATION` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EVENT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EVENT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `ORGANIZATION` longtext,
  `START_DATE` longtext,
  `URL` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EVENT` (`KEY_EVENT`),
  KEY `OID_EVENT` (`OID_EVENT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EVENT_EDITION`
--


--
-- Table structure for table `EXAM_COORDINATOR`
--

CREATE TABLE `EXAM_COORDINATOR` (
  `ALLOWED_TO_CREATE_GROUPS` tinyint(1) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EXECUTION_YEAR` int(11) DEFAULT NULL,
  `KEY_PERSON` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_UNIT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_YEAR` bigint(20) DEFAULT NULL,
  `OID_PERSON` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_UNIT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXECUTION_YEAR` (`KEY_EXECUTION_YEAR`),
  KEY `OID_EXECUTION_YEAR` (`OID_EXECUTION_YEAR`),
  KEY `KEY_PERSON` (`KEY_PERSON`),
  KEY `OID_PERSON` (`OID_PERSON`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_UNIT` (`KEY_UNIT`),
  KEY `OID_UNIT` (`OID_UNIT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXAM_COORDINATOR`
--


--
-- Table structure for table `EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP`
--

CREATE TABLE `EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP` (
  `KEY_VIGILANT_GROUP` int(11) NOT NULL,
  `KEY_EXAM_COORDINATOR` int(11) NOT NULL,
  `OID_VIGILANT_GROUP` bigint(20) unsigned DEFAULT NULL,
  `OID_EXAM_COORDINATOR` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_VIGILANT_GROUP`,`KEY_EXAM_COORDINATOR`),
  KEY `KEY_VIGILANT_GROUP` (`KEY_VIGILANT_GROUP`),
  KEY `KEY_EXAM_COORDINATOR` (`KEY_EXAM_COORDINATOR`),
  KEY `OID_VIGILANT_GROUP` (`OID_VIGILANT_GROUP`,`OID_EXAM_COORDINATOR`),
  KEY `OID_VIGILANT_GROUP_2` (`OID_VIGILANT_GROUP`),
  KEY `OID_EXAM_COORDINATOR` (`OID_EXAM_COORDINATOR`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP`
--


--
-- Table structure for table `EXAM_DATE_CERTIFICATE_REQUEST_ENROLMENT`
--

CREATE TABLE `EXAM_DATE_CERTIFICATE_REQUEST_ENROLMENT` (
  `KEY_ENROLMENT` int(11) NOT NULL,
  `KEY_EXAM_DATE_CERTIFICATE_REQUEST` int(11) NOT NULL,
  `OID_ENROLMENT` bigint(20) unsigned DEFAULT NULL,
  `OID_EXAM_DATE_CERTIFICATE_REQUEST` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_ENROLMENT`,`KEY_EXAM_DATE_CERTIFICATE_REQUEST`),
  KEY `KEY_ENROLMENT` (`KEY_ENROLMENT`),
  KEY `KEY_EXAM_DATE_CERTIFICATE_REQUEST` (`KEY_EXAM_DATE_CERTIFICATE_REQUEST`),
  KEY `OID_ENROLMENT` (`OID_ENROLMENT`,`OID_EXAM_DATE_CERTIFICATE_REQUEST`),
  KEY `OID_ENROLMENT_2` (`OID_ENROLMENT`),
  KEY `OID_EXAM_DATE_CERTIFICATE_REQUEST` (`OID_EXAM_DATE_CERTIFICATE_REQUEST`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXAM_DATE_CERTIFICATE_REQUEST_ENROLMENT`
--


--
-- Table structure for table `EXAM_DATE_CERTIFICATE_REQUEST_EXAM`
--

CREATE TABLE `EXAM_DATE_CERTIFICATE_REQUEST_EXAM` (
  `KEY_EXAM_DATE_CERTIFICATE_REQUEST` int(11) NOT NULL,
  `KEY_EXAM` int(11) NOT NULL,
  `OID_EXAM_DATE_CERTIFICATE_REQUEST` bigint(20) unsigned DEFAULT NULL,
  `OID_EXAM` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_EXAM_DATE_CERTIFICATE_REQUEST`,`KEY_EXAM`),
  KEY `KEY_EXAM_DATE_CERTIFICATE_REQUEST` (`KEY_EXAM_DATE_CERTIFICATE_REQUEST`),
  KEY `KEY_EXAM` (`KEY_EXAM`),
  KEY `OID_EXAM_DATE_CERTIFICATE_REQUEST` (`OID_EXAM_DATE_CERTIFICATE_REQUEST`,`OID_EXAM`),
  KEY `OID_EXAM_DATE_CERTIFICATE_REQU_2` (`OID_EXAM_DATE_CERTIFICATE_REQUEST`),
  KEY `OID_EXAM` (`OID_EXAM`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXAM_DATE_CERTIFICATE_REQUEST_EXAM`
--


--
-- Table structure for table `EXCEPTION_TYPE`
--

CREATE TABLE `EXCEPTION_TYPE` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `TYPE` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXCEPTION_TYPE`
--

INSERT INTO `EXCEPTION_TYPE` VALUES (1,1,4170413244417,2551210573825,'java.lang.NullPointerException');

--
-- Table structure for table `EXECUTION_COURSE`
--

CREATE TABLE `EXECUTION_COURSE` (
  `AVAILABLE_FOR_INQUIRIES` tinyint(1) DEFAULT NULL,
  `AVAILABLE_GRADE_SUBMISSION` tinyint(1) DEFAULT NULL,
  `COMMENT` longtext,
  `ENTRY_PHASE` int(11) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_BOARD` int(11) DEFAULT NULL,
  `KEY_COURSE_REPORT` int(11) DEFAULT NULL,
  `KEY_EVALUATION_METHOD` int(11) DEFAULT NULL,
  `KEY_EXECUTION_PERIOD` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_SENDER` int(11) DEFAULT NULL,
  `KEY_SITE` int(11) DEFAULT NULL,
  `KEY_VIGILANT_GROUP` int(11) DEFAULT NULL,
  `NOME` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_BOARD` bigint(20) DEFAULT NULL,
  `OID_COURSE_REPORT` bigint(20) DEFAULT NULL,
  `OID_EVALUATION_METHOD` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_PERIOD` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_SENDER` bigint(20) DEFAULT NULL,
  `OID_SITE` bigint(20) DEFAULT NULL,
  `OID_VIGILANT_GROUP` bigint(20) DEFAULT NULL,
  `SIGLA` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_BOARD` (`KEY_BOARD`),
  KEY `OID_BOARD` (`OID_BOARD`),
  KEY `KEY_COURSE_REPORT` (`KEY_COURSE_REPORT`),
  KEY `OID_COURSE_REPORT` (`OID_COURSE_REPORT`),
  KEY `KEY_EVALUATION_METHOD` (`KEY_EVALUATION_METHOD`),
  KEY `OID_EVALUATION_METHOD` (`OID_EVALUATION_METHOD`),
  KEY `KEY_EXECUTION_PERIOD` (`KEY_EXECUTION_PERIOD`),
  KEY `OID_EXECUTION_PERIOD` (`OID_EXECUTION_PERIOD`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_SENDER` (`KEY_SENDER`),
  KEY `OID_SENDER` (`OID_SENDER`),
  KEY `KEY_SITE` (`KEY_SITE`),
  KEY `OID_SITE` (`OID_SITE`),
  KEY `KEY_VIGILANT_GROUP` (`KEY_VIGILANT_GROUP`),
  KEY `OID_VIGILANT_GROUP` (`OID_VIGILANT_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXECUTION_COURSE`
--


--
-- Table structure for table `EXECUTION_DEGREE`
--

CREATE TABLE `EXECUTION_DEGREE` (
  `ANOTATION` longtext,
  `BEGIN_THESIS_CREATION_PERIOD` longtext,
  `END_THESIS_CREATION_PERIOD` longtext,
  `EXECUTION_INTERVAL` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_CAMPUS` int(11) DEFAULT NULL,
  `KEY_DEGREE_CURRICULAR_PLAN` int(11) DEFAULT NULL,
  `KEY_EXECUTION_YEAR` int(11) DEFAULT NULL,
  `KEY_GRATUITY_VALUES` int(11) DEFAULT NULL,
  `KEY_PERIOD_EXAMS_FIRST_SEMESTER` int(11) DEFAULT NULL,
  `KEY_PERIOD_EXAMS_SECOND_SEMESTER` int(11) DEFAULT NULL,
  `KEY_PERIOD_EXAMS_SPECIAL_SEASON` int(11) DEFAULT NULL,
  `KEY_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_FIRST_SEMESTER` int(11) DEFAULT NULL,
  `KEY_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_SECOND_SEMESTER` int(11) DEFAULT NULL,
  `KEY_PERIOD_GRADE_SUBMISSION_SPECIAL_SEASON` int(11) DEFAULT NULL,
  `KEY_PERIOD_LESSONS_FIRST_SEMESTER` int(11) DEFAULT NULL,
  `KEY_PERIOD_LESSONS_SECOND_SEMESTER` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_SCHEDULING` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_CAMPUS` bigint(20) DEFAULT NULL,
  `OID_DEGREE_CURRICULAR_PLAN` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_YEAR` bigint(20) DEFAULT NULL,
  `OID_GRATUITY_VALUES` bigint(20) DEFAULT NULL,
  `OID_PERIOD_EXAMS_FIRST_SEMESTER` bigint(20) DEFAULT NULL,
  `OID_PERIOD_EXAMS_SECOND_SEMESTER` bigint(20) DEFAULT NULL,
  `OID_PERIOD_EXAMS_SPECIAL_SEASON` bigint(20) DEFAULT NULL,
  `OID_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_FIRST_SEMESTER` bigint(20) DEFAULT NULL,
  `OID_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_SECOND_SEMESTER` bigint(20) DEFAULT NULL,
  `OID_PERIOD_GRADE_SUBMISSION_SPECIAL_SEASON` bigint(20) DEFAULT NULL,
  `OID_PERIOD_LESSONS_FIRST_SEMESTER` bigint(20) DEFAULT NULL,
  `OID_PERIOD_LESSONS_SECOND_SEMESTER` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_SCHEDULING` bigint(20) DEFAULT NULL,
  `TEMPORARY_EXAM_MAP` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_CAMPUS` (`KEY_CAMPUS`),
  KEY `OID_CAMPUS` (`OID_CAMPUS`),
  KEY `KEY_DEGREE_CURRICULAR_PLAN` (`KEY_DEGREE_CURRICULAR_PLAN`),
  KEY `OID_DEGREE_CURRICULAR_PLAN` (`OID_DEGREE_CURRICULAR_PLAN`),
  KEY `KEY_EXECUTION_YEAR` (`KEY_EXECUTION_YEAR`),
  KEY `OID_EXECUTION_YEAR` (`OID_EXECUTION_YEAR`),
  KEY `KEY_GRATUITY_VALUES` (`KEY_GRATUITY_VALUES`),
  KEY `OID_GRATUITY_VALUES` (`OID_GRATUITY_VALUES`),
  KEY `KEY_PERIOD_EXAMS_FIRST_SEMESTER` (`KEY_PERIOD_EXAMS_FIRST_SEMESTER`),
  KEY `OID_PERIOD_EXAMS_FIRST_SEMESTER` (`OID_PERIOD_EXAMS_FIRST_SEMESTER`),
  KEY `KEY_PERIOD_EXAMS_SECOND_SEMESTER` (`KEY_PERIOD_EXAMS_SECOND_SEMESTER`),
  KEY `OID_PERIOD_EXAMS_SECOND_SEMESTER` (`OID_PERIOD_EXAMS_SECOND_SEMESTER`),
  KEY `KEY_PERIOD_EXAMS_SPECIAL_SEASON` (`KEY_PERIOD_EXAMS_SPECIAL_SEASON`),
  KEY `OID_PERIOD_EXAMS_SPECIAL_SEASON` (`OID_PERIOD_EXAMS_SPECIAL_SEASON`),
  KEY `KEY_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_FIRST_SEMESTER` (`KEY_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_FIRST_SEMESTER`),
  KEY `OID_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_FIRST_SEMESTER` (`OID_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_FIRST_SEMESTER`),
  KEY `KEY_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_SECOND_SEMESTER` (`KEY_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_SECOND_SEMESTER`),
  KEY `OID_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_SECOND_SEMESTER` (`OID_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_SECOND_SEMESTER`),
  KEY `KEY_PERIOD_GRADE_SUBMISSION_SPECIAL_SEASON` (`KEY_PERIOD_GRADE_SUBMISSION_SPECIAL_SEASON`),
  KEY `OID_PERIOD_GRADE_SUBMISSION_SPECIAL_SEASON` (`OID_PERIOD_GRADE_SUBMISSION_SPECIAL_SEASON`),
  KEY `KEY_PERIOD_LESSONS_FIRST_SEMESTER` (`KEY_PERIOD_LESSONS_FIRST_SEMESTER`),
  KEY `OID_PERIOD_LESSONS_FIRST_SEMESTER` (`OID_PERIOD_LESSONS_FIRST_SEMESTER`),
  KEY `KEY_PERIOD_LESSONS_SECOND_SEMESTER` (`KEY_PERIOD_LESSONS_SECOND_SEMESTER`),
  KEY `OID_PERIOD_LESSONS_SECOND_SEMESTER` (`OID_PERIOD_LESSONS_SECOND_SEMESTER`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_SCHEDULING` (`KEY_SCHEDULING`),
  KEY `OID_SCHEDULING` (`OID_SCHEDULING`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXECUTION_DEGREE`
--


--
-- Table structure for table `EXECUTION_INTERVAL`
--

CREATE TABLE `EXECUTION_INTERVAL` (
  `ACADEMIC_INTERVAL` longtext,
  `BEGIN_DATE_YEAR_MONTH_DAY` longtext,
  `END_DATE_YEAR_MONTH_DAY` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EXECUTION_YEAR` int(11) DEFAULT NULL,
  `KEY_INSURANCE_VALUE` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_PERIOD` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_YEAR` int(11) DEFAULT NULL,
  `KEY_SHIFT_DISTRIBUTION` int(11) DEFAULT NULL,
  `NAME` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_YEAR` bigint(20) DEFAULT NULL,
  `OID_INSURANCE_VALUE` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_PERIOD` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_YEAR` bigint(20) DEFAULT NULL,
  `OID_SHIFT_DISTRIBUTION` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `STATE` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXECUTION_YEAR` (`KEY_EXECUTION_YEAR`),
  KEY `OID_EXECUTION_YEAR` (`OID_EXECUTION_YEAR`),
  KEY `KEY_INSURANCE_VALUE` (`KEY_INSURANCE_VALUE`),
  KEY `OID_INSURANCE_VALUE` (`OID_INSURANCE_VALUE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_PERIOD` (`KEY_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_PERIOD`),
  KEY `OID_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_PERIOD` (`OID_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_PERIOD`),
  KEY `KEY_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_YEAR` (`KEY_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_YEAR`),
  KEY `OID_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_YEAR` (`OID_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_YEAR`),
  KEY `KEY_SHIFT_DISTRIBUTION` (`KEY_SHIFT_DISTRIBUTION`),
  KEY `OID_SHIFT_DISTRIBUTION` (`OID_SHIFT_DISTRIBUTION`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXECUTION_INTERVAL`
--


--
-- Table structure for table `EXECUTION_PATH`
--

CREATE TABLE `EXECUTION_PATH` (
  `CONTENT_ID` longtext,
  `EXECUTION_PATH` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_FUNCTIONALITY` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_FUNCTIONALITY` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_FUNCTIONALITY` (`KEY_FUNCTIONALITY`),
  KEY `OID_FUNCTIONALITY` (`OID_FUNCTIONALITY`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXECUTION_PATH`
--


--
-- Table structure for table `EXEMPTION`
--

CREATE TABLE `EXEMPTION` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EMPLOYEE` int(11) DEFAULT NULL,
  `KEY_EVENT` int(11) DEFAULT NULL,
  `KEY_EXEMPTION_JUSTIFICATION` int(11) DEFAULT NULL,
  `KEY_INSTALLMENT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EMPLOYEE` bigint(20) DEFAULT NULL,
  `OID_EVENT` bigint(20) DEFAULT NULL,
  `OID_EXEMPTION_JUSTIFICATION` bigint(20) DEFAULT NULL,
  `OID_INSTALLMENT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `PERCENTAGE` longtext,
  `VALUE` longtext,
  `WHEN_CREATED` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EMPLOYEE` (`KEY_EMPLOYEE`),
  KEY `OID_EMPLOYEE` (`OID_EMPLOYEE`),
  KEY `KEY_EVENT` (`KEY_EVENT`),
  KEY `OID_EVENT` (`OID_EVENT`),
  KEY `KEY_EXEMPTION_JUSTIFICATION` (`KEY_EXEMPTION_JUSTIFICATION`),
  KEY `OID_EXEMPTION_JUSTIFICATION` (`OID_EXEMPTION_JUSTIFICATION`),
  KEY `KEY_INSTALLMENT` (`KEY_INSTALLMENT`),
  KEY `OID_INSTALLMENT` (`OID_INSTALLMENT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXEMPTION`
--


--
-- Table structure for table `EXEMPTION_JUSTIFICATION`
--

CREATE TABLE `EXEMPTION_JUSTIFICATION` (
  `CANDIDACY_EXEMPTION_JUSTIFICATION_TYPE` text,
  `DISPATCH_DATE` longtext,
  `GRATUITY_EXEMPTION_DISPATCH_DATE` longtext,
  `GRATUITY_EXEMPTION_JUSTIFICATION_TYPE` text,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `JUSTIFICATION_TYPE` text,
  `KEY_EXEMPTION` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXEMPTION` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OJB_CONCRETE_CLASS` longtext,
  `PENALTY_EXEMPTION_DISPATCH_DATE` longtext,
  `PENALTY_EXEMPTION_JUSTIFICATION_TYPE` text,
  `REASON` longtext,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXEMPTION` (`KEY_EXEMPTION`),
  KEY `OID_EXEMPTION` (`OID_EXEMPTION`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXEMPTION_JUSTIFICATION`
--


--
-- Table structure for table `EXPECTATION_EVALUATION_GROUP`
--

CREATE TABLE `EXPECTATION_EVALUATION_GROUP` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_APPRAISER` int(11) DEFAULT NULL,
  `KEY_EVALUATED` int(11) DEFAULT NULL,
  `KEY_EXECUTION_YEAR` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_APPRAISER` bigint(20) DEFAULT NULL,
  `OID_EVALUATED` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_YEAR` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_APPRAISER` (`KEY_APPRAISER`),
  KEY `OID_APPRAISER` (`OID_APPRAISER`),
  KEY `KEY_EVALUATED` (`KEY_EVALUATED`),
  KEY `OID_EVALUATED` (`OID_EVALUATED`),
  KEY `KEY_EXECUTION_YEAR` (`KEY_EXECUTION_YEAR`),
  KEY `OID_EXECUTION_YEAR` (`OID_EXECUTION_YEAR`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXPECTATION_EVALUATION_GROUP`
--


--
-- Table structure for table `EXPORT_GROUPING`
--

CREATE TABLE `EXPORT_GROUPING` (
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EXECUTION_COURSE` int(11) DEFAULT NULL,
  `KEY_GROUPING` int(11) DEFAULT NULL,
  `KEY_RECEIVER_PERSON` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_SENDER_EXECUTION_COURSE` int(11) DEFAULT NULL,
  `KEY_SENDER_PERSON` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_COURSE` bigint(20) DEFAULT NULL,
  `OID_GROUPING` bigint(20) DEFAULT NULL,
  `OID_RECEIVER_PERSON` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_SENDER_EXECUTION_COURSE` bigint(20) DEFAULT NULL,
  `OID_SENDER_PERSON` bigint(20) DEFAULT NULL,
  `PROPOSAL_STATE` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXECUTION_COURSE` (`KEY_EXECUTION_COURSE`),
  KEY `OID_EXECUTION_COURSE` (`OID_EXECUTION_COURSE`),
  KEY `KEY_GROUPING` (`KEY_GROUPING`),
  KEY `OID_GROUPING` (`OID_GROUPING`),
  KEY `KEY_RECEIVER_PERSON` (`KEY_RECEIVER_PERSON`),
  KEY `OID_RECEIVER_PERSON` (`OID_RECEIVER_PERSON`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_SENDER_EXECUTION_COURSE` (`KEY_SENDER_EXECUTION_COURSE`),
  KEY `OID_SENDER_EXECUTION_COURSE` (`OID_SENDER_EXECUTION_COURSE`),
  KEY `KEY_SENDER_PERSON` (`KEY_SENDER_PERSON`),
  KEY `OID_SENDER_PERSON` (`OID_SENDER_PERSON`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXPORT_GROUPING`
--


--
-- Table structure for table `EXTERNAL_ACTIVITY`
--

CREATE TABLE `EXTERNAL_ACTIVITY` (
  `ACTIVITY` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_TEACHER` int(11) DEFAULT NULL,
  `LAST_MODIFICATION_DATE_DATE_TIME` timestamp NULL DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_TEACHER` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_TEACHER` (`KEY_TEACHER`),
  KEY `OID_TEACHER` (`OID_TEACHER`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXTERNAL_ACTIVITY`
--


--
-- Table structure for table `EXTERNAL_CURRICULAR_COURSE`
--

CREATE TABLE `EXTERNAL_CURRICULAR_COURSE` (
  `CODE` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_UNIT` int(11) DEFAULT NULL,
  `NAME` longtext,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_UNIT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_UNIT` (`KEY_UNIT`),
  KEY `OID_UNIT` (`OID_UNIT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXTERNAL_CURRICULAR_COURSE`
--


--
-- Table structure for table `EXTERNAL_ENROLMENT`
--

CREATE TABLE `EXTERNAL_ENROLMENT` (
  `CREATED_BY` longtext,
  `CREATION_DATE_DATE_TIME` timestamp NULL DEFAULT NULL,
  `ECTS_CREDITS` double DEFAULT NULL,
  `EVALUATION_DATE` longtext,
  `GRADE` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_EXECUTION_PERIOD` int(11) DEFAULT NULL,
  `KEY_EXTERNAL_CURRICULAR_COURSE` int(11) DEFAULT NULL,
  `KEY_REGISTRATION` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_EXECUTION_PERIOD` bigint(20) DEFAULT NULL,
  `OID_EXTERNAL_CURRICULAR_COURSE` bigint(20) DEFAULT NULL,
  `OID_REGISTRATION` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_EXECUTION_PERIOD` (`KEY_EXECUTION_PERIOD`),
  KEY `OID_EXECUTION_PERIOD` (`OID_EXECUTION_PERIOD`),
  KEY `KEY_EXTERNAL_CURRICULAR_COURSE` (`KEY_EXTERNAL_CURRICULAR_COURSE`),
  KEY `OID_EXTERNAL_CURRICULAR_COURSE` (`OID_EXTERNAL_CURRICULAR_COURSE`),
  KEY `KEY_REGISTRATION` (`KEY_REGISTRATION`),
  KEY `OID_REGISTRATION` (`OID_REGISTRATION`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXTERNAL_ENROLMENT`
--


--
-- Table structure for table `EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE`
--

CREATE TABLE `EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE` (
  `KEY_EXTERNAL_ENROLMENT` int(11) NOT NULL,
  `KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE` int(11) NOT NULL,
  `OID_EXTERNAL_ENROLMENT` bigint(20) unsigned DEFAULT NULL,
  `OID_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_EXTERNAL_ENROLMENT`,`KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE`),
  KEY `KEY_EXTERNAL_ENROLMENT` (`KEY_EXTERNAL_ENROLMENT`),
  KEY `KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE` (`KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE`),
  KEY `OID_EXTERNAL_ENROLMENT` (`OID_EXTERNAL_ENROLMENT`,`OID_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE`),
  KEY `OID_EXTERNAL_ENROLMENT_2` (`OID_EXTERNAL_ENROLMENT`),
  KEY `OID_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE` (`OID_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE`
--


--
-- Table structure for table `EXTERNAL_REGISTRATION_DATA`
--

CREATE TABLE `EXTERNAL_REGISTRATION_DATA` (
  `COORDINATOR_NAME` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_INSTITUTION` int(11) DEFAULT NULL,
  `KEY_REGISTRATION` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_INSTITUTION` bigint(20) DEFAULT NULL,
  `OID_REGISTRATION` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_INSTITUTION` (`KEY_INSTITUTION`),
  KEY `OID_INSTITUTION` (`OID_INSTITUTION`),
  KEY `KEY_REGISTRATION` (`KEY_REGISTRATION`),
  KEY `OID_REGISTRATION` (`OID_REGISTRATION`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXTERNAL_REGISTRATION_DATA`
--


--
-- Table structure for table `EXTRA_CURRICULAR_CERTIFICATE_REQUEST_ENROLMENT`
--

CREATE TABLE `EXTRA_CURRICULAR_CERTIFICATE_REQUEST_ENROLMENT` (
  `KEY_ENROLMENT` int(11) NOT NULL,
  `KEY_EXTRA_CURRICULAR_CERTIFICATE_REQUEST` int(11) NOT NULL,
  `OID_ENROLMENT` bigint(20) unsigned DEFAULT NULL,
  `OID_EXTRA_CURRICULAR_CERTIFICATE_REQUEST` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`KEY_ENROLMENT`,`KEY_EXTRA_CURRICULAR_CERTIFICATE_REQUEST`),
  KEY `KEY_ENROLMENT` (`KEY_ENROLMENT`),
  KEY `KEY_EXTRA_CURRICULAR_CERTIFICATE_REQUEST` (`KEY_EXTRA_CURRICULAR_CERTIFICATE_REQUEST`),
  KEY `OID_ENROLMENT` (`OID_ENROLMENT`,`OID_EXTRA_CURRICULAR_CERTIFICATE_REQUEST`),
  KEY `OID_ENROLMENT_2` (`OID_ENROLMENT`),
  KEY `OID_EXTRA_CURRICULAR_CERTIFICATE_REQUEST` (`OID_EXTRA_CURRICULAR_CERTIFICATE_REQUEST`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXTRA_CURRICULAR_CERTIFICATE_REQUEST_ENROLMENT`
--


--
-- Table structure for table `EXTRA_WORK_AUTHORIZATION`
--

CREATE TABLE `EXTRA_WORK_AUTHORIZATION` (
  `BEGIN_DATE` longtext,
  `END_DATE` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_MODIFIED_BY` int(11) DEFAULT NULL,
  `KEY_PAYING_UNIT` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_WORKING_UNIT` int(11) DEFAULT NULL,
  `LAST_MODIFIED_DATE` timestamp NULL DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_MODIFIED_BY` bigint(20) DEFAULT NULL,
  `OID_PAYING_UNIT` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_WORKING_UNIT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_MODIFIED_BY` (`KEY_MODIFIED_BY`),
  KEY `OID_MODIFIED_BY` (`OID_MODIFIED_BY`),
  KEY `KEY_PAYING_UNIT` (`KEY_PAYING_UNIT`),
  KEY `OID_PAYING_UNIT` (`OID_PAYING_UNIT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_WORKING_UNIT` (`KEY_WORKING_UNIT`),
  KEY `OID_WORKING_UNIT` (`OID_WORKING_UNIT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXTRA_WORK_AUTHORIZATION`
--


--
-- Table structure for table `EXTRA_WORK_REQUEST`
--

CREATE TABLE `EXTRA_WORK_REQUEST` (
  `ACCUMULATED_NIGHT_VACATIONS_AMOUNT` double DEFAULT NULL,
  `ACCUMULATED_NORMAL_VACATIONS_AMOUNT` double DEFAULT NULL,
  `ADD_TO_VACATIONS` tinyint(1) DEFAULT NULL,
  `ADD_TO_WEEK_REST_TIME` tinyint(1) DEFAULT NULL,
  `AMOUNT` double DEFAULT NULL,
  `APPROVED` tinyint(1) DEFAULT NULL,
  `EXTRA_NIGHT_DAYS` int(11) DEFAULT NULL,
  `EXTRA_NIGHT_FIRST_LEVEL_AMOUNT` double DEFAULT NULL,
  `EXTRA_NIGHT_HOURS` int(11) DEFAULT NULL,
  `EXTRA_NIGHT_HOURS_FIRST_LEVEL` int(11) DEFAULT NULL,
  `EXTRA_NIGHT_HOURS_SECOND_LEVEL` int(11) DEFAULT NULL,
  `EXTRA_NIGHT_MEAL_AMOUNT` double DEFAULT NULL,
  `EXTRA_NIGHT_SECOND_LEVEL_AMOUNT` double DEFAULT NULL,
  `HOLIDAY_AMOUNT` double DEFAULT NULL,
  `HOLIDAY_HOURS` int(11) DEFAULT NULL,
  `HOURS_DONE_IN_PARTIAL_DATE` longtext,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ASSIDUOUSNESS` int(11) DEFAULT NULL,
  `KEY_MODIFIED_BY` int(11) DEFAULT NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT NULL,
  `KEY_UNIT` int(11) DEFAULT NULL,
  `LAST_MODIFIED_DATE` timestamp NULL DEFAULT NULL,
  `NIGHT_HOURS` int(11) DEFAULT NULL,
  `NIGHT_VACATIONS_AMOUNT` double DEFAULT NULL,
  `NIGHT_VACATIONS_DAYS` int(11) DEFAULT NULL,
  `NORMAL_VACATIONS_AMOUNT` double DEFAULT NULL,
  `NORMAL_VACATIONS_DAYS` int(11) DEFAULT NULL,
  `OID` bigint(20) DEFAULT NULL,
  `OID_ASSIDUOUSNESS` bigint(20) DEFAULT NULL,
  `OID_MODIFIED_BY` bigint(20) DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) DEFAULT NULL,
  `OID_UNIT` bigint(20) DEFAULT NULL,
  `PARTIAL_PAYING_DATE` longtext,
  `REQUESTED_EXTRA_NIGHT_DAYS` int(11) DEFAULT NULL,
  `REQUESTED_EXTRA_NIGHT_HOURS` int(11) DEFAULT NULL,
  `REQUESTED_HOLIDAY_HOURS` int(11) DEFAULT NULL,
  `REQUESTED_NIGHT_HOURS` int(11) DEFAULT NULL,
  `REQUESTED_SATURDAY_HOURS` int(11) DEFAULT NULL,
  `REQUESTED_SUNDAY_HOURS` int(11) DEFAULT NULL,
  `REQUESTED_WORKDAY_HOURS` int(11) DEFAULT NULL,
  `SATURDAY_AMOUNT` double DEFAULT NULL,
  `SATURDAY_HOURS` int(11) DEFAULT NULL,
  `SUNDAY_AMOUNT` double DEFAULT NULL,
  `SUNDAY_HOURS` int(11) DEFAULT NULL,
  `WORKDAY_FIRST_LEVEL_AMOUNT` double DEFAULT NULL,
  `WORKDAY_FIRST_LEVEL_HOURS` int(11) DEFAULT NULL,
  `WORKDAY_HOURS` int(11) DEFAULT NULL,
  `WORKDAY_SECOND_LEVEL_AMOUNT` double DEFAULT NULL,
  `WORKDAY_SECOND_LEVEL_HOURS` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  KEY `OID` (`OID`),
  KEY `KEY_ASSIDUOUSNESS` (`KEY_ASSIDUOUSNESS`),
  KEY `OID_ASSIDUOUSNESS` (`OID_ASSIDUOUSNESS`),
  KEY `KEY_MODIFIED_BY` (`KEY_MODIFIED_BY`),
  KEY `OID_MODIFIED_BY` (`OID_MODIFIED_BY`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`),
  KEY `KEY_UNIT` (`KEY_UNIT`),
  KEY `OID_UNIT` (`OID_UNIT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EXTRA_WORK_REQUEST`
--


--
-- Table structure for table `FENIX_VERSION_INSTALLER`
--

CREATE TABLE `FENIX_VERSION_INSTALLER` (
  `VERSION_DATE` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`VERSION_DATE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `FENIX_VERSION_INSTALLER`
--


--
-- Table structure for table `FF$DOMAIN_CLASS_INFO`
--

CREATE TABLE `FF$DOMAIN_CLASS_INFO` (
  `DOMAIN_CLASS_NAME` varchar(255) NOT NULL,
  `DOMAIN_CLASS_ID` int(11) NOT NULL,
  UNIQUE KEY `U1` (`DOMAIN_CLASS_NAME`),
  UNIQUE KEY `U2` (`DOMAIN_CLASS_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `FF$DOMAIN_CLASS_INFO`
--

INSERT INTO `FF$DOMAIN_CLASS_INFO` VALUES ('net.sourceforge.fenixedu.domain.documents.ReceiptGeneratedDocument',1),('net.sourceforge.fenixedu.domain.util.FunctionalityPrinters',2),('net.sourceforge.fenixedu.domain.accounting.paymentPlans.GratuityPaymentPlanForStudentsEnroledOnlyInSecondSemester',3),('net.sourceforge.fenixedu.domain.phd.candidacy.PhdCandidacyRefereeLetter',4),('net.sourceforge.fenixedu.domain.messaging.ExecutionCourseAnnouncementBoard',5),('net.sourceforge.fenixedu.domain.organizationalStructure.UnitName',6),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.AcademicServiceRequestEvent',7),('net.sourceforge.fenixedu.domain.ExecutionSemester',8),('net.sourceforge.fenixedu.domain.onlineTests.StudentTestLog',9),('net.sourceforge.fenixedu.domain.teacher.Category',10),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.PastFreeSolicitationAcademicRequestPR',11),('net.sourceforge.fenixedu.domain.candidacy.IMDCandidacy',12),('net.sourceforge.fenixedu.domain.time.calendarStructure.GradeSubmissionInNormalSeasonCE',13),('net.sourceforge.fenixedu.domain.student.registrationStates.FlunkedState',14),('net.sourceforge.fenixedu.domain.thesis.ThesisSite',15),('net.sourceforge.fenixedu.domain.Teacher',16),('net.sourceforge.fenixedu.domain.accounting.postingRules.gratuity.DFAGratuityByNumberOfEnrolmentsPR',17),('net.sourceforge.fenixedu.domain.curricularRules.AnyCurricularCourse',18),('net.sourceforge.fenixedu.domain.ScientificCouncilSite',19),('net.sourceforge.fenixedu.domain.tests.NewTestGroup',20),('net.sourceforge.fenixedu.domain.Grouping',21),('net.sourceforge.fenixedu.domain.studentCurriculum.ExternalEnrolmentWrapper',22),('net.sourceforge.fenixedu.domain.teacher.TeacherProfessionalSituation',23),('net.sourceforge.fenixedu.domain.Seminaries.Seminary',24),('net.sourceforge.fenixedu.domain.accounting.postingRules.EnrolmentOutOfPeriodPR',25),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.DeclarationRequestEvent',26),('net.sourceforge.fenixedu.domain.curricularRules.MinimumNumberOfCreditsToEnrol',27),('net.sourceforge.fenixedu.domain.student.curriculum.CycleConclusionProcess',28),('net.sourceforge.fenixedu.domain.space.RoomInformation',29),('net.sourceforge.fenixedu.domain.accounting.paymentPlans.GratuityPaymentPlan',30),('net.sourceforge.fenixedu.domain.cardGeneration.CardGenerationProblem',31),('net.sourceforge.fenixedu.domain.assiduousness.UnitExtraWorkMovement',32),('net.sourceforge.fenixedu.domain.MetaDomainObject',33),('net.sourceforge.fenixedu.domain.CurricularYear',34),('net.sourceforge.fenixedu.domain.log.OptionalEnrolmentLog',35),('net.sourceforge.fenixedu.domain.accounting.postingRules.candidacy.DegreeChangeIndividualCandidacyPR',36),('net.sourceforge.fenixedu.domain.organizationalStructure.EmployeeContract',37),('net.sourceforge.fenixedu.domain.serviceRequests.PartialRegistrationRegimeRequest',38),('net.sourceforge.fenixedu.domain.student.registrationStates.TransitedState',39),('net.sourceforge.fenixedu.domain.precedences.RestrictionDoneOrHasEverBeenEnrolledInCurricularCourse',40),('net.sourceforge.fenixedu.domain.accounting.events.dfa.DfaRegistrationEvent',41),('net.sourceforge.fenixedu.domain.time.calendarStructure.EnrolmentsPeriodCE',42),('net.sourceforge.fenixedu.domain.DomainObject',43),('net.sourceforge.fenixedu.domain.contents.FunctionalityCall',44),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.PastCourseGroupChangeRequestEvent',45),('net.sourceforge.fenixedu.domain.studentCurriculum.ExternalEnrolment',46),('net.sourceforge.fenixedu.domain.LessonPlanning',47),('net.sourceforge.fenixedu.domain.accounting.postingRules.gratuity.DFAGratuityPR',48),('net.sourceforge.fenixedu.domain.QueueJobResultFile',49),('net.sourceforge.fenixedu.domain.protocols.ProtocolFile',50),('net.sourceforge.fenixedu.domain.accounting.postingRules.gratuity.DFAGratuityByAmountPerEctsPR',51),('net.sourceforge.fenixedu.domain.assiduousness.AssiduousnessStatus',52),('net.sourceforge.fenixedu.domain.phd.PhdProgramFocusArea',53),('net.sourceforge.fenixedu.domain.ExpectationEvaluationGroup',54),('net.sourceforge.fenixedu.domain.UnitSiteLink',55),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TSDCurricularLoad',56),('net.sourceforge.fenixedu.domain.time.calendarStructure.AcademicSemesterCE',57),('net.sourceforge.fenixedu.domain.util.email.Message',58),('net.sourceforge.fenixedu.domain.accounting.events.insurance.InsuranceEvent',59),('net.sourceforge.fenixedu.domain.ProjectSubmissionFile',60),('net.sourceforge.fenixedu.domain.LessonInstance',61),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.ExternalCourseLoadRequest',62),('net.sourceforge.fenixedu.domain.candidacyProcess.IndividualCandidacyInternalPersonDetails',63),('net.sourceforge.fenixedu.domain.parking.ParkingFile',64),('net.sourceforge.fenixedu.domain.phd.candidacy.PhdProgramCandidacyEvent',65),('net.sourceforge.fenixedu.domain.curricularRules.DegreeModulesSelectionLimit',66),('net.sourceforge.fenixedu.domain.accounting.paymentPlans.FullGratuityPaymentPlan',67),('net.sourceforge.fenixedu.domain.CoordinatorExecutionDegreeCoursesReport',68),('net.sourceforge.fenixedu.domain.phd.candidacy.PhdProgramCandidacyProcessDocument',69),('net.sourceforge.fenixedu.domain.serviceRequests.StudentReingressionRequest',70),('net.sourceforge.fenixedu.domain.studentCurriculum.Equivalence',71),('net.sourceforge.fenixedu.domain.Qualification',72),('net.sourceforge.fenixedu.domain.teacher.ExternalActivity',73),('net.sourceforge.fenixedu.domain.personnelSection.contracts.ContractSituation',74),('net.sourceforge.fenixedu.domain.degreeStructure.CycleCourseGroup',75),('net.sourceforge.fenixedu.domain.accounting.paymentCodes.GratuitySituationPaymentCode',76),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.ApprovementCertificateRequest',77),('net.sourceforge.fenixedu.domain.Guide',78),('net.sourceforge.fenixedu.domain.inquiries.StudentInquiriesTeachingResult',79),('net.sourceforge.fenixedu.domain.period.DegreeChangeCandidacyPeriod',80),('net.sourceforge.fenixedu.domain.accounting.paymentCodes.AccountingEventPaymentCode',81),('net.sourceforge.fenixedu.domain.Department',82),('net.sourceforge.fenixedu.domain.time.calendarStructure.ExamsPeriodInNormalSeasonCE',83),('net.sourceforge.fenixedu.domain.organizationalStructure.TutorUnit',84),('net.sourceforge.fenixedu.domain.parking.ParkingPartyHistory',85),('net.sourceforge.fenixedu.domain.research.project.Project',86),('net.sourceforge.fenixedu.domain.ExternalDegreeEnrolment',87),('net.sourceforge.fenixedu.domain.research.activity.EventEdition',88),('net.sourceforge.fenixedu.domain.Coordinator',89),('net.sourceforge.fenixedu.domain.ResearchUnitSite',90),('net.sourceforge.fenixedu.domain.grant.contract.GrantType',91),('net.sourceforge.fenixedu.domain.support.FAQSection',92),('net.sourceforge.fenixedu.domain.organizationalStructure.PersonFunction',93),('net.sourceforge.fenixedu.domain.accounting.events.AdministrativeOfficeFeeAndInsuranceExemption',94),('net.sourceforge.fenixedu.domain.Seminaries.CaseStudy',95),('net.sourceforge.fenixedu.domain.tests.NewStringQuestion',96),('net.sourceforge.fenixedu.domain.StudentCurricularPlan',97),('net.sourceforge.fenixedu.domain.curricularRules.PrecedenceRule',98),('net.sourceforge.fenixedu.domain.grant.contract.GrantProject',99),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.PastDegreeDiplomaRequestPR',100),('net.sourceforge.fenixedu.domain.accounting.ServiceAgreement',101),('net.sourceforge.fenixedu.domain.EmptyDegreeCurricularPlan',102),('net.sourceforge.fenixedu.domain.CurricularSemester',103),('net.sourceforge.fenixedu.domain.organizationalStructure.ResearcherContract',104),('net.sourceforge.fenixedu.domain.research.activity.JournalIssue',105),('net.sourceforge.fenixedu.domain.reports.TeachersByShiftReportFile',106),('net.sourceforge.fenixedu.domain.finalDegreeWork.FinalDegreeWorkGroup',107),('net.sourceforge.fenixedu.domain.administrativeOffice.AdministrativeOffice',108),('net.sourceforge.fenixedu.domain.studentCurriculum.Credits',109),('net.sourceforge.fenixedu.domain.degreeStructure.CompetenceCourseInformationChangeRequest',110),('net.sourceforge.fenixedu.domain.period.StandaloneCandidacyPeriod',111),('net.sourceforge.fenixedu.domain.ProjectSubmission',112),('net.sourceforge.fenixedu.domain.research.result.ResultTeacher',113),('net.sourceforge.fenixedu.domain.EmployeeHistoric',114),('net.sourceforge.fenixedu.domain.onlineTests.Question',115),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TSDProcess',116),('net.sourceforge.fenixedu.domain.precedences.RestrictionNotDoneCurricularCourse',117),('net.sourceforge.fenixedu.domain.studentCurriculum.CurriculumLine',118),('net.sourceforge.fenixedu.domain.inquiries.InquiriesTeacher',119),('net.sourceforge.fenixedu.domain.ProfessionalSituation',120),('net.sourceforge.fenixedu.domain.teacher.ServiceProviderRegime',121),('net.sourceforge.fenixedu.domain.student.registrationStates.TransitionalState',122),('net.sourceforge.fenixedu.domain.elections.YearDelegateElection',123),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.ExtraCurricularEnrolmentCertificateRequestPR',124),('net.sourceforge.fenixedu.domain.Attends',125),('net.sourceforge.fenixedu.domain.EnrolmentEvaluation',126),('net.sourceforge.fenixedu.domain.personnelSection.contracts.ProfessionalCategory',127),('net.sourceforge.fenixedu.domain.assiduousness.UnitExtraWorkAmount',128),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.EnrolmentCertificateRequest',129),('net.sourceforge.fenixedu.domain.functionalities.ExecutionPath',130),('net.sourceforge.fenixedu.domain.assiduousness.IdentificationCard',131),('net.sourceforge.fenixedu.domain.teacher.TeacherMasterDegreeService',132),('net.sourceforge.fenixedu.domain.student.registrationStates.SchoolPartConcludedState',133),('net.sourceforge.fenixedu.domain.period.DegreeCandidacyForGraduatedPersonCandidacyPeriod',134),('net.sourceforge.fenixedu.domain.space.UnitSpaceOccupation',135),('net.sourceforge.fenixedu.domain.accounting.postingRules.candidacy.DegreeCandidacyForGraduatedPersonPR',136),('net.sourceforge.fenixedu.domain.thesis.ThesisLibraryArchiveOperation',137),('net.sourceforge.fenixedu.domain.accounting.events.candidacy.IndividualCandidacyEvent',138),('net.sourceforge.fenixedu.domain.research.result.publication.BookPart',139),('net.sourceforge.fenixedu.domain.accounting.events.candidacy.Over23IndividualCandidacyEvent',140),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.BolonhaDegreeDiplomaRequestEvent',141),('net.sourceforge.fenixedu.domain.phd.PhdProgramProcessState',142),('net.sourceforge.fenixedu.domain.accounting.events.gratuity.DfaGratuityEvent',143),('net.sourceforge.fenixedu.domain.library.LibraryCard',144),('net.sourceforge.fenixedu.domain.candidacy.DFACandidacy',145),('net.sourceforge.fenixedu.domain.tests.NewAtomicQuestion',146),('net.sourceforge.fenixedu.domain.accounting.postingRules.gratuity.StandaloneEnrolmentGratuityPR',147),('net.sourceforge.fenixedu.domain.TeacherPersonalExpectationsVisualizationPeriod',148),('net.sourceforge.fenixedu.domain.EvaluationMethod',149),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.BolonhaMasterDegreeDiplomaRequestEvent',150),('net.sourceforge.fenixedu.domain.residence.ResidencePriceTable',151),('net.sourceforge.fenixedu.domain.functionalities.Functionality',152),('net.sourceforge.fenixedu.domain.accounting.events.ImprovementOfApprovedEnrolmentPenaltyExemption',153),('net.sourceforge.fenixedu.domain.Employee',154),('net.sourceforge.fenixedu.domain.person.IdDocumentTypeObject',155),('net.sourceforge.fenixedu.domain.student.YearDelegateCourseInquiry',156),('net.sourceforge.fenixedu.domain.space.Campus',157),('net.sourceforge.fenixedu.domain.GratuityValues',158),('net.sourceforge.fenixedu.domain.contacts.EmailAddress',159),('net.sourceforge.fenixedu.domain.util.email.CurrentUserReplyTo',160),('net.sourceforge.fenixedu.domain.serviceRequests.SentToExternalEntityAcademicServiceRequestSituation',161),('net.sourceforge.fenixedu.domain.documents.GeneratedDocumentWithoutSource',162),('net.sourceforge.fenixedu.domain.time.calendarStructure.TeacherCreditsFillingForDepartmentAdmOfficeCE',163),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.PastExtraExamRequestPR',164),('net.sourceforge.fenixedu.domain.student.curriculum.ConclusionProcess',165),('net.sourceforge.fenixedu.domain.messaging.AnnouncementBoard',166),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.RegistrationAcademicServiceRequestEvent',167),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.DiplomaRequestPR',168),('net.sourceforge.fenixedu.domain.messaging.UnitAnnouncementBoard',169),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.ExternalCourseLoadRequestPR',170),('net.sourceforge.fenixedu.domain.tests.NewDateQuestion',171),('net.sourceforge.fenixedu.domain.onlineTests.Test',172),('net.sourceforge.fenixedu.domain.tests.NewStringMaterial',173),('net.sourceforge.fenixedu.domain.YearStudentSpecialSeasonCode',174),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TSDVirtualTeacher',175),('net.sourceforge.fenixedu.domain.organizationalStructure.UnitCostCenterCode',176),('net.sourceforge.fenixedu.domain.phd.PhdStudyPlan',177),('net.sourceforge.fenixedu.domain.messaging.ExecutionCourseForum',178),('net.sourceforge.fenixedu.domain.accounting.events.gratuity.StandaloneEnrolmentGratuityEvent',179),('net.sourceforge.fenixedu.domain.credits.ManagementPositionCreditLine',180),('net.sourceforge.fenixedu.domain.thesis.ThesisFile',181),('net.sourceforge.fenixedu.domain.PersonalGroup',182),('net.sourceforge.fenixedu.domain.finalDegreeWork.GroupStudent',183),('net.sourceforge.fenixedu.domain.tests.NewQuestion',184),('net.sourceforge.fenixedu.domain.contacts.Phone',185),('net.sourceforge.fenixedu.domain.degree.enrollment.NotNeedToEnrollInCurricularCourse',186),('net.sourceforge.fenixedu.domain.candidacyProcess.IndividualCandidacyProcess',187),('net.sourceforge.fenixedu.domain.util.email.Sender',188),('net.sourceforge.fenixedu.domain.research.result.ResearchResult',189),('net.sourceforge.fenixedu.domain.inquiries.StudentInquiriesCourseResult',190),('net.sourceforge.fenixedu.domain.CourseLoad',191),('net.sourceforge.fenixedu.domain.curricularRules.MaximumNumberOfCreditsForEnrolmentPeriod',192),('net.sourceforge.fenixedu.domain.PunctualRoomsOccupationRequest',193),('net.sourceforge.fenixedu.domain.teacher.TeacherService',194),('net.sourceforge.fenixedu.domain.curricularRules.CompositeRule',195),('net.sourceforge.fenixedu.domain.messaging.ConversationMessage',196),('net.sourceforge.fenixedu.domain.onlineTests.StudentTestQuestion',197),('net.sourceforge.fenixedu.domain.EmptyDegree',198),('net.sourceforge.fenixedu.domain.log.requests.RequestLog',199),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.ExternalProgramCertificateRequestPR',200),('net.sourceforge.fenixedu.domain.GuideEntry',201),('net.sourceforge.fenixedu.domain.accessControl.academicAdminOffice.UpdateRegistrationAfterConclusionPermission',202),('net.sourceforge.fenixedu.domain.candidacyProcess.over23.Over23IndividualCandidacy',203),('net.sourceforge.fenixedu.domain.contacts.WebAddress',204),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.StandaloneEnrolmentCertificateRequestPR',205),('net.sourceforge.fenixedu.domain.onlineTests.Metadata',206),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.PhotocopyRequestPR',207),('net.sourceforge.fenixedu.domain.candidacy.CancelledCandidacySituation',208),('net.sourceforge.fenixedu.domain.degreeStructure.CompetenceCourseLoad',209),('net.sourceforge.fenixedu.domain.log.requests.ErrorLog',210),('net.sourceforge.fenixedu.domain.contacts.PartyContact',211),('net.sourceforge.fenixedu.domain.space.CampusInformation',212),('net.sourceforge.fenixedu.domain.UnitSite',213),('net.sourceforge.fenixedu.domain.EnrolmentPeriodInClasses',214),('net.sourceforge.fenixedu.domain.phd.candidacy.PhdProgramPublicCandidacyHashCode',215),('net.sourceforge.fenixedu.domain.gratuity.masterDegree.SibsPaymentFileEntry',216),('net.sourceforge.fenixedu.domain.student.WeeklyWorkLoad',217),('net.sourceforge.fenixedu.domain.UnitSiteBanner',218),('net.sourceforge.fenixedu.domain.student.curriculum.RegistrationConclusionProcess',219),('net.sourceforge.fenixedu.domain.period.DegreeTransferCandidacyPeriod',220),('net.sourceforge.fenixedu.domain.research.ResearchInterest',221),('net.sourceforge.fenixedu.domain.support.SupportSugestion',222),('net.sourceforge.fenixedu.domain.TeacherExpectationDefinitionPeriod',223),('net.sourceforge.fenixedu.domain.organizationalStructure.Contract',224),('net.sourceforge.fenixedu.domain.student.Student',225),('net.sourceforge.fenixedu.domain.curricularRules.RestrictionDoneDegreeModule',226),('net.sourceforge.fenixedu.domain.phd.alert.PhdAlert',227),('net.sourceforge.fenixedu.domain.organizationalStructure.ResearchUnit',228),('net.sourceforge.fenixedu.domain.curricularPeriod.CurricularPeriod',229),('net.sourceforge.fenixedu.domain.serviceRequests.AcademicServiceRequestYear',230),('net.sourceforge.fenixedu.domain.ShiftEnrolment',231),('net.sourceforge.fenixedu.domain.assiduousness.ClockUnit',232),('net.sourceforge.fenixedu.domain.Photograph',233),('net.sourceforge.fenixedu.domain.student.ResidenceCandidacies',234),('net.sourceforge.fenixedu.domain.CurricularCourse',235),('net.sourceforge.fenixedu.domain.assiduousness.WorkSchedule',236),('net.sourceforge.fenixedu.domain.serviceRequests.AcademicServiceRequestSituation',237),('net.sourceforge.fenixedu.domain.ExecutionCourseSite',238),('net.sourceforge.fenixedu.domain.space.Space',239),('net.sourceforge.fenixedu.domain.candidacy.NotAdmittedCandidacySituation',240),('net.sourceforge.fenixedu.domain.reports.RaidesDfaReportFile',241),('net.sourceforge.fenixedu.domain.inquiries.teacher.TeachingInquiry',242),('net.sourceforge.fenixedu.domain.finalDegreeWork.Scheduleing',243),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.PastCertificateRequestPR',244),('net.sourceforge.fenixedu.domain.resource.VehicleAllocation',245),('net.sourceforge.fenixedu.domain.personnelSection.contracts.ProfessionalRelation',246),('net.sourceforge.fenixedu.domain.accounting.serviceAgreements.DegreeCurricularPlanServiceAgreement',247),('net.sourceforge.fenixedu.domain.tests.NewTestElement',248),('net.sourceforge.fenixedu.domain.research.project.ProjectEventAssociation',249),('net.sourceforge.fenixedu.domain.accounting.events.PenaltyExemption',250),('net.sourceforge.fenixedu.domain.period.Over23CandidacyPeriod',251),('net.sourceforge.fenixedu.domain.vigilancy.VigilantWrapper',252),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.ExtraCurricularCertificateRequest',253),('net.sourceforge.fenixedu.domain.phd.candidacy.PhdCandidacyReferee',254),('net.sourceforge.fenixedu.domain.student.registrationStates.InterruptedState',255),('net.sourceforge.fenixedu.domain.accounting.events.AdministrativeOfficeFeeAndInsuranceEvent',256),('net.sourceforge.fenixedu.domain.research.activity.ArticleAssociation',257),('net.sourceforge.fenixedu.domain.space.MaterialSpaceOccupation',258),('net.sourceforge.fenixedu.domain.accounting.postingRules.BaseAmountPlusAmountPerPagePR',259),('net.sourceforge.fenixedu.domain.ScientificAreaSite',260),('net.sourceforge.fenixedu.domain.accounting.events.AdministrativeOfficeFeeAndInsuranceExemptionJustificationByDispatch',261),('net.sourceforge.fenixedu.domain.precedences.RestrictionNotEnrolledInCurricularCourse',262),('net.sourceforge.fenixedu.domain.accounting.AccountingTransactionDetail',263),('net.sourceforge.fenixedu.domain.serviceRequests.EquivalencePlanRevisionRequest',264),('net.sourceforge.fenixedu.domain.tests.NewNumericQuestion',265),('net.sourceforge.fenixedu.domain.student.curriculum.ConclusionProcessVersion',266),('net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode',267),('net.sourceforge.fenixedu.domain.contents.Element',268),('net.sourceforge.fenixedu.domain.University',269),('net.sourceforge.fenixedu.domain.student.registrationStates.StudyPlanConcludedState',270),('net.sourceforge.fenixedu.domain.accounting.events.AdministrativeOfficeFeeAndInsuranceExemptionJustification',271),('net.sourceforge.fenixedu.domain.Shift',272),('net.sourceforge.fenixedu.domain.log.requests.RequestMapping',273),('net.sourceforge.fenixedu.domain.Login',274),('net.sourceforge.fenixedu.domain.tests.NewAnswer',275),('net.sourceforge.fenixedu.domain.accessControl.academicAdminOffice.GenericAdministrativeOfficePermission',276),('net.sourceforge.fenixedu.domain.material.MaterialResponsibility',277),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.CourseLoadRequestPR',278),('net.sourceforge.fenixedu.domain.documents.DocumentRequestGeneratedDocument',279),('net.sourceforge.fenixedu.domain.onlineTests.TestQuestion',280),('net.sourceforge.fenixedu.domain.personnelSection.contracts.EmployeeServiceExemption',281),('net.sourceforge.fenixedu.domain.time.calendarStructure.GradeSubmissionInSpecialSeasonCE',282),('net.sourceforge.fenixedu.domain.accounting.Account',283),('net.sourceforge.fenixedu.domain.candidacyProcess.degreeTransfer.DegreeTransferCandidacyProcess',284),('net.sourceforge.fenixedu.domain.period.CandidacyProcessCandidacyPeriod',285),('net.sourceforge.fenixedu.domain.accounting.events.dfa.DFACandidacyEvent',286),('net.sourceforge.fenixedu.domain.Item',287),('net.sourceforge.fenixedu.domain.grant.owner.GrantOwner',288),('net.sourceforge.fenixedu.domain.serviceRequests.EquivalencePlanRequest',289),('net.sourceforge.fenixedu.domain.MarkSheet',290),('net.sourceforge.fenixedu.domain.phd.InternalGuiding',291),('net.sourceforge.fenixedu.domain.WrittenTest',292),('net.sourceforge.fenixedu.domain.space.SpaceInformation',293),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.PhotocopyRequest',294),('net.sourceforge.fenixedu.domain.EnrolmentPeriodInImprovementOfApprovedEnrolment',295),('net.sourceforge.fenixedu.domain.reports.RegistrationReportFile',296),('net.sourceforge.fenixedu.domain.reports.StatusAndApprovalReportFile',297),('net.sourceforge.fenixedu.domain.accounting.postingRules.PastAdministrativeOfficeFeeAndInsurancePR',298),('net.sourceforge.fenixedu.domain.space.PersonSpaceOccupation',299),('net.sourceforge.fenixedu.domain.degree.finalProject.TeacherDegreeFinalProjectStudent',300),('net.sourceforge.fenixedu.domain.util.email.ExecutionCourseSender',301),('net.sourceforge.fenixedu.domain.studentCurriculum.TemporarySubstitution',302),('net.sourceforge.fenixedu.domain.classProperties.ExecutionCourseProperty',303),('net.sourceforge.fenixedu.domain.precedences.Restriction',304),('net.sourceforge.fenixedu.domain.candidacyProcess.secondCycle.SecondCycleCandidacyProcess',305),('net.sourceforge.fenixedu.domain.precedences.Precedence',306),('net.sourceforge.fenixedu.domain.organizationalStructure.ConnectionRule',307),('net.sourceforge.fenixedu.domain.research.result.publication.OtherPublication',308),('net.sourceforge.fenixedu.domain.phd.PhdProcessState',309),('net.sourceforge.fenixedu.domain.personnelSection.contracts.ServiceExemption',310),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.DocumentRequest',311),('net.sourceforge.fenixedu.domain.documents.LibraryMissingCardsDocument',312),('net.sourceforge.fenixedu.domain.resource.Vehicle',313),('net.sourceforge.fenixedu.domain.PublicCandidacyHashCode',314),('net.sourceforge.fenixedu.domain.util.email.SystemSender',315),('net.sourceforge.fenixedu.domain.phd.PhdProgramUnit',316),('net.sourceforge.fenixedu.domain.credits.CreditLine',317),('net.sourceforge.fenixedu.domain.personnelSection.contracts.EmployeeProfessionalExemption',318),('net.sourceforge.fenixedu.domain.resource.ResourceResponsibility',319),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.PastExtraExamRequestEvent',320),('net.sourceforge.fenixedu.domain.contents.Attachment',321),('net.sourceforge.fenixedu.domain.phd.candidacy.PhdProgramCandidacyProcess',322),('net.sourceforge.fenixedu.domain.reports.RaidesGraduationReportFile',323),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.PastCourseGroupChangeRequestPR',324),('net.sourceforge.fenixedu.domain.teacher.PublicationsNumber',325),('net.sourceforge.fenixedu.domain.PublicRelationsStudentListQueueJob',326),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.PhotocopyRequestEvent',327),('net.sourceforge.fenixedu.domain.accounting.CreditNote',328),('net.sourceforge.fenixedu.domain.space.FloorInformation',329),('net.sourceforge.fenixedu.domain.accounting.SibsPaymentFileProcessReport',330),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.PastPhotocopyRequestPR',331),('net.sourceforge.fenixedu.domain.research.activity.ScientificJournalParticipation',332),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.ExamDateCertificateRequest',333),('net.sourceforge.fenixedu.domain.organizationalStructure.PedagogicalCouncilUnit',334),('net.sourceforge.fenixedu.domain.finalDegreeWork.GroupProposal',335),('net.sourceforge.fenixedu.domain.support.SupportDemand',336),('net.sourceforge.fenixedu.domain.assiduousness.Justification',337),('net.sourceforge.fenixedu.domain.research.project.ProjectParticipation',338),('net.sourceforge.fenixedu.domain.phd.alert.PhdPublicPresentationSeminarAlert',339),('net.sourceforge.fenixedu.domain.assiduousness.JustificationMotive',340),('net.sourceforge.fenixedu.domain.organizationalStructure.ScientificAreaUnit',341),('net.sourceforge.fenixedu.domain.organizationalStructure.CompetenceCourseGroupUnit',342),('net.sourceforge.fenixedu.domain.assiduousness.Leave',343),('net.sourceforge.fenixedu.domain.FileLocalContentMetadata',344),('net.sourceforge.fenixedu.domain.time.calendarStructure.AcademicCalendarRootEntry',345),('net.sourceforge.fenixedu.domain.accounting.accountingTransactions.detail.SibsTransactionDetail',346),('net.sourceforge.fenixedu.domain.assiduousness.AssiduousnessStatusHistory',347),('net.sourceforge.fenixedu.domain.CandidateEnrolment',348),('net.sourceforge.fenixedu.domain.Tutorship',349),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.StandaloneEnrolmentCertificateRequest',350),('net.sourceforge.fenixedu.domain.assiduousness.AssiduousnessCampusHistory',351),('net.sourceforge.fenixedu.domain.Formation',352),('net.sourceforge.fenixedu.domain.parking.ParkingRequest',353),('net.sourceforge.fenixedu.domain.complain.EvaluationComplain',354),('net.sourceforge.fenixedu.domain.messaging.ForumSubscription',355),('net.sourceforge.fenixedu.domain.accounting.installments.PartialRegimeInstallment',356),('net.sourceforge.fenixedu.domain.period.SecondCycleCandidacyPeriod',357),('net.sourceforge.fenixedu.domain.thesis.ThesisLibraryOperation',358),('net.sourceforge.fenixedu.domain.assiduousness.ExtraWorkAuthorization',359),('net.sourceforge.fenixedu.domain.accounting.Installment',360),('net.sourceforge.fenixedu.domain.accounting.events.gratuity.ValueGratuityExemption',361),('net.sourceforge.fenixedu.domain.messaging.AnnouncementCategory',362),('net.sourceforge.fenixedu.domain.assiduousness.WorkPeriod',363),('net.sourceforge.fenixedu.domain.TeacherPersonalExpectationPeriod',364),('net.sourceforge.fenixedu.domain.studentCurriculum.StandaloneCurriculumGroup',365),('net.sourceforge.fenixedu.domain.AssemblySite',366),('net.sourceforge.fenixedu.domain.time.calendarStructure.AcademicTrimesterCE',367),('net.sourceforge.fenixedu.domain.accounting.postingRules.candidacy.SecondCycleIndividualCandidacyPR',368),('net.sourceforge.fenixedu.domain.research.Researcher',369),('net.sourceforge.fenixedu.domain.ExecutionYear',370),('net.sourceforge.fenixedu.domain.UnitFileTag',371),('net.sourceforge.fenixedu.domain.accounting.postingRules.candidacy.DegreeTransferIndividualCandidacyPR',372),('net.sourceforge.fenixedu.domain.Evaluation',373),('net.sourceforge.fenixedu.domain.tests.NewPermissionUnit',374),('net.sourceforge.fenixedu.domain.phd.candidacy.PhdCandidacyRefereeLetterFile',375),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.GenericDeclarationRequest',376),('net.sourceforge.fenixedu.domain.CreditsInAnySecundaryArea',377),('net.sourceforge.fenixedu.domain.util.email.ResearchUnitBasedSender',378),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.PastFreeSolicitationAcademicRequestEvent',379),('net.sourceforge.fenixedu.domain.reports.RaidesPhdReportFile',380),('net.sourceforge.fenixedu.domain.accounting.events.gratuity.GratuityExemptionJustificationByDispatch',381),('net.sourceforge.fenixedu.domain.student.StudentStatute',382),('net.sourceforge.fenixedu.domain.research.activity.EventParticipation',383),('net.sourceforge.fenixedu.domain.space.RoomSubdivisionInformation',384),('net.sourceforge.fenixedu.domain.student.registrationStates.ExternalAbandonState',385),('net.sourceforge.fenixedu.domain.teacher.TeacherPersonalExpectation',386),('net.sourceforge.fenixedu.domain.Seminaries.CourseEquivalency',387),('net.sourceforge.fenixedu.domain.organizationalStructure.ResearchContract',388),('net.sourceforge.fenixedu.domain.util.email.PersonReplyTo',389),('net.sourceforge.fenixedu.domain.transactions.SmsTransaction',390),('net.sourceforge.fenixedu.domain.assiduousness.EmployeeExtraWorkAuthorization',391),('net.sourceforge.fenixedu.domain.reports.GraduationReportFile',392),('net.sourceforge.fenixedu.domain.grant.contract.GrantInsurance',393),('net.sourceforge.fenixedu.domain.phd.alert.PhdCustomAlert',394),('net.sourceforge.fenixedu.domain.caseHandling.ProcessLog',395),('net.sourceforge.fenixedu.domain.File',396),('net.sourceforge.fenixedu.domain.serviceRequests.PersonAcademicServiceRequest',397),('net.sourceforge.fenixedu.domain.OldMarkSheet',398),('net.sourceforge.fenixedu.domain.reports.FlunkedReportFile',399),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.PastEquivalencePlanRevisionRequestEvent',400),('net.sourceforge.fenixedu.domain.Seminaries.Modality',401),('net.sourceforge.fenixedu.domain.candidacyProcess.over23.Over23IndividualCandidacyProcess',402),('net.sourceforge.fenixedu.domain.curricularRules.RestrictionEnroledDegreeModule',403),('net.sourceforge.fenixedu.domain.support.SupportRequest',404),('net.sourceforge.fenixedu.domain.studentCurriculum.Substitution',405),('net.sourceforge.fenixedu.domain.finalDegreeWork.Proposal',406),('net.sourceforge.fenixedu.domain.research.result.ResearchResultDocumentFile',407),('net.sourceforge.fenixedu.domain.inquiries.InquiryResponsePeriod',408),('net.sourceforge.fenixedu.domain.accounting.paymentCodes.MasterDegreeInsurancePaymentCode',409),('net.sourceforge.fenixedu.domain.phd.candidacy.PHDProgramCandidacy',410),('net.sourceforge.fenixedu.domain.accounting.postingRules.FixedAmountWithPenaltyFromDatePR',411),('net.sourceforge.fenixedu.domain.grant.contract.GrantSubsidy',412),('net.sourceforge.fenixedu.domain.assiduousness.Assiduousness',413),('net.sourceforge.fenixedu.domain.teacher.TeacherServiceExemption',414),('net.sourceforge.fenixedu.domain.candidacyProcess.degreeChange.DegreeChangeIndividualCandidacyProcess',415),('net.sourceforge.fenixedu.domain.assiduousness.AssiduousnessClosedDay',416),('net.sourceforge.fenixedu.domain.student.RegistrationDataByExecutionYear',417),('net.sourceforge.fenixedu.domain.accounting.events.gratuity.GratuityEvent',418),('net.sourceforge.fenixedu.domain.tests.NewPresentationMaterial',419),('net.sourceforge.fenixedu.domain.candidacyProcess.degreeTransfer.DegreeTransferIndividualCandidacyProcess',420),('net.sourceforge.fenixedu.domain.accounting.PaymentPlan',421),('net.sourceforge.fenixedu.domain.PaymentPhase',422),('net.sourceforge.fenixedu.domain.organizationalStructure.AdministrativeOfficeUnit',423),('net.sourceforge.fenixedu.domain.organizationalStructure.UnitAcronym',424),('net.sourceforge.fenixedu.domain.space.ExtensionSpaceOccupation',425),('net.sourceforge.fenixedu.domain.teacher.TeacherPastService',426),('net.sourceforge.fenixedu.domain.UnitSiteBannerFile',427),('net.sourceforge.fenixedu.domain.support.SupportException',428),('net.sourceforge.fenixedu.domain.phd.alert.PhdCandidacyRefereeAlert',429),('net.sourceforge.fenixedu.domain.ExecutionInterval',430),('net.sourceforge.fenixedu.domain.FinalEvaluation',431),('net.sourceforge.fenixedu.domain.research.result.ResultParticipation',432),('net.sourceforge.fenixedu.domain.Country',433),('net.sourceforge.fenixedu.domain.degreeStructure.CompetenceCourseInformation',434),('net.sourceforge.fenixedu.domain.TutorSite',435),('net.sourceforge.fenixedu.domain.grant.contract.GrantOrientationTeacher',436),('net.sourceforge.fenixedu.domain.research.result.publication.Proceedings',437),('net.sourceforge.fenixedu.domain.organizationalStructure.ResearchScholarshipContract',438),('net.sourceforge.fenixedu.domain.space.Room',439),('net.sourceforge.fenixedu.domain.candidacyProcess.degreeChange.DegreeChangeIndividualCandidacy',440),('net.sourceforge.fenixedu.domain.CurricularCourseScope',441),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.CertificateRequestPR',442),('net.sourceforge.fenixedu.domain.time.calendarStructure.ExamsPeriodCE',443),('net.sourceforge.fenixedu.domain.ExportGrouping',444),('net.sourceforge.fenixedu.domain.teacher.Career',445),('net.sourceforge.fenixedu.domain.serviceRequests.RegistrationAcademicServiceRequest',446),('net.sourceforge.fenixedu.domain.accounting.installments.InstallmentWithMonthlyPenalty',447),('net.sourceforge.fenixedu.domain.Seminaries.Theme',448),('net.sourceforge.fenixedu.domain.functionalities.AvailabilityPolicy',449),('net.sourceforge.fenixedu.domain.accounting.events.AnnualEvent',450),('net.sourceforge.fenixedu.domain.accounting.ServiceAgreementPaymentPlan',451),('net.sourceforge.fenixedu.domain.studentCurriculum.InternalEnrolmentWrapper',452),('net.sourceforge.fenixedu.domain.DegreeInfoFuture',453),('net.sourceforge.fenixedu.domain.candidacy.SubstituteCandidacySituation',454),('net.sourceforge.fenixedu.domain.organizationalStructure.AccountabilityType',455),('net.sourceforge.fenixedu.domain.contacts.MobilePhone',456),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TSDVirtualCourseGroup',457),('net.sourceforge.fenixedu.domain.Seminaries.SeminaryCandidacy',458),('net.sourceforge.fenixedu.domain.curricularRules.AndRule',459),('net.sourceforge.fenixedu.domain.organizationalStructure.SchoolUnit',460),('net.sourceforge.fenixedu.domain.accounting.AcademicEvent',461),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.DiplomaRequest',462),('net.sourceforge.fenixedu.domain.accounting.events.gratuity.PastDegreeGratuityEvent',463),('net.sourceforge.fenixedu.domain.grant.contract.GrantPaymentEntity',464),('net.sourceforge.fenixedu.domain.student.RegistrationNumber',465),('net.sourceforge.fenixedu.domain.support.SupportDoubt',466),('net.sourceforge.fenixedu.domain.transactions.Transaction',467),('net.sourceforge.fenixedu.domain.accessControl.academicAdminOffice.AdministrativeOfficePermissionGroup',468),('net.sourceforge.fenixedu.domain.Price',469),('net.sourceforge.fenixedu.domain.candidacyProcess.degreeTransfer.DegreeTransferIndividualCandidacy',470),('net.sourceforge.fenixedu.domain.research.result.publication.Thesis',471),('net.sourceforge.fenixedu.domain.DeleteFileRequest',472),('net.sourceforge.fenixedu.domain.accounting.events.candidacy.DegreeCandidacyForGraduatedPersonEvent',473),('net.sourceforge.fenixedu.domain.InstitutionSite',474),('net.sourceforge.fenixedu.domain.tests.NewMathMlMaterial',475),('net.sourceforge.fenixedu.domain.reports.TutorshipProgramReportFile',476),('net.sourceforge.fenixedu.domain.time.calendarStructure.TeacherCreditsFillingCE',477),('net.sourceforge.fenixedu.domain.candidacy.MDCandidacy',478),('net.sourceforge.fenixedu.domain.EnrolmentPeriodInCurricularCoursesSpecialSeason',479),('net.sourceforge.fenixedu.domain.studentCurriculum.OptionalDismissal',480),('net.sourceforge.fenixedu.domain.util.UsernameCounter',481),('net.sourceforge.fenixedu.domain.accounting.events.gratuity.GratuityExemption',482),('net.sourceforge.fenixedu.domain.space.Building',483),('net.sourceforge.fenixedu.domain.reports.TeachersListReportFile',484),('net.sourceforge.fenixedu.domain.onlineTests.TestScope',485),('net.sourceforge.fenixedu.domain.internship.InternshipCandidacy',486),('net.sourceforge.fenixedu.domain.StudentGroup',487),('net.sourceforge.fenixedu.domain.GuideSituation',488),('net.sourceforge.fenixedu.domain.space.AllocatableSpace',489),('net.sourceforge.fenixedu.domain.phd.PhdStudyPlanEntry',490),('net.sourceforge.fenixedu.domain.precedences.RestrictionByNumberOfCurricularCourses',491),('net.sourceforge.fenixedu.domain.student.registrationStates.MobilityState',492),('net.sourceforge.fenixedu.domain.EmployeeProfessionalSituation',493),('net.sourceforge.fenixedu.domain.tests.NewPictureMaterial',494),('net.sourceforge.fenixedu.domain.assiduousness.WorkScheduleType',495),('net.sourceforge.fenixedu.domain.teacher.OldPublication',496),('net.sourceforge.fenixedu.domain.accounting.events.candidacy.DegreeChangeIndividualCandidacyEvent',497),('net.sourceforge.fenixedu.domain.accounting.events.PastAdministrativeOfficeFeeAndInsuranceEvent',498),('net.sourceforge.fenixedu.domain.reports.GepReportFile',499),('net.sourceforge.fenixedu.domain.serviceRequests.ExtraExamRequest',500),('net.sourceforge.fenixedu.domain.candidacyProcess.IndividualCandidacyPersonalDetails',501),('net.sourceforge.fenixedu.domain.organizationalStructure.PartySocialSecurityNumber',502),('net.sourceforge.fenixedu.domain.support.GlossaryEntry',503),('net.sourceforge.fenixedu.domain.thesis.ThesisLibraryCancelOperation',504),('net.sourceforge.fenixedu.domain.accounting.events.EnrolmentOutOfPeriodEvent',505),('net.sourceforge.fenixedu.domain.parking.ParkingGroup',506),('net.sourceforge.fenixedu.domain.personnelSection.contracts.FunctionsAccumulation',507),('net.sourceforge.fenixedu.domain.assiduousness.HalfTimeSchedule',508),('net.sourceforge.fenixedu.domain.assiduousness.Periodicity',509),('net.sourceforge.fenixedu.domain.accounting.events.penaltyExemptionJustifications.PenaltyExemptionJustificationByDispatch',510),('net.sourceforge.fenixedu.domain.residence.ResidenceYear',511),('net.sourceforge.fenixedu.domain.space.EventSpaceOccupation',512),('net.sourceforge.fenixedu.domain.tests.NewTestModel',513),('net.sourceforge.fenixedu.domain.teacher.ProfessionalCareer',514),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.DeclarationRequestPR',515),('net.sourceforge.fenixedu.domain.Branch',516),('net.sourceforge.fenixedu.domain.DegreeSite',517),('net.sourceforge.fenixedu.domain.degreeStructure.Context',518),('net.sourceforge.fenixedu.domain.EducationArea',519),('net.sourceforge.fenixedu.domain.PhotographContent',520),('net.sourceforge.fenixedu.domain.research.result.publication.Manual',521),('net.sourceforge.fenixedu.domain.transactions.GratuityTransaction',522),('net.sourceforge.fenixedu.domain.MasterDegreeCandidate',523),('net.sourceforge.fenixedu.domain.space.WrittenEvaluationSpaceOccupation',524),('net.sourceforge.fenixedu.domain.phd.candidacy.PhdCandidacyPeriod',525),('net.sourceforge.fenixedu.domain.Project',526),('net.sourceforge.fenixedu.domain.personnelSection.contracts.EmployeeFunctionsAccumulation',527),('net.sourceforge.fenixedu.domain.assiduousness.AssiduousnessExemptionShift',528),('net.sourceforge.fenixedu.domain.accounting.CreditNoteEntry',529),('net.sourceforge.fenixedu.domain.space.BlueprintFile',530),('net.sourceforge.fenixedu.domain.OccupationPeriod',531),('net.sourceforge.fenixedu.domain.TeacherAutoEvaluationDefinitionPeriod',532),('net.sourceforge.fenixedu.domain.candidacy.degree.ShiftDistribution',533),('net.sourceforge.fenixedu.domain.ExternalCurricularCourse',534),('net.sourceforge.fenixedu.domain.teacher.workTime.TeacherInstitutionWorkTime',535),('net.sourceforge.fenixedu.domain.tests.NewAllGroup',536),('net.sourceforge.fenixedu.domain.Degree',537),('net.sourceforge.fenixedu.domain.protocols.ProtocolHistory',538),('net.sourceforge.fenixedu.domain.EnrolmentPeriod',539),('net.sourceforge.fenixedu.domain.reports.CourseLoadReportFile',540),('net.sourceforge.fenixedu.domain.candidacy.Candidacy',541),('net.sourceforge.fenixedu.domain.inquiries.OldInquiriesSummary',542),('net.sourceforge.fenixedu.domain.serviceRequests.FreeSolicitationAcademicRequest',543),('net.sourceforge.fenixedu.domain.Role',544),('net.sourceforge.fenixedu.domain.research.result.publication.TechnicalReport',545),('net.sourceforge.fenixedu.domain.accounting.events.gratuity.PercentageGratuityExemption',546),('net.sourceforge.fenixedu.domain.accounting.events.PenaltyExemptionJustification',547),('net.sourceforge.fenixedu.domain.accounting.postingRules.gratuity.PastDegreeGratuityPR',548),('net.sourceforge.fenixedu.domain.assiduousness.Meal',549),('net.sourceforge.fenixedu.domain.student.PrecedentDegreeInformation',550),('net.sourceforge.fenixedu.domain.DegreeCurricularPlan',551),('net.sourceforge.fenixedu.domain.organizationalStructure.UniversityUnit',552),('net.sourceforge.fenixedu.domain.research.Prize',553),('net.sourceforge.fenixedu.domain.functionalities.ExpressionGroupAvailability',554),('net.sourceforge.fenixedu.domain.CreditsInScientificArea',555),('net.sourceforge.fenixedu.domain.Locality',556),('net.sourceforge.fenixedu.domain.MasterDegreeThesis',557),('net.sourceforge.fenixedu.domain.contents.Node',558),('net.sourceforge.fenixedu.domain.OptionalEnrolment',559),('net.sourceforge.fenixedu.domain.Contributor',560),('net.sourceforge.fenixedu.domain.RegistrationPeriodInDegreeCurricularPlan',561),('net.sourceforge.fenixedu.domain.DegreeInfoCandidacy',562),('net.sourceforge.fenixedu.domain.Person',563),('net.sourceforge.fenixedu.domain.research.activity.Participation',564),('net.sourceforge.fenixedu.domain.accounting.ReceiptPrintVersion',565),('net.sourceforge.fenixedu.domain.research.activity.ScientificJournal',566),('net.sourceforge.fenixedu.domain.teacher.InstitutionWorkTime',567),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.PartialRegistrationRegimeRequestEvent',568),('net.sourceforge.fenixedu.domain.accounting.postingRules.ImprovementOfApprovedEnrolmentPR',569),('net.sourceforge.fenixedu.domain.DegreeContext',570),('net.sourceforge.fenixedu.domain.organizationalStructure.SectionUnit',571),('net.sourceforge.fenixedu.domain.InsuranceValue',572),('net.sourceforge.fenixedu.domain.Holiday',573),('net.sourceforge.fenixedu.domain.material.Extension',574),('net.sourceforge.fenixedu.domain.vigilancy.OwnCourseVigilancy',575),('net.sourceforge.fenixedu.domain.candidacy.degree.ShiftDistributionEntry',576),('net.sourceforge.fenixedu.domain.organizationalStructure.Party',577),('net.sourceforge.fenixedu.domain.assiduousness.AssiduousnessRecord',578),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.PastDegreeDiplomaRequestEvent',579),('net.sourceforge.fenixedu.domain.AlumniIdentityCheckRequest',580),('net.sourceforge.fenixedu.domain.reports.EurAceReportFile',581),('net.sourceforge.fenixedu.domain.inquiries.OldInquiriesTeachersRes',582),('net.sourceforge.fenixedu.domain.studentCurriculum.ExternalCurriculumGroup',583),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.DegreeFinalizationCertificateRequest',584),('net.sourceforge.fenixedu.domain.studentCurriculum.ExtraCurriculumGroup',585),('net.sourceforge.fenixedu.domain.gesdis.StudentCourseReport',586),('net.sourceforge.fenixedu.domain.curricularRules.OrRule',587),('net.sourceforge.fenixedu.domain.CostCenter',588),('net.sourceforge.fenixedu.domain.teacher.TeacherServiceItem',589),('net.sourceforge.fenixedu.domain.UnitFile',590),('net.sourceforge.fenixedu.domain.degreeStructure.RootCourseGroup',591),('net.sourceforge.fenixedu.domain.protocols.Protocol',592),('net.sourceforge.fenixedu.domain.classProperties.GeneralClassProperty',593),('net.sourceforge.fenixedu.domain.RootDomainObject',594),('net.sourceforge.fenixedu.domain.Alumni',595),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.DeclarationRequest',596),('net.sourceforge.fenixedu.domain.documents.LibraryMissingLettersDocument',597),('net.sourceforge.fenixedu.domain.organizationalStructure.ResidenceManagementUnit',598),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.PastStudentReingressionRequestPR',599),('net.sourceforge.fenixedu.domain.assiduousness.AssiduousnessVacations',600),('net.sourceforge.fenixedu.domain.assiduousness.AssiduousnessRecordMonthIndex',601),('net.sourceforge.fenixedu.domain.assiduousness.AssiduousnessExtraWork',602),('net.sourceforge.fenixedu.domain.accessControl.academicAdminOffice.AdministrativeOfficePermission',603),('net.sourceforge.fenixedu.domain.organizationalStructure.AggregateUnit',604),('net.sourceforge.fenixedu.domain.research.activity.JournalIssueParticipation',605),('net.sourceforge.fenixedu.domain.homepage.Homepage',606),('net.sourceforge.fenixedu.domain.reimbursementGuide.ReimbursementGuide',607),('net.sourceforge.fenixedu.domain.messaging.PublicBoardFileContent',608),('net.sourceforge.fenixedu.domain.phd.PhdProgram',609),('net.sourceforge.fenixedu.domain.assiduousness.FlexibleSchedule',610),('net.sourceforge.fenixedu.domain.NonAffiliatedTeacher',611),('net.sourceforge.fenixedu.domain.student.StudentDataByExecutionYear',612),('net.sourceforge.fenixedu.domain.elections.DelegateElectionCandidacyPeriod',613),('net.sourceforge.fenixedu.domain.PunctualRoomsOccupationStateInstant',614),('net.sourceforge.fenixedu.domain.parking.ParkingRequestPeriod',615),('net.sourceforge.fenixedu.domain.precedences.RestrictionByNumberOfDoneCurricularCourses',616),('net.sourceforge.fenixedu.domain.degreeStructure.DegreeModule',617),('net.sourceforge.fenixedu.domain.vigilancy.VigilantGroup',618),('net.sourceforge.fenixedu.domain.contacts.PhysicalAddress',619),('net.sourceforge.fenixedu.domain.candidacyProcess.over23.Over23IndividualCandidacyDegreeEntry',620),('net.sourceforge.fenixedu.domain.degreeStructure.CourseGroup',621),('net.sourceforge.fenixedu.domain.elections.DelegateElectionVote',622),('net.sourceforge.fenixedu.domain.accounting.postingRules.dfa.DFACandidacyPR',623),('net.sourceforge.fenixedu.domain.research.result.publication.Unstructured',624),('net.sourceforge.fenixedu.domain.personnelSection.contracts.EmployeeGrantOwnerEquivalent',625),('net.sourceforge.fenixedu.domain.organizationalStructure.DegreeUnit',626),('net.sourceforge.fenixedu.domain.material.PersonExtension',627),('net.sourceforge.fenixedu.domain.space.RoomClassification',628),('net.sourceforge.fenixedu.domain.accounting.Exemption',629),('net.sourceforge.fenixedu.domain.teacher.WeeklyOcupation',630),('net.sourceforge.fenixedu.domain.util.email.ExecutionCourseReplyTo',631),('net.sourceforge.fenixedu.domain.person.IdDocument',632),('net.sourceforge.fenixedu.domain.inquiries.InquiriesCourse',633),('net.sourceforge.fenixedu.domain.candidacyProcess.graduatedPerson.DegreeCandidacyForGraduatedPersonProcess',634),('net.sourceforge.fenixedu.domain.inquiries.InquiriesRoom',635),('net.sourceforge.fenixedu.domain.accounting.events.AdministrativeOfficeFeeAndInsurancePenaltyExemption',636),('net.sourceforge.fenixedu.domain.SupportLesson',637),('net.sourceforge.fenixedu.domain.Enrolment',638),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TSDCurricularCourse',639),('net.sourceforge.fenixedu.domain.tests.NewModelGroup',640),('net.sourceforge.fenixedu.domain.candidacyProcess.CandidacyProcess',641),('net.sourceforge.fenixedu.domain.onlineTests.DistributedTest',642),('net.sourceforge.fenixedu.domain.tests.NewCorrector',643),('net.sourceforge.fenixedu.domain.accounting.paymentPlans.GratuityPaymentPlanForPartialRegimeEnroledOnlyInSecondSemester',644),('net.sourceforge.fenixedu.domain.inquiries.OldInquiriesCoursesRes',645),('net.sourceforge.fenixedu.domain.candidacy.PreCandidacySituation',646),('net.sourceforge.fenixedu.domain.research.result.publication.ResearchResultPublication',647),('net.sourceforge.fenixedu.domain.ManagementCouncilSite',648),('net.sourceforge.fenixedu.domain.reports.ParkingDataReportFile',649),('net.sourceforge.fenixedu.domain.student.registrationStates.InternalAbandonState',650),('net.sourceforge.fenixedu.domain.CandidacyPeriodInDegreeCurricularPlan',651),('net.sourceforge.fenixedu.domain.phd.alert.PhdAlertMessage',652),('net.sourceforge.fenixedu.domain.functionalities.FunctionalityParameter',653),('net.sourceforge.fenixedu.domain.space.BuildingInformation',654),('net.sourceforge.fenixedu.domain.DegreeCurricularPlanEquivalencePlan',655),('net.sourceforge.fenixedu.domain.WrittenEvaluationEnrolment',656),('net.sourceforge.fenixedu.domain.Exam',657),('net.sourceforge.fenixedu.domain.accounting.events.candidacy.SecondCycleIndividualCandidacyEvent',658),('net.sourceforge.fenixedu.domain.FileContent',659),('net.sourceforge.fenixedu.domain.accounting.events.ExemptionJustification',660),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.PastEquivalencePlanRevisionRequestPR',661),('net.sourceforge.fenixedu.domain.curricularRules.CreditsLimit',662),('net.sourceforge.fenixedu.domain.personnelSection.contracts.GrantOwnerEquivalent',663),('net.sourceforge.fenixedu.domain.candidacyProcess.DegreeOfficePublicCandidacyHashCode',664),('net.sourceforge.fenixedu.domain.accounting.postingRules.GenericSingleEntryTypePR',665),('net.sourceforge.fenixedu.domain.PunctualRoomsOccupationComment',666),('net.sourceforge.fenixedu.domain.resource.Resource',667),('net.sourceforge.fenixedu.domain.organizationalStructure.PartyType',668),('net.sourceforge.fenixedu.domain.time.calendarStructure.ExamsPeriodInSpecialSeasonCE',669),('net.sourceforge.fenixedu.domain.phd.InternalPhdStudyPlanEntry',670),('net.sourceforge.fenixedu.domain.StudentCurricularPlanEquivalencePlan',671),('net.sourceforge.fenixedu.domain.candidacy.SDCandidacy',672),('net.sourceforge.fenixedu.domain.FinalMark',673),('net.sourceforge.fenixedu.domain.caseHandling.Process',674),('net.sourceforge.fenixedu.domain.ProjectSubmissionLog',675),('net.sourceforge.fenixedu.domain.phd.ExternalPhdStudyPlanEntry',676),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TSDProfessorship',677),('net.sourceforge.fenixedu.domain.SchoolClass',678),('net.sourceforge.fenixedu.domain.gesdis.CourseReport',679),('net.sourceforge.fenixedu.domain.log.EnrolmentLog',680),('net.sourceforge.fenixedu.domain.parking.ParkingParty',681),('net.sourceforge.fenixedu.domain.accounting.events.candidacy.SecondCycleIndividualCandidacyExemptionJustification',682),('net.sourceforge.fenixedu.domain.studentCurriculum.Dismissal',683),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.StudentReingressionRequestEvent',684),('net.sourceforge.fenixedu.domain.organizationalStructure.DepartmentUnit',685),('net.sourceforge.fenixedu.domain.DomainObjectActionLog',686),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TSDCourse',687),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.PastCertificateRequestEvent',688),('net.sourceforge.fenixedu.domain.EquivalencePlan',689),('net.sourceforge.fenixedu.domain.organizationalStructure.Unit',690),('net.sourceforge.fenixedu.domain.serviceRequests.AcademicServiceRequest',691),('net.sourceforge.fenixedu.domain.messaging.Announcement',692),('net.sourceforge.fenixedu.domain.Summary',693),('net.sourceforge.fenixedu.domain.research.activity.EventEditionParticipation',694),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.BolonhaAdvancedFormationDiplomaRequestEvent',695),('net.sourceforge.fenixedu.domain.contents.Portal',696),('net.sourceforge.fenixedu.domain.documents.GeneratedDocument',697),('net.sourceforge.fenixedu.domain.LoginRequest',698),('net.sourceforge.fenixedu.domain.vigilancy.UnavailablePeriod',699),('net.sourceforge.fenixedu.domain.projectsManagement.ProjectAccess',700),('net.sourceforge.fenixedu.domain.phd.PhdProgramGuiding',701),('net.sourceforge.fenixedu.domain.phd.PhdIndividualProgramProcess',702),('net.sourceforge.fenixedu.domain.BusinessArea',703),('net.sourceforge.fenixedu.domain.candidacy.StandByConfirmedDataCandidacySituation',704),('net.sourceforge.fenixedu.domain.material.FireExtinguisher',705),('net.sourceforge.fenixedu.domain.time.calendarStructure.GradeSubmissionCE',706),('net.sourceforge.fenixedu.domain.assiduousness.Card',707),('net.sourceforge.fenixedu.domain.candidacyProcess.InstitutionPrecedentDegreeInformation',708),('net.sourceforge.fenixedu.domain.thesis.ThesisEvaluationParticipant',709),('net.sourceforge.fenixedu.domain.EquivalencePlanEntry',710),('net.sourceforge.fenixedu.domain.Professorship',711),('net.sourceforge.fenixedu.domain.documents.AnnualIRSDeclarationDocument',712),('net.sourceforge.fenixedu.domain.curricularRules.EnrolmentToBeApprovedByCoordinator',713),('net.sourceforge.fenixedu.domain.log.CreditsDismissalLog',714),('net.sourceforge.fenixedu.domain.reimbursementGuide.ReimbursementGuideSituation',715),('net.sourceforge.fenixedu.domain.PersonAccount',716),('net.sourceforge.fenixedu.domain.candidacyProcess.Formation',717),('net.sourceforge.fenixedu.domain.assiduousness.AssiduousnessExemption',718),('net.sourceforge.fenixedu.domain.student.RegistrationRegime',719),('net.sourceforge.fenixedu.domain.precedences.RestrictionHasEverBeenOrIsCurrentlyEnrolledInCurricularCourse',720),('net.sourceforge.fenixedu.domain.LoginAlias',721),('net.sourceforge.fenixedu.domain.SecretaryEnrolmentStudent',722),('net.sourceforge.fenixedu.domain.organizationalStructure.ScientificCouncilUnit',723),('net.sourceforge.fenixedu.domain.teacher.OtherService',724),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.CertificateRequestEvent',725),('net.sourceforge.fenixedu.domain.credits.DatePeriodBaseCreditLine',726),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TSDProcessPhase',727),('net.sourceforge.fenixedu.domain.assiduousness.ScheduleExemption',728),('net.sourceforge.fenixedu.domain.space.SpaceResponsibility',729),('net.sourceforge.fenixedu.domain.tests.NewMultipleChoiceQuestion',730),('net.sourceforge.fenixedu.domain.ResourceAllocationRole',731),('net.sourceforge.fenixedu.domain.time.calendarStructure.TeacherCreditsFillingForTeacherCE',732),('net.sourceforge.fenixedu.domain.candidacy.AdmittedCandidacySituation',733),('net.sourceforge.fenixedu.domain.assiduousness.ClosedMonthFile',734),('net.sourceforge.fenixedu.domain.assiduousness.Clocking',735),('net.sourceforge.fenixedu.domain.space.LessonSpaceOccupation',736),('net.sourceforge.fenixedu.domain.candidacy.CandidacySituation',737),('net.sourceforge.fenixedu.domain.MasterDegreeProofVersion',738),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TSDTeacher',739),('net.sourceforge.fenixedu.domain.personnelSection.contracts.EmployeeProfessionalCategory',740),('net.sourceforge.fenixedu.domain.grant.contract.GrantPart',741),('net.sourceforge.fenixedu.domain.accessControl.PersistentGroupMembers',742),('net.sourceforge.fenixedu.domain.gratuity.masterDegree.SibsPaymentFile',743),('net.sourceforge.fenixedu.domain.contents.Container',744),('net.sourceforge.fenixedu.domain.time.calendarStructure.AcademicYearCE',745),('net.sourceforge.fenixedu.domain.Mark',746),('net.sourceforge.fenixedu.domain.organizationalStructure.Function',747),('net.sourceforge.fenixedu.domain.Curriculum',748),('net.sourceforge.fenixedu.domain.elections.DelegateElectionPeriod',749),('net.sourceforge.fenixedu.domain.accounting.events.gratuity.exemption.penalty.InstallmentPenaltyExemption',750),('net.sourceforge.fenixedu.domain.research.activity.Cooperation',751),('net.sourceforge.fenixedu.domain.messaging.Forum',752),('net.sourceforge.fenixedu.domain.util.email.ReplyTo',753),('net.sourceforge.fenixedu.domain.UnitSiteFile',754),('net.sourceforge.fenixedu.domain.student.registrationStates.RegistrationState',755),('net.sourceforge.fenixedu.domain.system.CronScriptState',756),('net.sourceforge.fenixedu.domain.Job',757),('net.sourceforge.fenixedu.domain.space.RoomSubdivision',758),('net.sourceforge.fenixedu.domain.organizationalStructure.CountryUnit',759),('net.sourceforge.fenixedu.domain.transactions.InsuranceTransaction',760),('net.sourceforge.fenixedu.domain.accounting.postingRules.gratuity.GratuityWithPaymentPlanPR',761),('net.sourceforge.fenixedu.domain.curricularRules.NotRule',762),('net.sourceforge.fenixedu.domain.grant.contract.GrantContractMovement',763),('net.sourceforge.fenixedu.domain.DomainObjectActionLogEntry',764),('net.sourceforge.fenixedu.domain.candidacy.CandidacyDocumentFile',765),('net.sourceforge.fenixedu.domain.FileLocalContent',766),('net.sourceforge.fenixedu.domain.organizationalStructure.ExternalContract',767),('net.sourceforge.fenixedu.domain.messaging.PartyAnnouncementBoard',768),('net.sourceforge.fenixedu.domain.vigilancy.ExamCoordinator',769),('net.sourceforge.fenixedu.domain.assiduousness.ContinuousSchedule',770),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TeacherServiceDistribution',771),('net.sourceforge.fenixedu.domain.GenericEvent',772),('net.sourceforge.fenixedu.domain.accounting.postingRules.BaseAmountPlusAmountPerUnitPR',773),('net.sourceforge.fenixedu.domain.assiduousness.HourExemptionSchedule',774),('net.sourceforge.fenixedu.domain.log.CurriculumLineLog',775),('net.sourceforge.fenixedu.domain.candidacyProcess.IndividualCandidacyExternalPersonDetails',776),('net.sourceforge.fenixedu.domain.elections.DelegateElectionVotingPeriod',777),('net.sourceforge.fenixedu.domain.tests.NewQuestionGroup',778),('net.sourceforge.fenixedu.domain.teacher.Orientation',779),('net.sourceforge.fenixedu.domain.accounting.postingRules.AdministrativeOfficeFeePR',780),('net.sourceforge.fenixedu.domain.organizationalStructure.UnitNamePart',781),('net.sourceforge.fenixedu.domain.assiduousness.ClosedMonth',782),('net.sourceforge.fenixedu.domain.DeleteFileLog',783),('net.sourceforge.fenixedu.domain.organizationalStructure.ResearchTechnicalStaffContract',784),('net.sourceforge.fenixedu.domain.DeployNotifier',785),('net.sourceforge.fenixedu.domain.accounting.postingRules.dfa.DfaRegistrationPR',786),('net.sourceforge.fenixedu.domain.accounting.events.candidacy.SecondCycleIndividualCandidacyExemption',787),('net.sourceforge.fenixedu.domain.accounting.events.gratuity.GratuityEventWithPaymentPlan',788),('net.sourceforge.fenixedu.domain.curricularRules.RestrictionBetweenDegreeModules',789),('net.sourceforge.fenixedu.domain.accounting.installments.InstallmentWithPenalty',790),('net.sourceforge.fenixedu.domain.onlineTests.TestChecksum',791),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TSDRealTeacher',792),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TSDCompetenceCourse',793),('net.sourceforge.fenixedu.domain.tests.NewQuestionBank',794),('net.sourceforge.fenixedu.domain.student.YearDelegate',795),('net.sourceforge.fenixedu.domain.CompetenceCourse',796),('net.sourceforge.fenixedu.domain.studentCurriculum.EnrolmentWrapper',797),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.ProgramCertificateRequest',798),('net.sourceforge.fenixedu.domain.precedences.RestrictionByCurricularCourse',799),('net.sourceforge.fenixedu.domain.Site',800),('net.sourceforge.fenixedu.domain.EnrolmentPeriodInCurricularCourses',801),('net.sourceforge.fenixedu.domain.degreeStructure.OptionalCurricularCourse',802),('net.sourceforge.fenixedu.domain.thesis.Thesis',803),('net.sourceforge.fenixedu.domain.research.activity.CooperationParticipation',804),('net.sourceforge.fenixedu.domain.candidacy.RegisteredCandidacySituation',805),('net.sourceforge.fenixedu.domain.grant.contract.GrantContract',806),('net.sourceforge.fenixedu.domain.util.email.Recipient',807),('net.sourceforge.fenixedu.domain.accounting.paymentPlans.CustomGratuityPaymentPlan',808),('net.sourceforge.fenixedu.domain.candidacyProcess.graduatedPerson.DegreeCandidacyForGraduatedPerson',809),('net.sourceforge.fenixedu.domain.accounting.events.ImprovementOfApprovedEnrolmentEvent',810),('net.sourceforge.fenixedu.domain.accounting.events.candidacy.StandaloneIndividualCandidacyEvent',811),('net.sourceforge.fenixedu.domain.transactions.PaymentTransaction',812),('net.sourceforge.fenixedu.domain.teacher.TeachingCareer',813),('net.sourceforge.fenixedu.domain.functionalities.GroupAvailability',814),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.PastStudentReingressionRequestEvent',815),('net.sourceforge.fenixedu.domain.DegreeInfo',816),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.SchoolRegistrationCertificateRequest',817),('net.sourceforge.fenixedu.domain.util.email.UnitBasedSender',818),('net.sourceforge.fenixedu.domain.QueueJob',819),('net.sourceforge.fenixedu.domain.teacherServiceDistribution.TSDCurricularCourseGroup',820),('net.sourceforge.fenixedu.domain.CurricularCourseEquivalence',821),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.CourseLoadRequest',822),('net.sourceforge.fenixedu.domain.candidacyProcess.standalone.StandaloneCandidacyProcess',823),('net.sourceforge.fenixedu.domain.functionalities.Module',824),('net.sourceforge.fenixedu.domain.personnelSection.contracts.EmployeeProfessionalRegime',825),('net.sourceforge.fenixedu.domain.student.Senior',826),('net.sourceforge.fenixedu.domain.curricularRules.EvenOddRule',827),('net.sourceforge.fenixedu.domain.candidacy.StudentCandidacy',828),('net.sourceforge.fenixedu.domain.accounting.paymentCodes.InstallmentPaymentCode',829),('net.sourceforge.fenixedu.domain.Section',830),('net.sourceforge.fenixedu.domain.precedences.RestrictionHasEverBeenOrWillBeAbleToBeEnrolledInCurricularCourse',831),('net.sourceforge.fenixedu.domain.candidacyProcess.graduatedPerson.DegreeCandidacyForGraduatedPersonIndividualProcess',832),('net.sourceforge.fenixedu.domain.candidacyProcess.standalone.StandaloneIndividualCandidacy',833),('net.sourceforge.fenixedu.domain.GratuitySituation',834),('net.sourceforge.fenixedu.domain.personnelSection.payrollSection.bonus.AnualBonusInstallment',835),('net.sourceforge.fenixedu.domain.candidacy.StandByFilledDataCandidacySituation',836),('net.sourceforge.fenixedu.domain.studentCurriculum.CycleCurriculumGroup',837),('net.sourceforge.fenixedu.domain.gesdis.CourseHistoric',838),('net.sourceforge.fenixedu.domain.research.activity.ResearchEvent',839),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.ProgramCertificateRequestPR',840),('net.sourceforge.fenixedu.domain.accounting.postingRules.FixedAmountPR',841),('net.sourceforge.fenixedu.domain.accounting.Entry',842),('net.sourceforge.fenixedu.domain.accounting.postingRules.ResidencePR',843),('net.sourceforge.fenixedu.domain.SpecialSeasonCode',844),('net.sourceforge.fenixedu.domain.organizationalStructure.AcademicalInstitutionUnit',845),('net.sourceforge.fenixedu.domain.grant.contract.GrantContractRegime',846),('net.sourceforge.fenixedu.domain.research.activity.EventConferenceArticlesAssociation',847),('net.sourceforge.fenixedu.domain.student.Registration',848),('net.sourceforge.fenixedu.domain.candidacyProcess.standalone.StandaloneIndividualCandidacyProcess',849),('net.sourceforge.fenixedu.domain.phd.PhdIndividualProgramProcessNumber',850),('net.sourceforge.fenixedu.domain.accounting.serviceAgreementTemplates.DegreeCurricularPlanServiceAgreementTemplate',851),('net.sourceforge.fenixedu.domain.vigilancy.OtherCourseVigilancy',852),('net.sourceforge.fenixedu.domain.research.result.patent.ResearchResultPatent',853),('net.sourceforge.fenixedu.domain.reports.TeachersListFromGiafReportFile',854),('net.sourceforge.fenixedu.domain.candidacyProcess.ExternalPrecedentDegreeInformation',855),('net.sourceforge.fenixedu.domain.assiduousness.ExtraWorkRequest',856),('net.sourceforge.fenixedu.domain.credits.OtherTypeCreditLine',857),('net.sourceforge.fenixedu.domain.WrittenEvaluation',858),('net.sourceforge.fenixedu.domain.accounting.ResidenceEvent',859),('net.sourceforge.fenixedu.domain.reports.DissertationsWithExternalAffiliationsReportFile',860),('net.sourceforge.fenixedu.domain.support.FAQEntry',861),('net.sourceforge.fenixedu.domain.candidacyProcess.IndividualCandidacy',862),('net.sourceforge.fenixedu.domain.space.GenericEventSpaceOccupation',863),('net.sourceforge.fenixedu.domain.phd.alert.PhdRegistrationFormalizationAlert',864),('net.sourceforge.fenixedu.domain.accounting.serviceAgreementTemplates.AdministrativeOfficeServiceAgreementTemplate',865),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.PastEquivalencePlanRequestEvent',866),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.EnrolmentCertificateRequestPR',867),('net.sourceforge.fenixedu.domain.serviceRequests.ReceivedFromExternalEntityAcademicServiceRequestSituation',868),('net.sourceforge.fenixedu.domain.accounting.PostingRule',869),('net.sourceforge.fenixedu.domain.curricularRules.CurricularRule',870),('net.sourceforge.fenixedu.domain.studentCurriculum.CreditsDismissal',871),('net.sourceforge.fenixedu.domain.phd.ExternalGuiding',872),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.ExternalProgramCertificateRequest',873),('net.sourceforge.fenixedu.domain.teacher.TeacherServiceNotes',874),('net.sourceforge.fenixedu.domain.reports.EctsLabelDegreeReportFile',875),('net.sourceforge.fenixedu.domain.accounting.PaymentCodeMapping',876),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.CertificateRequest',877),('net.sourceforge.fenixedu.domain.candidacy.DegreeCandidacy',878),('net.sourceforge.fenixedu.domain.thesis.ThesisLibraryPendingOperation',879),('net.sourceforge.fenixedu.domain.accounting.ServiceAgreementTemplate',880),('net.sourceforge.fenixedu.domain.StudentsSite',881),('net.sourceforge.fenixedu.domain.DepartmentSite',882),('net.sourceforge.fenixedu.domain.person.PersonNamePart',883),('net.sourceforge.fenixedu.domain.util.email.ConcreteReplyTo',884),('net.sourceforge.fenixedu.domain.util.email.PersonFunctionSender',885),('net.sourceforge.fenixedu.domain.candidacy.StandByCandidacySituation',886),('net.sourceforge.fenixedu.domain.time.calendarStructure.LessonsPeriodCE',887),('net.sourceforge.fenixedu.domain.log.OptionalDismissalLog',888),('net.sourceforge.fenixedu.domain.system.CronRegistry',889),('net.sourceforge.fenixedu.domain.contents.MetaDomainObjectPortal',890),('net.sourceforge.fenixedu.domain.accounting.Discount',891),('net.sourceforge.fenixedu.domain.QueueJobWithFile',892),('net.sourceforge.fenixedu.domain.ScientificCommission',893),('net.sourceforge.fenixedu.domain.accounting.AccountingTransaction',894),('net.sourceforge.fenixedu.domain.personnelSection.payrollSection.bonus.EmployeeMonthlyBonusInstallment',895),('net.sourceforge.fenixedu.domain.candidacyProcess.secondCycle.SecondCycleIndividualCandidacy',896),('net.sourceforge.fenixedu.domain.candidacyProcess.over23.Over23CandidacyProcess',897),('net.sourceforge.fenixedu.domain.accounting.paymentPlans.FullGratuityPaymentPlanForPartialRegime',898),('net.sourceforge.fenixedu.domain.documents.CreditNoteGeneratedDocument',899),('net.sourceforge.fenixedu.domain.ShiftProfessorship',900),('net.sourceforge.fenixedu.domain.Seminaries.CaseStudyChoice',901),('net.sourceforge.fenixedu.domain.space.Floor',902),('net.sourceforge.fenixedu.domain.accounting.events.gratuity.GratuityExemptionJustification',903),('net.sourceforge.fenixedu.domain.District',904),('net.sourceforge.fenixedu.domain.assiduousness.ClosedMonthJustification',905),('net.sourceforge.fenixedu.domain.support.SupportError',906),('net.sourceforge.fenixedu.domain.accounting.paymentCodes.IndividualCandidacyPaymentCode',907),('net.sourceforge.fenixedu.domain.student.registrationStates.CanceledState',908),('net.sourceforge.fenixedu.domain.PedagogicalCouncilSite',909),('net.sourceforge.fenixedu.domain.util.email.CoordinatorSender',910),('net.sourceforge.fenixedu.domain.curricularRules.Exclusiveness',911),('net.sourceforge.fenixedu.domain.space.SpaceOccupation',912),('net.sourceforge.fenixedu.domain.accounting.PaymentCode',913),('net.sourceforge.fenixedu.domain.grant.contract.GrantCostCenter',914),('net.sourceforge.fenixedu.domain.parking.Vehicle',915),('net.sourceforge.fenixedu.domain.candidacyProcess.CandidacyPrecedentDegreeInformation',916),('net.sourceforge.fenixedu.domain.space.LessonInstanceSpaceOccupation',917),('net.sourceforge.fenixedu.domain.reports.EctsLabelCurricularCourseReportFile',918),('net.sourceforge.fenixedu.domain.accounting.postingRules.AdministrativeOfficeFeeAndInsurancePR',919),('net.sourceforge.fenixedu.domain.ManagementGroups',920),('net.sourceforge.fenixedu.domain.reports.DissertationsProposalsReportFile',921),('net.sourceforge.fenixedu.domain.personnelSection.contracts.ProfessionalRegime',922),('net.sourceforge.fenixedu.domain.inquiries.InquiriesRegistry',923),('net.sourceforge.fenixedu.domain.curricularRules.Rule',924),('net.sourceforge.fenixedu.domain.resource.ResourceAllocation',925),('net.sourceforge.fenixedu.domain.student.ExternalRegistrationData',926),('net.sourceforge.fenixedu.domain.tests.NewModelRestriction',927),('net.sourceforge.fenixedu.domain.CandidateSituation',928),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.EquivalencePlanRequestEvent',929),('net.sourceforge.fenixedu.domain.student.registrationStates.ConcludedState',930),('net.sourceforge.fenixedu.domain.studentCurriculum.RootCurriculumGroup',931),('net.sourceforge.fenixedu.domain.ExecutionCourse',932),('net.sourceforge.fenixedu.domain.AdHocEvaluation',933),('net.sourceforge.fenixedu.domain.cardGeneration.CardGenerationEntry',934),('net.sourceforge.fenixedu.domain.EnrolmentInOptionalCurricularCourse',935),('net.sourceforge.fenixedu.domain.studentCurriculum.PropaedeuticsCurriculumGroup',936),('net.sourceforge.fenixedu.domain.teacher.TeacherAdviseService',937),('net.sourceforge.fenixedu.domain.transactions.ReimbursementTransaction',938),('net.sourceforge.fenixedu.domain.time.calendarStructure.AcademicCalendarEntry',939),('net.sourceforge.fenixedu.domain.organizationalStructure.Accountability',940),('net.sourceforge.fenixedu.domain.research.result.publication.Book',941),('net.sourceforge.fenixedu.domain.reports.EtiReportFile',942),('net.sourceforge.fenixedu.domain.assiduousness.MissingClocking',943),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.PastPhotocopyRequestEvent',944),('net.sourceforge.fenixedu.domain.onlineTests.OnlineTest',945),('net.sourceforge.fenixedu.domain.ExecutionDegree',946),('net.sourceforge.fenixedu.domain.material.Material',947),('net.sourceforge.fenixedu.domain.accounting.serviceAgreementTemplates.UnitServiceAgreementTemplate',948),('net.sourceforge.fenixedu.domain.organizationalStructure.Invitation',949),('net.sourceforge.fenixedu.domain.precedences.RestrictionPeriodToApply',950),('net.sourceforge.fenixedu.domain.BibliographicReference',951),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.PastEquivalencePlanRequestPR',952),('net.sourceforge.fenixedu.domain.contents.Content',953),('net.sourceforge.fenixedu.domain.accounting.accountingTransactions.InstallmentAccountingTransaction',954),('net.sourceforge.fenixedu.domain.period.CandidacyPeriod',955),('net.sourceforge.fenixedu.domain.tests.NewSection',956),('net.sourceforge.fenixedu.domain.teacher.DegreeTeachingService',957),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.SchoolRegistrationDeclarationRequest',958),('net.sourceforge.fenixedu.domain.organizationalStructure.PlanetUnit',959),('net.sourceforge.fenixedu.domain.personnelSection.contracts.EmployeeProfessionalRelation',960),('net.sourceforge.fenixedu.domain.accounting.events.serviceRequests.DiplomaRequestEvent',961),('net.sourceforge.fenixedu.domain.gaugingTests.physics.GaugingTestResult',962),('net.sourceforge.fenixedu.domain.residence.ResidenceMonth',963),('net.sourceforge.fenixedu.domain.tests.NewChoice',964),('net.sourceforge.fenixedu.domain.util.Email',965),('net.sourceforge.fenixedu.domain.studentCurriculum.NoCourseGroupCurriculumGroup',966),('net.sourceforge.fenixedu.domain.teacher.Advise',967),('net.sourceforge.fenixedu.domain.messaging.AnnouncementNode',968),('net.sourceforge.fenixedu.domain.personnelSection.contracts.EmployeeSabbatical',969),('net.sourceforge.fenixedu.domain.precedences.RestrictionDoneCurricularCourse',970),('net.sourceforge.fenixedu.domain.log.requests.ExceptionType',971),('net.sourceforge.fenixedu.domain.accounting.postingRules.serviceRequests.ExamDateCertificateRequestPR',972),('net.sourceforge.fenixedu.domain.ScientificArea',973),('net.sourceforge.fenixedu.domain.organizationalStructure.ManagementCouncilUnit',974),('net.sourceforge.fenixedu.domain.inquiries.InquiriesStudentExecutionPeriod',975),('net.sourceforge.fenixedu.domain.accounting.Event',976),('net.sourceforge.fenixedu.domain.parking.NewParkingDocument',977),('net.sourceforge.fenixedu.domain.log.profiling.ProfileReport',978),('net.sourceforge.fenixedu.domain.DistrictSubdivision',979),('net.sourceforge.fenixedu.domain.space.Blueprint',980),('net.sourceforge.fenixedu.domain.research.result.publication.ConferenceArticles',981),('net.sourceforge.fenixedu.domain.tests.NewTest',982),('net.sourceforge.fenixedu.domain.User',983),('net.sourceforge.fenixedu.domain.accounting.postingRules.FixedAmountWithPenaltyPR',984),('net.sourceforge.fenixedu.domain.studentCurriculum.CurriculumModule',985),('net.sourceforge.fenixedu.domain.candidacyProcess.degreeChange.DegreeChangeCandidacyProcess',986),('net.sourceforge.fenixedu.domain.LoginPeriod',987),('net.sourceforge.fenixedu.domain.candidacyProcess.IndividualCandidacyDocumentFile',988),('net.sourceforge.fenixedu.domain.phd.PhdCandidacyProcessState',989),('net.sourceforge.fenixedu.domain.reimbursementGuide.ReimbursementGuideEntry',990),('net.sourceforge.fenixedu.domain.phd.PhdProgramServiceAgreementTemplate',991),('net.sourceforge.fenixedu.domain.vigilancy.Vigilancy',992),('net.sourceforge.fenixedu.domain.research.result.publication.Article',993),('net.sourceforge.fenixedu.domain.personnelSection.contracts.EmployeeContractSituation',994),('net.sourceforge.fenixedu.domain.serviceRequests.CourseGroupChangeRequest',995),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.IRSDeclarationRequest',996),('net.sourceforge.fenixedu.domain.tests.PictureMaterialFile',997),('net.sourceforge.fenixedu.domain.contents.DateOrderedNode',998),('net.sourceforge.fenixedu.domain.Lesson',999),('net.sourceforge.fenixedu.domain.accounting.ServiceAgreementTemplatePaymentPlan',1000),('net.sourceforge.fenixedu.domain.log.DismissalLog',1001),('net.sourceforge.fenixedu.domain.research.result.publication.Inproceedings',1002),('net.sourceforge.fenixedu.domain.person.PersonName',1003),('net.sourceforge.fenixedu.domain.Identification',1004),('net.sourceforge.fenixedu.domain.assiduousness.AssiduousnessClosedMonth',1005),('net.sourceforge.fenixedu.domain.assiduousness.ClosedMonthDocument',1006),('net.sourceforge.fenixedu.domain.tests.NewGroupElement',1007),('net.sourceforge.fenixedu.domain.serviceRequests.documentRequests.EnrolmentDeclarationRequest',1008),('net.sourceforge.fenixedu.domain.candidacy.CandidacyDocument',1009),('net.sourceforge.fenixedu.domain.elections.DelegateElection',1010),('net.sourceforge.fenixedu.domain.accounting.events.candidacy.DegreeTransferIndividualCandidacyEvent',1011),('net.sourceforge.fenixedu.domain.assiduousness.Schedule',1012),('net.sourceforge.fenixedu.domain.candidacyProcess.secondCycle.SecondCycleIndividualCandidacyProcess',1013),('net.sourceforge.fenixedu.domain.cardGeneration.CardGenerationBatch',1014),('net.sourceforge.fenixedu.domain.MasterDegreeThesisDataVersion',1015),('net.sourceforge.fenixedu.domain.TeacherPersonalExpectationsEvaluationPeriod',1016),('net.sourceforge.fenixedu.domain.system.CronScriptInvocation',1017),('net.sourceforge.fenixedu.domain.organizationalStructure.ResearchInternshipContract',1018),('net.sourceforge.fenixedu.domain.student.registrationStates.RegisteredState',1019),('net.sourceforge.fenixedu.domain.student.Delegate',1020),('net.sourceforge.fenixedu.domain.assiduousness.Anulation',1021),('net.sourceforge.fenixedu.domain.studentCurriculum.CurriculumGroup',1022),('net.sourceforge.fenixedu.domain.personnelSection.contracts.EmployeeProfessionalContract',1023),('net.sourceforge.fenixedu.domain.accounting.Receipt',1024),('net.sourceforge.fenixedu.domain.research.result.ResultUnitAssociation',1025),('net.sourceforge.fenixedu.domain.messaging.ConversationThread',1026),('net.sourceforge.fenixedu.domain.util.email.PersonSender',1027),('net.sourceforge.fenixedu.domain.personnelSection.payrollSection.bonus.EmployeeBonusInstallment',1028);

--
