CREATE TABLE public.professor_profiles
(
    partner_id bigint NOT NULL,
    status text NOT NULL DEFAULT 'ACTIVE'::text,
    created_at timestamp without time zone DEFAULT now(),
    CONSTRAINT fk_professor_profiles_partners FOREIGN KEY (partner_id) REFERENCES partners(partner_id),
    CONSTRAINT pk_professor_profiles PRIMARY KEY (partner_id)
);