SignalKite DB Schema

erDiagram
    User ||--o{ Kite : "creates"
    User ||--o{ Schedule : "owns"
    User ||--o{ NotificationChannel : "owns"
    User ||--o{ Subscription : "subscribes"
    User ||--o{ Prompt : "creates"

    Kite ||--o{ Scout : "has"
    Kite ||--o{ Story : "contains"
    Kite }|--|{ Schedule : "runs_on"
    Kite ||--o{ Subscription : "has"
    Kite }o--o{ Prompt : "uses"

    Schedule ||--o{ Run : "triggers"
    Schedule ||--o{ ScheduleKite : "has"

    Scout ||--o{ Story : "discovers"
    Scout }o--|| Run : "part_of"

    Story }o--o{ Prompt : "uses"

    NotificationChannel ||--o{ Subscription : "used_by"

    ScheduleKite }o--|| Kite : "links"
    ScheduleKite }o--|| Schedule : "links"

    User {
        string id PK
        string kindeId
        datetime createdAt
        datetime updatedAt
        datetime deletedAt
        datetime lastLogin
    }

    Kite {
        string id PK
        string name
        string description
        enum strategy
        enum status
        datetime createdAt
        datetime updatedAt
        datetime deletedAt
        string creatorId FK
        string promptId FK
    }

    Schedule {
        string id PK
        string name
        string cron
        datetime nextRunAt
        datetime lastRunAt
        boolean paused
        string ownerId FK
        datetime createdAt
        datetime updatedAt
        datetime deletedAt
    }

    Scout {
        string id PK
        string kiteId FK
        string runId FK
        boolean successful
        datetime createdAt
        datetime updatedAt
        datetime deletedAt
    }

    Story {
        string id PK
        string title
        string url
        string summary
        datetime createdAt
        datetime updatedAt
        datetime deletedAt
        string promptId FK
        string scoutId FK
        string kiteId FK
    }

    NotificationChannel {
        string id PK
        string name
        enum type
        json settings
        datetime createdAt
        datetime updatedAt
        datetime deletedAt
        string userId FK
    }

    Subscription {
        string id PK
        string userId FK
        string kiteId FK
        string notificationChannelId FK
        datetime createdAt
        datetime updatedAt
    }

    Prompt {
        string id PK
        string description
        string text
        datetime createdAt
        datetime updatedAt
        datetime deletedAt
        string creatorId FK
    }

    Run {
        string id PK
        string scheduleId FK
        datetime startedAt
        datetime completedAt
    }

    ScheduleKite {
        string id PK
        string scheduleId FK
        string kiteId FK
    }