erDiagram
    CLINICS ||--o{ PROCEDURES : "提供する"
    CLINICS ||--o{ REVIEWS : "受ける"
    CLINICS ||--o{ WAIT_ENVIRONMENTS : "持つ"
    PROCEDURES ||--o{ REVIEWS : "対象"
    AUTHORS ||--o{ REVIEWS : "書く"
    AUTHORS ||--o{ HASHIGO_SESSIONS : "計画する"
    HASHIGO_SESSIONS ||--o{ REVIEWS : "含む"
    REVIEWS ||--o| RECEIPTS : "持つ"
    REVIEWS ||--o{ LABELING_RECORDS : "判定される"
    CURATORS ||--o{ LABELING_RECORDS : "作成する"
    REVIEWS }o--|| WAIT_ENVIRONMENTS : "体験"

    CLINICS {
        uuid id PK
        text name_ja
        text name_ko
        text neighborhood
        text japanese_support
    }
    REVIEWS {
        uuid id PK
        uuid clinic_id FK
        uuid author_id FK
        uuid wait_environment_id "v1.3 NEW"
        uuid hashigo_session_id "v1.3 NEW"
        timestamptz visited_at "v1.3 NEW"
        int grade
        jsonb items_jsonb
        int filled_count "0-11"
    }
    WAIT_ENVIRONMENTS {
        uuid id PK
        uuid clinic_id FK
        text quality_level "L1|L2|L3"
        text description
    }
    HASHIGO_SESSIONS {
        uuid id PK
        uuid author_id FK
        date session_date
        int planned_clinic_count
        jsonb clinic_visits
        text outcome
    }
        

flowchart TD
    Start([レビュアー登録]) --> W1[11 項目入力]
    W1 --> W2{3 行以上?}
    W2 -->|No| Reject[登録拒絶]
    W2 -->|Yes| W3[取引証明 + 待機場所質選択]
    W3 --> AI1[P1-2: 11 項目抽出]
    AI1 --> AI2[P1-1: 真偽判定 5 段階]
    AI2 --> Grade{Grade}
    Grade -->|⭐⭐⭐⭐⭐| Pub[即時公開]
    Grade -->|⭐⭐⭐⭐| Pub
    Grade -->|⭐⭐⭐| CR[キュレーターキュー]
    Grade -->|⭐⭐| CR
    Grade -->|⭐| Hide[非表示 + キュレーター確認]
    CR --> Final{一致率 ≥ 80%?}
    Final -->|Yes| Pub
    Final -->|No| Cur3[第 3 キュレーター]
    Cur3 --> Pub
    Pub --> End([公開完了])

    style Start fill:#7FCFB1,color:#fff
    style End fill:#3D8B72,color:#fff
    style Reject fill:#FCEFED,color:#C44536
    style Hide fill:#FCEFED,color:#C44536