CREATE TABLE `demand_keyword` (
  `id` VARCHAR(36) NOT NULL,
  `demand_id` VARCHAR(36) NOT NULL COMMENT '科技需求ID',
  `keyword` VARCHAR(16) NOT NULL COMMENT '关键词',
  PRIMARY KEY (`id`))
ENGINE = InnoDB
COMMENT = '科技需求关键词';

CREATE TABLE `achievement_keyword` (
  `id` VARCHAR(36) NOT NULL,
  `achievement_id` VARCHAR(36) NOT NULL COMMENT '科技成果ID',
  `keyword` VARCHAR(36) NOT NULL COMMENT '科技成果关键词',
  PRIMARY KEY (`id`))
ENGINE = InnoDB
COMMENT = '科技成果关键词';

alter table `achievement` 
modify column `contacts`  int(1) comment '联系人及方式';