2017-05-24.sql 532 B

123456789101112131415
  1. CREATE TABLE `demand_keyword` (
  2. `id` VARCHAR(36) NOT NULL,
  3. `demand_id` VARCHAR(36) NOT NULL COMMENT '科技需求ID',
  4. `keyword` VARCHAR(16) NOT NULL COMMENT '关键词',
  5. PRIMARY KEY (`id`))
  6. ENGINE = InnoDB
  7. COMMENT = '科技需求关键词'
  8. CREATE TABLE `achievement_keyword` (
  9. `id` VARCHAR(36) NOT NULL,
  10. `achievement_id` VARCHAR(36) NOT NULL COMMENT '科技成果ID',
  11. `keyword` VARCHAR(36) NOT NULL COMMENT '科技成果关键词',
  12. PRIMARY KEY (`id`))
  13. ENGINE = InnoDB
  14. COMMENT = '科技成果关键词'