Foreign key constraints for satellite.DB up to version 73, ref: https://github.com/storj/storj/blob/master/satellite/satellitedb/migrate.go#L93

constraints_fk.sql

ALTER TABLE ONLY public.api_keys
    ADD CONSTRAINT api_keys_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;


ALTER TABLE ONLY public.bucket_metainfos
    ADD CONSTRAINT bucket_metainfos_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id);


ALTER TABLE ONLY public.stripecoinpayments_apply_balance_intents
    ADD CONSTRAINT fk_transactions FOREIGN KEY (tx_id) REFERENCES public.coinpayments_transactions(id) ON DELETE CASCADE;


ALTER TABLE ONLY public.project_invoice_stamps
    ADD CONSTRAINT project_invoice_stamps_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;


ALTER TABLE ONLY public.project_members
    ADD CONSTRAINT project_members_member_id_fkey FOREIGN KEY (member_id) REFERENCES public.users(id) ON DELETE CASCADE;


ALTER TABLE ONLY public.project_members
    ADD CONSTRAINT project_members_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;


ALTER TABLE ONLY public.used_serials
    ADD CONSTRAINT used_serials_serial_number_id_fkey FOREIGN KEY (serial_number_id) REFERENCES public.serial_numbers(id) ON DELETE CASCADE;


ALTER TABLE ONLY public.user_credits
    ADD CONSTRAINT user_credits_offer_id_fkey FOREIGN KEY (offer_id) REFERENCES public.offers(id);


ALTER TABLE ONLY public.user_credits
    ADD CONSTRAINT user_credits_referred_by_fkey FOREIGN KEY (referred_by) REFERENCES public.users(id) ON DELETE SET NULL;


ALTER TABLE ONLY public.user_credits
    ADD CONSTRAINT user_credits_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;