DROP TABLE IF EXISTS `der2_refset_snomedctmapicd`;
CREATE TABLE `der2_refset_snomedctmapicd` (
  `id` varchar(36) NOT NULL, 
  `effectiveTime` varchar(20) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` TINYINT NOT NULL DEFAULT 0,
  `moduleId` BIGINT NOT NULL DEFAULT 0,
  `refsetId` BIGINT NOT NULL DEFAULT 0,
  `referencedComponentId` BIGINT NOT NULL,
  `mapGroup` INT(10) NOT NULL DEFAULT 0,
   `mapPriority` INT(10) NOT NULL DEFAULT 0,
   `mapRule` TINYTEXT NOT NULL,
   `mapAdvice` TINYTEXT  NOT NULL,
   `mapTarget` TINYTEXT,
   `correlationId` BIGINT NOT NULL DEFAULT 0,
   `mapCategoryId` BIGINT NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`,`effectiveTime`)  
);
