%%{init: {'theme': 'neutral'}}%%
graph TD
    Org["Organisation<br/><i>e.g. City Sports Club Inc.</i>"]
    V1["Vendor Account<br/><i>e.g. John Smith (coach)</i>"]
    V2["Vendor Account<br/><i>e.g. Sarah Lee (manager)</i>"]
    A1["Activity<br/><i>After School Soccer</i>"]
    A2["Activity<br/><i>Weekend Art Workshop</i>"]
    S1["Session<br/><i>Term 1 Mon/Wed 3–5pm</i>"]
    S2["Session<br/><i>Term 1 Sat 9–11am</i>"]
    S3["Session<br/><i>Sunday 10am–12pm</i>"]

    Org -->|"has members"| V1
    Org -->|"has members"| V2
    V1 -->|"creates"| A1
    V2 -->|"creates"| A2
    A1 -->|"has sessions"| S1
    A1 -->|"has sessions"| S2
    A2 -->|"has sessions"| S3

    style Org fill:#e0e7ff,stroke:#4f46e5,color:#000
    style V1 fill:#fef3c7,stroke:#d97706,color:#000
    style V2 fill:#fef3c7,stroke:#d97706,color:#000
    style A1 fill:#d1fae5,stroke:#059669,color:#000
    style A2 fill:#d1fae5,stroke:#059669,color:#000
    style S1 fill:#fce7f3,stroke:#db2777,color:#000
    style S2 fill:#fce7f3,stroke:#db2777,color:#000
    style S3 fill:#fce7f3,stroke:#db2777,color:#000

%%{init: {'theme': 'neutral'}}%%
flowchart LR
    A["Source<br/>(Google Maps,<br/>council sites,<br/>directories)"] -->|"HTTP Request<br/>node"| B["Scrape<br/>Raw Data"]
    B -->|"Function<br/>node"| C["Normalize<br/>(name, category,<br/>address, contact)"]
    C -->|"Supabase<br/>node"| D["Insert to<br/>vendor_signups<br/>table"]
    D -->|"Manual review"| E["Approve &<br/>Create Vendor<br/>Account"]