CREATE TABLE `LANGUAGE_COURSE_ENROLMENT` (
  `LEVEL` varchar(50) NOT NULL,
  `PAYED` tinyint(1),
  `GRADE` varchar(50),
  `ECTS` double,
  `CREDITS` double,  
  `ID_INTERNAL` int(11) NOT NULL auto_increment,
  `KEY_CANDIDACY` int(11) default NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) default NULL,
  `CREATION_ENTITY` text,
  `CREATION_ENTITY_DATE` date default NULL,
  `UPDATE_ENTITY` text,
  `UPDATE_ENTITY_DATE` datetime default NULL,
  `OID` bigint(20),
  `OID_CANDIDACY` bigint(20),
  `OID_ROOT_DOMAIN_OBJECT` bigint(20),  
  PRIMARY KEY  (`ID_INTERNAL`),
  KEY `KEY_CANDIDACY` (`KEY_CANDIDACY`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`)
) TYPE=InnoDB; 
