| 1234567891011121314151617 |
- 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 = '科技需求\"感兴趣(关注)\"'
|