Open morrillo opened 11 years ago
Los foreign keys estan apuntando a las tablas equivocadas:
Foreign-key constraints: "sgr_study_purpose_proposal_id_fkey" FOREIGN KEY (proposal_id) REFERENCES sgr_proposal(id) ON DELETE SET NULL Referenced by: TABLE "sgr_study_ids_study_purpose_ids_rel" CONSTRAINT "sgr_study_ids_study_purpose_ids_rel_study_ids_fkey" FOREIGN KEY (study_id) REFERENCES sgr_study_purpose(id) ON DELETE CASCADE TABLE "sgr_study" CONSTRAINT "sgr_study_study_purpose_id_fkey" FOREIGN KEY (study_purpose_id) REFERENCES sgr_study_purpose(id) ON DELETE SET NULL
Los foreign keys estan apuntando a las tablas equivocadas:
Foreign-key constraints: "sgr_study_purpose_proposal_id_fkey" FOREIGN KEY (proposal_id) REFERENCES sgr_proposal(id) ON DELETE SET NULL Referenced by: TABLE "sgr_study_ids_study_purpose_ids_rel" CONSTRAINT "sgr_study_ids_study_purpose_ids_rel_study_ids_fkey" FOREIGN KEY (study_id) REFERENCES sgr_study_purpose(id) ON DELETE CASCADE TABLE "sgr_study" CONSTRAINT "sgr_study_study_purpose_id_fkey" FOREIGN KEY (study_purpose_id) REFERENCES sgr_study_purpose(id) ON DELETE SET NULL