erDiagram
    users {
        int8 id PK
        varchar name
        varchar email UK
        timestamp email_verified_at
        varchar password
        varchar remember_token
        text fever_api_key
        timestamp created_at
        timestamp updated_at
    }

    feeds {
        int8 id PK
        varchar name
        varchar feed_url UK
        varchar site_url
        varchar favicon_url
        boolean favicon_is_dark
        timestamp favicon_updated_at
        timestamp last_successful_refresh_at
        timestamp last_failed_refresh_at
        varchar last_error_message
        timestamp created_at
        timestamp updated_at
    }

    entries {
        int8 id PK
        varchar title
        varchar url
        varchar author
        text content
        timestamp published_at
        int8 feed_id FK
        timestamp created_at
        timestamp updated_at
    }

    feed_refreshes {
        int8 id PK
        int8 feed_id FK
        timestamp refreshed_at
        boolean was_successful
        int4 entries_created
        text error_message
        timestamp created_at
        timestamp updated_at
    }

    feed_subscriptions {
        int8 user_id PK,FK
        int8 feed_id PK,FK
        int8 category_id FK
        varchar custom_feed_name
        json filter_rules
        timestamp created_at
        timestamp updated_at
    }

    subscription_categories {
        int8 id PK
        int8 user_id FK
        varchar name
        timestamp created_at
        timestamp updated_at
    }

    entry_interactions {
        int8 user_id PK,FK
        int8 entry_id PK,FK
        timestamp read_at
        timestamp starred_at
        timestamp archived_at
        timestamp filtered_at
        timestamp created_at
        timestamp updated_at
    }

    users ||--o{ feed_subscriptions : "subscribes"
    users ||--o{ entry_interactions : "interacts"
    users ||--o{ subscription_categories : "has"
    feeds ||--o{ entries : "contains"
    feeds ||--o{ feed_subscriptions : "has"
    feeds ||--o{ feed_refreshes : "refreshes"
    entries ||--o{ entry_interactions : "has"
    subscription_categories ||--o{ feed_subscriptions : "organizes"