ER Diagram of Notification System

---

Below is the Entity-Relationship Diagram for the Notification and NotificationCategory models.

erDiagram
    NotificationCategory {
        int id PK
        string name
    }

    Notification {
        int id
        int vendor_id FK
        int category_id FK
        string message
        JSON context_data
        boolean is_read
        boolean is_recent_notification
        datetime readed_at
        datetime created_at
    }

    Vendor ||--o{ Notification : "receives"
    NotificationCategory ||--o{ Notification : "categorizes"
    Notification ||--o{ Vendor : "is associated with"