# TT-Mobile 2.0

sequenceDiagram
    Participant C as Client
    Participant G as PostGraphile
    Participant P as Postgres
    Participant S as Scraper
    Participant Click as Click-TT
    C->>G: query
    par get local data
        G->>P: query
        P->>G: local data
        G->>C: data from DB
    and get fresh data from Click-TT
        G->>S: trigger
        S->>Click: scrape
        Click->>S: fresh data
        S->>P: Save
        P->>G: Trigger update
        G->>C: Trigger update (subscription)
    end

erDiagram
    CLUB ||--o{ PLAYER : "has members"
    ASSOCIATION ||--o{ LEAGUE : "consists of"
    LEAGUE ||--o{ TEAM : "consists of"
    CLUB ||--o{ TEAM : has
    TEAM }o..o{ PLAYER : "in starting team"
    GAME ||--|{ TEAM : "involves usually 2"
    GAME ||--|{ MATCH : "consists of"
    MATCH ||--|{ PLAYER : "involves 2 (single) or 4 (double)"

Examples:
- ASSOCIATION: MTTV 23/24
- LEAGUE: 2. Liga Herren Gruppe 1
- TEAM: Royal Bern 1. Herren
- CLUB: Royal Bern
- MATCH: Aarberg II - Royal Bern
- GAME: Max Muster vs. Bea Beispiel
- PLAYER: Max Muster