CREATE TABLE `achievement_interest` ( `id` varchar(36) NOT NULL, `achievement_id` varchar(36) NOT NULL COMMENT '科技成果ID', `uid` varchar(36) NOT NULL COMMENT '感兴趣人ID', `create_time` datetime NOT NULL COMMENT '记录创建时间(关注时间)', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技成果"感兴趣(关注)"'; CREATE TABLE `demand_interest` ( `id` VARCHAR(36) NOT NULL, `demand_id` VARCHAR(36) NOT NULL COMMENT '需求主键', `uid` VARCHAR(36) NOT NULL COMMENT '关注人ID', `create_time` DATETIME NOT NULL COMMENT '关注时间', PRIMARY KEY (`id`)) ENGINE = InnoDB COMMENT = '科技需求\"感兴趣(关注)\"'