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) NULL comment '联系人及方式'; alter table `achievement_keyword` modify column `keyword` VARCHAR(16) NOT NULL COMMENT '科技成果关键词';