CREATE TABLE public.guests
(
    email valid_email NOT NULL,
    name character varying NOT NULL,
    surname character varying,
    phone intl_phone,
    country iso_country,
    zinzino_range character varying,
    tutor_id bigint NOT NULL,
    reg_date valid_timestamp DEFAULT now(),
    course_id integer,
    CONSTRAINT guests_course_id_fkey FOREIGN KEY (course_id) REFERENCES courses(course_id),
    CONSTRAINT guests_tutor_id_fkey FOREIGN KEY (tutor_id) REFERENCES partners(partner_id),
    CONSTRAINT guests_pkey PRIMARY KEY (email)
);