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='挑战杯人才库列表';
