CREATE TABLE C_C_G_U_CONTEXT (
    ID_INTERNAL            		INT(11) AUTO_INCREMENT,
    KEY_COMPETENCE_COURSE_GROUP_UNIT	INT(11) NOT NULL,
    KEY_COMPETENCE_COURSE		INT(11) NOT NULL,
    KEY_BEGIN_EXECUTION_YEAR		INT(11) default NULL,
    KEY_END_EXECUTION_YEAR		INT(11) default NULL,
    KEY_ROOT_DOMAIN_OBJECT INT(11) 	NOT NULL DEFAULT 1,
    CREATION_ENTITY        		TEXT,
    CREATION_ENTITY_DATE   		DATE,
    UPDATE_ENTITY          		TEXT,
    UPDATE_ENTITY_DATE     		DATETIME,
    PRIMARY KEY(ID_INTERNAL),
        INDEX (KEY_COMPETENCE_COURSE_GROUP_UNIT),
	INDEX (KEY_COMPETENCE_COURSE),
    KEY `KEY_BEGIN_EXECUTION_YEAR` (`KEY_BEGIN_EXECUTION_YEAR`),
    KEY `KEY_END_EXECUTION_YEAR` (`KEY_END_EXECUTION_YEAR`),
    KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`)
);

