47 lines
2.9 KiB
SQL
47 lines
2.9 KiB
SQL
CREATE TABLE IF NOT EXISTS `gxmu_tzb_project_list` (
|
||
`id` INT NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`source_id` BIGINT NOT NULL COMMENT '挑战杯详情ID',
|
||
`project_name` VARCHAR(512) NOT NULL COMMENT '项目名称',
|
||
`school_name` VARCHAR(255) DEFAULT NULL COMMENT '高校名称',
|
||
`award_name` VARCHAR(128) DEFAULT NULL COMMENT '获奖情况',
|
||
`match_year` INT DEFAULT NULL COMMENT '参赛年份',
|
||
`match_term` VARCHAR(128) DEFAULT NULL COMMENT '参赛届次',
|
||
`match_level` VARCHAR(64) DEFAULT NULL COMMENT '比赛级别',
|
||
`cover_image` VARCHAR(1024) DEFAULT NULL COMMENT '封面图',
|
||
`detail_url` VARCHAR(1024) NOT NULL COMMENT '详情链接',
|
||
`source_url` VARCHAR(1024) DEFAULT NULL COMMENT '来源列表页',
|
||
`page_no` INT DEFAULT NULL COMMENT '来源页码',
|
||
`last_sync_time` DATETIME DEFAULT NULL COMMENT '最近同步时间',
|
||
`create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` TINYINT NOT NULL DEFAULT 0 COMMENT '删除标记：0未删 1已删',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `uk_gxmu_tzb_project_source_id` (`source_id`),
|
||
KEY `idx_gxmu_tzb_project_match_year` (`match_year`),
|
||
KEY `idx_gxmu_tzb_project_school_name` (`school_name`(191))
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='挑战杯项目库列表';
|
||
|
||
CREATE TABLE IF NOT EXISTS `gxmu_tzb_talent_list` (
|
||
`id` INT NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`source_id` BIGINT NOT NULL COMMENT '挑战杯详情ID',
|
||
`person_name` VARCHAR(128) NOT NULL COMMENT '姓名',
|
||
`school_name` VARCHAR(255) DEFAULT NULL COMMENT '参赛学校',
|
||
`talent_type` VARCHAR(128) DEFAULT NULL COMMENT '人才类型',
|
||
`project_name` VARCHAR(512) DEFAULT NULL COMMENT '参赛项目',
|
||
`award_name` VARCHAR(128) DEFAULT NULL COMMENT '获奖情况',
|
||
`match_term` VARCHAR(128) DEFAULT NULL COMMENT '参赛届次',
|
||
`match_level` VARCHAR(64) DEFAULT NULL COMMENT '比赛级别',
|
||
`cover_image` VARCHAR(1024) DEFAULT NULL COMMENT '头像/封面图',
|
||
`detail_url` VARCHAR(1024) NOT NULL COMMENT '详情链接',
|
||
`source_url` VARCHAR(1024) DEFAULT NULL COMMENT '来源列表页',
|
||
`page_no` INT DEFAULT NULL COMMENT '来源页码',
|
||
`last_sync_time` DATETIME DEFAULT NULL COMMENT '最近同步时间',
|
||
`create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` TINYINT NOT NULL DEFAULT 0 COMMENT '删除标记：0未删 1已删',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `uk_gxmu_tzb_talent_source_id` (`source_id`),
|
||
KEY `idx_gxmu_tzb_talent_person_name` (`person_name`),
|
||
KEY `idx_gxmu_tzb_talent_school_name` (`school_name`(191))
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='挑战杯人才库列表';
|