ER Diagram

erDiagram
    NEWSLETTERSUBSCRIBER {
        string email
    }

    SUBSCRIBEDNEWSLETTERTYPE {
        boolean is_subscribed
    }

    NEWSLETTER {
        string title
        text description
        string banner_image
        boolean is_active
        datetime start_at
        datetime end_at
    }

    PUBLISHNEWSLETTER {
        datetime email_sent_at
    }

    NEWSLETTERSUBSCRIBER ||--o| SUBSCRIBEDNEWSLETTERTYPE : subscribes_to
    NEWSLETTERTYPE ||--o| SUBSCRIBEDNEWSLETTERTYPE : is_for
    NEWSLETTERTYPE ||--o| NEWSLETTER : has_type
    NEWSLETTER ||--o| PUBLISHNEWSLETTER : publishes
    SUBSCRIBEDNEWSLETTERTYPE ||--o| PUBLISHNEWSLETTER : receives