- BEGIN;
- ALTER TABLE "cpr" ADD COLUMN user_id UUID;
- ALTER TABLE "cpr" ADD CONSTRAINT fk_user
- FOREIGN KEY (user_id)
- REFERENCES "user"(user_id)
- ON DELETE RESTRICT;
- ALTER TABLE "cpr" ADD COLUMN company_id UUID;
- ALTER TABLE "cpr" ADD CONSTRAINT fk_company
- FOREIGN KEY (company_id)
- REFERENCES "company"(company_id)
- ON DELETE RESTRICT;
- COMMIT;
|