CREATE TABLE public.session_notifications_log
(
    id integer NOT NULL DEFAULT nextval('session_notifications_log_id_seq'::regclass),
    session_id integer NOT NULL,
    participant_email text NOT NULL,
    event_type text NOT NULL,
    sent_at timestamp with time zone NOT NULL DEFAULT now(),
    CONSTRAINT session_notifications_log_session_id_fkey FOREIGN KEY (session_id) REFERENCES sessions(session_id) ON DELETE CASCADE,
    CONSTRAINT session_notifications_log_pkey PRIMARY KEY (id)
);