Everynews Organizational Schema

erDiagram    %% Auth Core    users ||--o{ accounts : has    users ||--o{ sessions : maintains    users ||--o{ passkeys : has    users ||--o{ verifications : requests
    %% Organization Structure    organizations ||--o{ members : contains    organizations ||--o{ invitations : manages    users ||--o{ members : belongs_to    users ||--o{ invitations : creates
    %% News System    organizations ||--o{ news : owns    organizations ||--o{ channels : owns    organizations ||--o{ apikeys : configures    news ||--o{ schedules : has    news ||--o{ stories : tracks    news ||--o{ channels : uses
    users {        text id PK        string name        string email UK        boolean emailVerified        string image        string role        boolean banned        string banReason        timestamp banExpires        timestamp createdAt        timestamp updatedAt    }
    sessions {        text id PK        text userId FK        string token UK        timestamp expiresAt        text ipAddress        text userAgent        text impersonatedBy        text activeOrganizationId        timestamp createdAt        timestamp updatedAt    }
    accounts {        text id PK        text userId FK        string accountId        string providerId        text accessToken        text refreshToken        text idToken        timestamp tokenExpiresAt        text scope        text password        timestamp createdAt        timestamp updatedAt    }
    verifications {        text id PK        string identifier        string value        timestamp expiresAt        timestamp createdAt        timestamp updatedAt    }
    passkeys {        text id PK        text userId FK        string name        text publicKey        text credentialID        integer counter        string deviceType        boolean backedUp        string transports        timestamp createdAt    }
    organizations {        text id PK        string name        string slug UK        string logo        text metadata        timestamp createdAt    }
    members {        text id PK        text organizationId FK        text userId FK        string role        timestamp createdAt    }
    invitations {        text id PK        text organizationId FK        text inviterId FK        string email        string role        string status        timestamp expiresAt        timestamp createdAt    }
    apikeys {        text id PK        text organizationId FK        string name        string prefix        string key        integer refillInterval        integer refillAmount        boolean enabled        boolean rateLimitEnabled        integer rateLimitMax        integer requestCount        integer remaining        text permissions        text metadata        timestamp lastRequest        timestamp expiresAt        timestamp createdAt        timestamp updatedAt    }
    news {        text id PK        text organizationId FK        string name        json searchQuery        json relevanceSettings        json waitSettings        boolean isActive        timestamp lastRun        timestamp lastSent        timestamp nextRun        timestamp createdAt        timestamp updatedAt    }
    schedules {        text id PK        text newsId FK        string cronExpr        boolean isActive        timestamp lastSuccess        timestamp lastFailure        json errorDetails        timestamp createdAt        timestamp updatedAt    }
    stories {        text id PK        text newsId FK        string title        string url UK        text snippet        float relevanceScore        boolean wasDelivered        timestamp foundAt        timestamp createdAt    }
    channels {        text id PK        text organizationId FK        string type        json config        boolean isActive        timestamp createdAt        timestamp updatedAt    }