CREATE TABLE public.course_email_rules
(
    id integer NOT NULL DEFAULT nextval('course_email_rules_id_seq'::regclass),
    course_id integer NOT NULL,
    event_type character varying(50) NOT NULL,
    active boolean NOT NULL DEFAULT true,
    CONSTRAINT course_email_rules_course_id_fkey FOREIGN KEY (course_id) REFERENCES courses(course_id) ON DELETE CASCADE,
    CONSTRAINT course_email_rules_pkey PRIMARY KEY (id),
    CONSTRAINT uq_course_email_rule UNIQUE (course_id, event_type)
);