CREATE TABLE public.student_profiles
(
    partner_id bigint NOT NULL,
    remarks character varying(500),
    level_id integer,
    tutor_id bigint,
    status enrollment_status DEFAULT 'active'::text,
    updated_at valid_timestamp DEFAULT now(),
    course_id integer NOT NULL,
    CONSTRAINT student_profiles_course_id_fkey FOREIGN KEY (course_id) REFERENCES courses(course_id),
    CONSTRAINT student_profiles_partner_id_fkey FOREIGN KEY (partner_id) REFERENCES partners(partner_id),
    CONSTRAINT student_profiles_tutor_id_fkey FOREIGN KEY (tutor_id) REFERENCES tutor_profiles(partner_id),
    CONSTRAINT student_profiles_pkey PRIMARY KEY (partner_id, course_id)
);