| 123456789101112131415161718192021 |
- 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 '科技成果关键词';
|