🤵 Alfred

flowchart LR
    P(["AI 提议的新技能"]) --> Q{"你怎么看"}
    Q -->|"确实是新技能"| A["approved
进共享词表"]
    Q -->|"跟已有的重复"| M["merged
并入已有技能
说法进 skill_alias"]
    Q -->|"这不算技能"| R["rejected
下次不再提"]
    Q -->|"先放着"| P
    A --> USE(["可用于筛选/匹配/统计"])
    M --> USE

stateDiagram-v2
    [*] --> draft
    draft --> submitted
    submitted --> ack_received
    submitted --> ghosted : 长期无回应
    ack_received --> oa_pending
    oa_pending --> oa_done
    ack_received --> interviewing
    oa_done --> interviewing
    interviewing --> offer
    interviewing --> rejected
    offer --> accepted
    offer --> declined
    ghosted --> interviewing : 突然回复

flowchart LR
    U(["你"])
    subgraph ALFRED["Alfred 系统"]
        direction TB
        A1["接收与存档"]
        A2["AI 拆解（路由→抽取→归一）"]
        A3["预览确认与入库"]
        A4["调用与生成"]
    end
    LLM(["AI 模型"])
    WEB(["外部网页 / 搜索"])
    DB[("数据库")]

    U -- "文字/语音/图片/链接" --> A1
    A1 -- "原始内容 + event 行为" --> DB
    A1 -- "归一化文本" --> A2
    A2 <-- "问答" --> LLM
    A2 -- "抓正文/查背景" --> WEB
    A2 -- "预览卡片" --> U
    U -- "改一改 + 确认" --> A3
    A3 -- "正式写入（fact 物化）" --> DB
    U -- "给这个岗改简历" --> A4
    DB -- "经历/技能/岗位要求" --> A4
    A4 -- "简历草稿" --> U

flowchart TB
    IN(["你发的内容"])
    N1["归一化
链接抓正文 / 截图OCR / 语音转写"]
    S1[("attachment
原件+转写")]
    S2[("ingest_request
原始输入")]
    S3[("chat_message
你说的这句")]
    R1["路由：这是什么类型"]
    E1["抽取：拆成结构化字段"]
    K1["技能归一：匹配共享词表 skill"]
    P1{"预览卡片
等你确认"}
    W1["写入实体（event + fact）"]
    S4[("organization / job_posting")]
    S5[("position_requirement")]
    S6[("skill 提议区")]
    S7[("experience / note / memory")]
    S8[("application / interaction")]
    S9[("chat_message
Alfred 的回复")]
    S10[("event 行为日志")]
    BG["背景搜集
只看不存"]

    IN --> N1
    IN --> S2
    IN --> S3
    N1 --> S1
    N1 --> R1
    R1 --> E1
    E1 --> K1
    K1 --> P1
    E1 --> BG
    BG -.->|"只展示"| P1
    P1 -->|"确认"| W1
    P1 -->|"丢弃"| X(["不入库"])
    W1 --> S4
    W1 --> S5
    W1 --> S6
    W1 --> S7
    W1 --> S8
    W1 --> S9
    W1 --> S10

flowchart LR
    Q(["给X机构Y岗改简历
用经历1/3/5"])
    D1[("position_requirement
这个岗要什么")]
    D2[("experience
我的经历素材")]
    D3[("user_skill
我会什么")]
    M["缺口比对
要求 vs 我的技能"]
    G["Markdown 生成 + 套模板"]
    P{"你确认"}
    V[("document_version
Markdown + checksum")]
    L[("document_version_experience
用了哪几条经历")]
    F[("document_version_fact
bullet 溯源 fact")]
    PDF[("PDF 文件")]

    Q --> M
    D1 --> M
    D2 --> M
    D3 --> M
    M -->|"提示缺口"| Q
    M --> G
    G --> P
    P -->|"再改改"| G
    P -->|"定稿"| V
    V --> L
    V --> F
    V --> PDF

flowchart TD
    START(["你发了链接/截图/语音"]) --> SAVE["立即存档原件
此刻起内容不会丢"]
    SAVE --> NORM["归一成纯文本"]
    NORM --> OK1{"文本拿到了吗"}
    OK1 -->|"否"| FAIL1["标记 partial
告诉你抓取失败
可手动补内容"]
    OK1 -->|"是"| ROUTE["判断类型"]
    ROUTE --> ISJOB{"是岗位信息吗"}
    ISJOB -->|"否"| OTHER["走别的技能
笔记 / 经历 / 接触 / 记忆"]
    ISJOB -->|"是"| EXTRACT["AI 拆解字段"]
    EXTRACT --> CO{"识别到机构了吗"}
    CO -->|"否"| PLACE["建占位机构
标记待补"]
    CO -->|"是"| MATCH["按 slug + 别名匹配已有 organization"]
    PLACE --> FP
    MATCH --> FP["算岗位指纹"]
    FP --> DUP{"这个岗已经存过了吗"}
    DUP -->|"是"| MERGE["复用已有岗位
追加新来源"]
    DUP -->|"否"| NEW["准备新建岗位"]
    MERGE --> SK
    NEW --> SK["技能归一与匹配"]
    SK --> SKHIT{"技能库里有吗"}
    SKHIT -->|"有"| REUSE["直接复用"]
    SKHIT -->|"没有"| PROPOSE["建成待确认技能"]
    REUSE --> CARD
    PROPOSE --> CARD["生成预览卡片"]
    CARD --> BG["顺手搜背景信息
只展示不入库"]
    BG --> REVIEW{"你看一眼"}
    REVIEW -->|"改字段"| CARD
    REVIEW -->|"丢弃"| DROP(["不入库
原始内容仍留档"])
    REVIEW -->|"确认"| WRITE["写入数据库（event + fact）"]
    WRITE --> REM{"有截止日期吗"}
    REM -->|"有"| MKREM["自动建提前提醒 nudge/reminder"]
    REM -->|"没有"| REPLY
    MKREM --> REPLY["Alfred 回话
写进聊天时间线"]
    REPLY --> END(["完成"])

flowchart TD
    S(["给某机构某岗改简历"]) --> PICK{"指定用哪几条经历了吗"}
    PICK -->|"指定了"| GET["取出指定经历"]
    PICK -->|"没指定"| REC["按岗位要求自动推荐经历"]
    REC --> CONFIRM1{"这几条行吗"}
    CONFIRM1 -->|"换一批"| REC
    CONFIRM1 -->|"可以"| GET
    GET --> GAP["比对岗位要求
找出没覆盖到的能力"]
    GAP --> WARN{"有明显缺口吗"}
    WARN -->|"有"| TELL["提示你
要求SPSS但选的经历没体现"]
    WARN -->|"没有"| GEN
    TELL --> GEN["生成 Markdown 草稿 + 套模板"]
    GEN --> LOOK{"你看草稿"}
    LOOK -->|"改措辞/换经历"| GEN
    LOOK -->|"定稿"| SAVEV["存新版本
记录用了哪几条经历"]
    SAVEV --> CK{"checksum 和历史版一样吗"}
    CK -->|"一样"| REUSEV["复用已有版本"]
    CK -->|"不一样"| PDF["编译 PDF"]
    PDF --> FACT["bullet 软引用 fact 建索引"]
    FACT --> DONE(["可用于投递"])

flowchart LR
    A(["发现岗位"]) --> B(["解析入库"])
    B --> C(["写评价与准备思路"])
    C --> D(["生成定制简历"])
    D --> E(["投递 + 凭证 evidence"])
    E --> F(["跟踪状态"])
    F --> G(["面试记录"])
    G --> H(["复盘写进记忆"])
    H -.->|"经验反哺"| C
    G -.->|"新技能被问到"| I(["补进技能词表"])
    I -.-> D

erDiagram
    CHAT_THREAD ||--o{ CHAT_SEGMENT : "分段"
    CHAT_THREAD ||--o{ CHAT_MESSAGE : "含"
    CHAT_MESSAGE ||--o{ ATTACHMENT : "含(方向化)"
    CHAT_MESSAGE ||--o{ EVENT : "触发行为"
    EVENT ||--o| FACT : "物化为状态"

    CHAT_THREAD {
        string id PK
        string user_id FK "私有"
        string title
        string status "active archived"
    }
    CHAT_SEGMENT {
        string id PK
        string thread_id FK
        string title
        string status "active archived merged"
        text summary_md
        string user_id FK
    }
    CHAT_MESSAGE {
        string id PK
        string thread_id FK
        string segment_id FK
        timestamp sent_at "时间戳"
        string role "user 或 assistant"
        string media_kind "text voice image link"
        text content_md "显示文本"
        json attachment_ids
        string reply_to_id FK
        string status "sent processing done failed"
        bool discarded "软丢弃"
    }
    ATTACHMENT {
        string id PK
        string media_kind
        string sha256 UK "同文件不重复存"
        string storage_uri
        text transcription "语音转写"
        text vision_caption "图片描述"
    }
    EVENT {
        string id PK
        string type "FACT_DECLARED APPLICATION_SUBMITTED INTERACTION_HAPPENED SKILL_EXTRACTED INTERVIEW_SCHEDULED RESUME_GENERATED CUSTOM"
        string actor_user_id FK "私有"
        timestamp occurred_at
        string source_type "conversation import api"
        string source_ref_id
        json payload
    }
    FACT {
        string id PK
        string kind "skill_declaration relationship attribute custom"
        timestamp valid_from
        timestamp valid_to NULL "纠错时封口"
        string subject_ref FK
        string object_ref FK
        string proficiency NULL
        string source_event_id FK "双向追溯"
        string owner_user_id FK "私有"
    }

erDiagram
    ORGANIZATION ||--o{ JOB_POSTING : "发布"
    OCCUPATION ||--o{ JOB_POSTING : "属于"
    LOCATION ||--o{ JOB_POSTING : "位于"
    LOCATION ||--o{ LOCATION_ALIAS : "别名"
    SKILL ||--o{ SKILL_ALIAS : "别名"
    OCCUPATION }o--o{ USER_SKILL : "跨用户可比"
    SKILL ||--o{ USER_SKILL : "技能定义"
    SKILL ||--o{ POSITION_REQUIREMENT : "JD所需"
    JOB_POSTING ||--o{ POSITION_REQUIREMENT : "要求"

    ORGANIZATION {
        string id PK
        string name
        string slug UK "唯一标识"
        string kind "company school club ngo government fund open_source_office other"
        json aliases "别名用于去重"
    }
    OCCUPATION {
        string id PK
        string slug UK
        string name "software-engineer 等"
    }
    LOCATION {
        string id PK
        string country
        string city
        string district
        string admin_code
    }
    LOCATION_ALIAS {
        string id PK
        string location_id FK
        string alias_slug "香港 HK HongKong → 同行"
    }
    SKILL {
        string id PK
        string slug UK "excel"
        string name "显示名"
        string kind "hard soft language tool domain"
        string status "proposed approved merged rejected"
        string merged_into_id FK
    }
    SKILL_ALIAS {
        string id PK
        string canonical_skill_id FK
        string alias_slug "反查合并键"
        string source "agent manual"
    }
    POSITION_REQUIREMENT {
        string id PK
        string position_id FK
        string kind "skill qualification experience"
        string skill_id FK "仅能力类才有"
        text text "要求原文(可溯源 JD)"
        string importance "must nice"
        json source_sentences
    }
    USER_SKILL {
        string id PK
        string user_id FK "私有"
        string skill_id FK
        int proficiency "1到5"
    }
    JOB_POSTING {
        string id PK
        string organization_id FK
        string fingerprint UK "去重指纹"
        string occupation_id FK "职位大类"
        string location_id FK "替代 location 字符串"
        string title "细分职位名"
        timestamp posted_at
        timestamp deadline_at "投递截止→驱动提醒"
        string apply_url
        json required_documents "要交的材料"
        string source_kind
        int interest_level
        text personal_comment_md
    }

erDiagram
    EXPERIENCE ||--o{ EXPERIENCE_SOURCE : "来源"
    EXPERIENCE ||--o{ DOCUMENT_VERSION_EXPERIENCE : "被引用"
    DOCUMENT_ASSET ||--o{ DOCUMENT_VERSION : "版本链"
    DOCUMENT_VERSION ||--o{ DOCUMENT_VERSION_EXPERIENCE : "用了哪几条"
    DOCUMENT_VERSION ||--o{ DOCUMENT_VERSION_FACT : "溯源fact"
    FACT ||--o{ DOCUMENT_VERSION_FACT : "被引用"
    JOB_POSTING ||--o{ APPLICATION : "投递"
    APPLICATION ||--o{ INTERVIEW : "轮次"
    APPLICATION ||--o{ APPLICATION_EVIDENCE : "凭证"
    ATTACHMENT ||--o{ APPLICATION_EVIDENCE : "截图/确认邮件"
    PERSON ||--o{ INTERVIEW_INTERVIEWER : "面试官"
    INTERVIEW ||--o{ INTERVIEW_INTERVIEWER : ""
    PERSON ||--o{ INTERACTION_PERSON : "参与"
    INTERACTION ||--o{ INTERACTION_PERSON : "多人"

    EXPERIENCE {
        string id PK
        string user_id FK "私有"
        string slug UK
        string title
        string kind "internship project research award"
        string org_name
        date started_on
        date ended_on
        text raw_input_md "仅存口语稿，不存优化稿"
    }
    EXPERIENCE_SOURCE {
        string id PK
        string experience_id FK
        string source_type "voice text screenshot"
        string source_ref_id "指向 attachment / chat_message"
    }
    DOCUMENT_ASSET {
        string id PK
        string slug UK
        string kind "resume 或 cover_letter"
        string name
        string base_template "模板引用"
    }
    DOCUMENT_VERSION {
        string id PK
        string asset_id FK
        int version_no
        string checksum "内容没变就不新建"
        text markdown_main "结构化Markdown主信息"
        string template_ref "套用模板"
        string based_on_id FK "用户显式选父版"
        text change_summary_md "这版改了什么"
        string compiled_pdf_url
    }
    DOCUMENT_VERSION_EXPERIENCE {
        string document_version_id FK
        string experience_id FK
        int order_no
        json rendered_bullets "实际措辞(按岗不同)"
    }
    DOCUMENT_VERSION_FACT {
        string id PK
        string document_version_id FK
        string fact_id FK
        text bullet_text "软引用 fact，支撑 footnote"
    }
    APPLICATION {
        string id PK
        string user_id FK
        string job_posting_id FK
        string status "投递状态机"
        string resume_version_id FK
        string cover_letter_version_id FK
        timestamp submitted_at
        text submission_detail_md
        string referrer_person_id FK
    }
    APPLICATION_EVIDENCE {
        string id PK
        string application_id FK
        string attachment_id FK
        string role "screenshot confirmation_email"
    }
    INTERVIEW {
        string id PK
        string application_id FK
        int round_no
        string kind
        timestamp scheduled_at
        json questions "问了什么我怎么答"
        text feedback_md
    }
    INTERACTION {
        string id PK
        string user_id FK
        string kind "coffee_chat meal hangout call networking_event info_session referral_talk"
        timestamp occurred_at
        text summary_md
    }