2017-05-28.sql 699 B

1234567891011121314151617
  1. CREATE TABLE `achievement_interest` (
  2. `id` varchar(36) NOT NULL,
  3. `achievement_id` varchar(36) NOT NULL COMMENT '科技成果ID',
  4. `uid` varchar(36) NOT NULL COMMENT '感兴趣人ID',
  5. `create_time` datetime NOT NULL COMMENT '记录创建时间(关注时间)',
  6. PRIMARY KEY (`id`)
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技成果"感兴趣(关注)"';
  8. CREATE TABLE `demand_interest` (
  9. `id` VARCHAR(36) NOT NULL,
  10. `demand_id` VARCHAR(36) NOT NULL COMMENT '需求主键',
  11. `uid` VARCHAR(36) NOT NULL COMMENT '关注人ID',
  12. `create_time` DATETIME NOT NULL COMMENT '关注时间',
  13. PRIMARY KEY (`id`))
  14. ENGINE = InnoDB
  15. COMMENT = '科技需求\"感兴趣(关注)\"'