CREATE TABLE IF NOT EXISTS `gxmu_cross_school_activity_article` (
    `id` INT NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `source_key` VARCHAR(64) NOT NULL COMMENT '来源唯一键',
    `title` VARCHAR(512) NOT NULL COMMENT '文章标题',
    `school_name` VARCHAR(128) NOT NULL COMMENT '高校名称',
    `category` VARCHAR(64) DEFAULT NULL COMMENT '活动类型',
    `heat_level` VARCHAR(32) DEFAULT NULL COMMENT '热度等级',
    `source_name` VARCHAR(128) DEFAULT NULL COMMENT '来源名称',
    `publish_time` DATETIME DEFAULT NULL COMMENT '发布时间',
    `summary` VARCHAR(1024) DEFAULT NULL COMMENT '摘要',
    `tags` VARCHAR(512) DEFAULT NULL COMMENT '标签JSON',
    `cover_image` VARCHAR(1024) DEFAULT NULL COMMENT '封面图',
    `detail_url` VARCHAR(1024) NOT NULL COMMENT '详情链接',
    `source_url` VARCHAR(1024) DEFAULT NULL COMMENT '来源列表页',
    `highlight` VARCHAR(255) DEFAULT NULL COMMENT '可借鉴动作',
    `content_text` TEXT 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_cross_school_activity_source_key` (`source_key`),
    KEY `idx_gxmu_cross_school_activity_publish_time` (`publish_time`),
    KEY `idx_gxmu_cross_school_activity_school_name` (`school_name`),
    KEY `idx_gxmu_cross_school_activity_category` (`category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='跨校活动情报文章';