Influencer OPS — システム設計図

flowchart TD A["📋 キャンペーン作成"] --> B["👤 インフルエンサー募集"] B --> C["📥 応募受付"] C --> D{"🔍 スクリーニング"} D -->|合格| E["✅ 採用通知"] D -->|不合格| F["❌ 不採用通知"] E --> G["📅 日程調整"] G --> H["🔒 予約確定"] H --> I["🔔 前日リマインド"] I --> J["🍽 来店"] J --> K{"📸 投稿確認"} K -->|投稿OK| L["🎉 お礼送信"] K -->|未投稿| M["⚡ 投稿催促"] M --> K L --> N["📊 クローズ"] style A fill:#ede9fe,stroke:#7c3aed,color:#1e293b style D fill:#fef3c7,stroke:#f59e0b,color:#1e293b style K fill:#fef3c7,stroke:#f59e0b,color:#1e293b style N fill:#dcfce7,stroke:#22c55e,color:#1e293b style F fill:#fee2e2,stroke:#ef4444,color:#1e293b

erDiagram clients ||--o{ stores : has stores ||--o{ campaigns : has campaigns ||--o{ assignments : has influencers ||--o{ assignments : has assignments ||--o{ posts : has clients { int id PK text name } stores { int id PK int client_id FK text name text regular_holidays text offered_menu text booking_url } influencers { int id PK text name text instagram_handle int instagram_followers text influencer_type text buzz_score } campaigns { int id PK int store_id FK text name text platform text status } assignments { int id PK int campaign_id FK int influencer_id FK text status text visit_date int pr_checked } posts { int id PK int assignment_id FK text post_url int has_pr_tag }