# Constraints

### 112 Foreign Key Constraints

Constraint Name | Child Column | Parent Column | Delete Rule
--- | --- | --- | ---
fk_candidat_opi_pj_id_candidat |
pj_opi.id_candidat
candidat.id_candidat
| Restrict delete
fk_formation_i18n_id_i18n_info_comp_form |
formation.id_i18n_info_comp_form
i18n.id_i18n
| Restrict delete
fk_formation_type_decision_id_typ_dec_fav_list_comp |
formation.id_typ_dec_fav_list_comp
type_decision.id_typ_dec
| Restrict delete
fk_formation_type_decision_id_typ_dec_fav_form |
formation.id_typ_dec_fav
type_decision.id_typ_dec
| Restrict delete
fk_formation_commission_id_comm |
formation.id_comm
commission.id_comm
| Restrict delete
fk_formation_siscol_centre_gestion_cod_cge |
formation.cod_cge
siscol_centre_gestion.cod_cge
| Restrict delete
fk_formation_siscol_typ_diplome_cod_tpd_etb |
formation.cod_tpd_etb
siscol_typ_diplome.cod_tpd_etb
| Restrict delete
fk_formation_type_traitement_cod_typ_trait |
formation.cod_typ_trait
type_traitement.cod_typ_trait
| Restrict delete
fk_type_decision_type_avis_cod_typ_avis |
type_decision.cod_typ_avis
type_avis.cod_typ_avis
| Restrict delete
fk_type_decision_centre_candidature_id_ctr_cand |
type_decision.id_ctr_cand
centre_candidature.id_ctr_cand
| Restrict delete
fk_type_decision_mail_id_mail |
type_decision.id_mail
mail.id_mail
| Restrict delete
fk_type_decision_i18n_id_i18n_lib_typ_dec |
type_decision.id_i18n_lib_typ_dec
i18n.id_i18n
| Restrict delete
fk_siscol_centre_gestion_utilisateur_cod_cge |
siscol_utilisateur.cod_cge
siscol_centre_gestion.cod_cge
| Restrict delete
fk_siscol_mention_cursus_interne_cod_men |
candidat_cursus_interne.cod_men_cursus_interne
siscol_mention.cod_men
| Restrict delete
fk_candidat_cursus_interne_candidat_id_candidat |
candidat_cursus_interne.id_candidat
candidat.id_candidat
| Restrict delete
fk_siscol_typ_resultat_candidat_cursus_interne_cod_tre |
candidat_cursus_interne.cod_tre_cursus_interne
siscol_typ_resultat.cod_tre
| Restrict delete
fk_cand_opi_id_cand |
opi.id_cand
candidature.id_cand
| Restrict delete
fk_tag_candidature_tag_id_tag |
tag_candidature.id_tag
tag.id_tag
| Restrict delete
fk_tag_candidature_candidature_id_cand |
tag_candidature.id_cand
candidature.id_cand
| Restrict delete
fk_campagne_i18n_id_i18n_id_i18n_libelle_campagne |
campagne.id_i18n_libelle_campagne
i18n.id_i18n
| Restrict delete
campagne_id_camp_id_camp |
campagne.archiv_id_camp
campagne.id_camp
| Restrict delete
fk_motivation_avis_centre_candidature_id_ctr_cand |
motivation_avis.id_ctr_cand
centre_candidature.id_ctr_cand
| Restrict delete
fk_motivation_avis_i18n_id_i18n_lib_motiv |
motivation_avis.id_i18n_lib_motiv
i18n.id_i18n
| Restrict delete
fk_mail_i18n_id_i18n_corps_mail |
mail.id_i18n_corps_mail
i18n.id_i18n
| Restrict delete
fk_mail_type_avis_cod_typ_avis |
mail.cod_typ_avis
type_avis.cod_typ_avis
| Restrict delete
fk_mail_centre_candidature_id_ctr_cand |
mail.id_ctr_cand
centre_candidature.id_ctr_cand
| Restrict delete
fk_mail_i18n_id_i18n_sujet_mail |
mail.id_i18n_sujet_mail
i18n.id_i18n
| Restrict delete
fk_droit_profil_fonc_droit_fonctionnalite_cod_fonc |
droit_profil_fonc.cod_fonc
droit_fonctionnalite.cod_fonc
| Restrict delete
fk_droit_profil_fonc_droit_profil_id_profil |
droit_profil_fonc.id_profil
droit_profil.id_profil
| Restrict delete
fk_cursus_pro_candidat_id_candidat |
candidat_cursus_pro.id_candidat
candidat.id_candidat
| Restrict delete
fk_typ_dec_cand_motivation_avis_id_motiv |
type_decision_candidature.id_motiv
motivation_avis.id_motiv
| Restrict delete
fk_typ_dec_cand_candidature_id_cand |
type_decision_candidature.id_cand
candidature.id_cand
| Restrict delete
fk_typ_dec_cand_typ_dec_id_typ_dec |
type_decision_candidature.id_typ_dec
type_decision.id_typ_dec
| Restrict delete
commission_gestionnaire_commission_id_comm |
gestionnaire_commission.id_comm
commission.id_comm
| Restrict delete
gestionnaire_gestionnaire_commission_id_droit_profil_ind |
gestionnaire_commission.id_droit_profil_ind
gestionnaire.id_droit_profil_ind
| Restrict delete
fk_bac_ou_equ_siscol_departement_cod_dep |
candidat_bac_ou_equ.cod_dep
siscol_departement.cod_dep
| Restrict delete
fk_bac_ou_equ_siscol_commune_cod_com |
candidat_bac_ou_equ.cod_com
siscol_commune.cod_com
| Restrict delete
fk_bac_ou_equ_siscol_pays_cod_pay |
candidat_bac_ou_equ.cod_pay
siscol_pays.cod_pay
| Restrict delete
fk_bac_ou_equ_siscol_mention_niv_bac_cod_mnb |
candidat_bac_ou_equ.cod_mnb
siscol_mention_niv_bac.cod_mnb
| Restrict delete
fk_bac_ou_equ_candidat_id_candidat |
candidat_bac_ou_equ.id_candidat
candidat.id_candidat
| Restrict delete
fk_bac_ou_equ_siscol_etablissement_cod_etb |
candidat_bac_ou_equ.cod_etb
siscol_etablissement.cod_etb
| Restrict delete
fk_bac_ou_equ_siscol_bac_ou_equ_cod_bac |
candidat_bac_ou_equ.cod_bac
siscol_bac_oux_equ.cod_bac
| Restrict delete
fk_cand_pj_form_cand_pk |
pj_cand.id_cand
candidature.id_cand
| Restrict delete
fk_pj_cand_pj_id_pj |
pj_cand.id_pj
piece_justif.id_pj
| Restrict delete
fk_pj_cand_type_statut_piece_cod |
pj_cand.cod_typ_statut_piece
type_statut_piece.cod_typ_statut_piece
| Restrict delete
fk_fichier_pj_cand_id_fichier |
pj_cand.id_fichier
fichier.id_fichier
| Restrict delete
fk_adresse_siscol_pays_cod_pay |
adresse.cod_pay
siscol_pays.cod_pay
| Restrict delete
fk_adresse_siscol_commune_cod_com |
adresse.cod_com
siscol_commune.cod_com
| Restrict delete
fk_traduction_i18n_id_i18n |
i18n_traduction.id_i18n
i18n.id_i18n
| Restrict delete
fk_traduction_langue_id_langue |
i18n_traduction.cod_langue
langue.cod_langue
| Restrict delete
fk_formulaire_form_formation_id_form |
formulaire_form.id_form
formation.id_form
| Restrict delete
fk_formulaire_formation_pj_id_pj |
formulaire_form.id_formulaire
formulaire.id_formulaire
| Restrict delete
fk_siscol_departement_commune_cod_dep |
siscol_commune.cod_dep
siscol_departement.cod_dep
| Restrict delete
fk_fichier_piece_justif_id_fichier |
piece_justif.id_fichier
fichier.id_fichier
| Restrict delete
fk_piece_justif_ctr_cand_id_ctr_cand |
piece_justif.id_ctr_cand
centre_candidature.id_ctr_cand
| Restrict delete
fk_piece_justif_type_traitement_cod_typ_trait |
piece_justif.cod_typ_trait
type_traitement.cod_typ_trait
| Restrict delete
fk_piece_justif_i18n_id_i18n_lib_pj |
piece_justif.id_i18n_lib_pj
i18n.id_i18n
| Restrict delete
fk_candidat_pj_candidat_id_candidat |
pj_candidat.id_candidat
candidat.id_candidat
| Restrict delete
fk_type_traduction_cod_typ_trad |
i18n.cod_typ_trad
type_traduction.cod_typ_trad
| Restrict delete
fk_siscol_departement_etab_cod_dep |
siscol_etablissement.cod_dep
siscol_departement.cod_dep
| Restrict delete
fk_siscol_commune_siscol_etab_cod_com |
siscol_etablissement.cod_com
siscol_commune.cod_com
| Restrict delete
fk_centre_candidature_typ_decision_id_typ_dec_fav |
centre_candidature.id_typ_dec_fav
type_decision.id_typ_dec
| Restrict delete
fk_centre_candidature_typ_decision_id_typ_dec_fav_list_comp |
centre_candidature.id_typ_dec_fav_list_comp
type_decision.id_typ_dec
| Restrict delete
fk_droit_profil_ind_commission_membre_id_droit_profil_ind |
commission_membre.id_droit_profil_ind
droit_profil_ind.id_droit_profil_ind
| Restrict delete
fk_commission_membre_commission_id_comm |
commission_membre.id_comm
commission.id_comm
| Restrict delete
fk_candidature_post_it_id_candidature |
post_it.id_cand
candidature.id_cand
| Restrict delete
fk_message_i18n_id_i18n |
message.id_i18n_val_msg
i18n.id_i18n
| Restrict delete
fk_droit_user_profil_droit_profil_id_profil |
droit_profil_ind.id_profil
droit_profil.id_profil
| Restrict delete
fk_droit_profil_ind_individu_login_ind |
droit_profil_ind.login_ind
individu.login_ind
| Restrict delete
fk_individu_preference_ind_login_ind |
preference_ind.login_ind
individu.login_ind
| Restrict delete
fk_candidat_formulaire_candidat_id_candidat |
formulaire_candidat.id_candidat
candidat.id_candidat
| Restrict delete
fk_cursus_siscol_commune_cod_com |
candidat_cursus_post_bac.cod_com
siscol_commune.cod_com
| Restrict delete
fk_cursus_siscol_departement_cod_dep |
candidat_cursus_post_bac.cod_dep
siscol_departement.cod_dep
| Restrict delete
fk_cursus_siscol_mention_cod_men |
candidat_cursus_post_bac.cod_men
siscol_mention.cod_men
| Restrict delete
fk_cursus_post_bac_candidat_id_candidat |
candidat_cursus_post_bac.id_candidat
candidat.id_candidat
| Restrict delete
fk_cursus_siscol_pays_cod_pay |
candidat_cursus_post_bac.cod_pay
siscol_pays.cod_pay
| Restrict delete
fk_cursus_siscol_etablissement_cod_etb |
candidat_cursus_post_bac.cod_etb
siscol_etablissement.cod_etb
| Restrict delete
fk_cursus_siscol_dip_aut_cur_cod_dac |
candidat_cursus_post_bac.cod_dac
siscol_dip_aut_cur.cod_dac
| Restrict delete
fk_i18n_formulaire_id18n_url |
formulaire.id_i18n_url_formulaire
i18n.id_i18n
| Restrict delete
fk_i18n_formulaire_id18n_lib |
formulaire.id_i18n_lib_formulaire
i18n.id_i18n
| Restrict delete
fk_centre_candidature_formulaire_id_ctr_cand |
formulaire.id_ctr_cand
centre_candidature.id_ctr_cand
| Restrict delete
fk_candidat_stage_candidat_id_candidat |
candidat_stage.id_candidat
candidat.id_candidat
| Restrict delete
fk_type_statut_i18n_id_i18n_lib_typ_statut |
type_statut.id_i18n_lib_typ_statut
i18n.id_i18n
| Restrict delete
fk_fichier_commission_id_fichier |
commission.id_fichier
fichier.id_fichier
| Restrict delete
fk_commission_i18n_id_i18n_comment_retour_comm |
commission.id_i18n_comment_retour_comm
i18n.id_i18n
| Restrict delete
fk_commission_centre_candidature_id_ctr_cand |
commission.id_ctr_cand
centre_candidature.id_ctr_cand
| Restrict delete
fk_commission_adresse_id_adr |
commission.id_adr
adresse.id_adr
| Restrict delete
fk_candidature_type_statut_cod_typ_statut |
candidature.cod_typ_statut
type_statut.cod_typ_statut
| Restrict delete
fk_candidature_formation_id_form |
candidature.id_form
formation.id_form
| Restrict delete
fk_candidature_candidat_id_candidat |
candidature.id_candidat
candidat.id_candidat
| Restrict delete
fk_candidature_type_traitement_cod_typ_trait |
candidature.cod_typ_trait
type_traitement.cod_typ_trait
| Restrict delete
fk_type_trait_i18n_id_i18n_lib_typ_trait |
type_traitement.id_i18n_lib_typ_trait
i18n.id_i18n
| Restrict delete
fk_gestionnaire_droit_profil_ind_id_droit_profil_ind |
gestionnaire.id_droit_profil_ind
droit_profil_ind.id_droit_profil_ind
| Restrict delete
fk_gestionnaire_cge_cod_cge |
gestionnaire.cod_cge
siscol_centre_gestion.cod_cge
| Restrict delete
fk_centre_candidature_gestionnaire_id_ctr_cand |
gestionnaire.id_ctr_cand
centre_candidature.id_ctr_cand
| Restrict delete
fk_faq_i18n_id_i18n_reponse_faq |
faq.id_i18n_reponse_faq
i18n.id_i18n
| Restrict delete
fk_faq_i18n_id_i18n_question_faq |
faq.id_i18n_question_faq
i18n.id_i18n
| Restrict delete
fk_camp_cpt_min_id_camp |
compte_minima.id_camp
campagne.id_camp
| Restrict delete
fk_type_statut_piece_i18n_id_i18n_lib_typ_statut_piece |
type_statut_piece.id_i18n_lib_typ_statut_piece
i18n.id_i18n
| Restrict delete
fk_tag_centre_candidature_id_ctr_cand |
tag.id_ctr_cand
centre_candidature.id_ctr_cand
| Restrict delete
fk_compte_minima_candidat_id_cpt_min |
candidat.id_cpt_min
compte_minima.id_cpt_min
| Restrict delete
fk_candidat_siscol_pays_cod_pays_naiss |
candidat.cod_pay_naiss
siscol_pays.cod_pay
| Restrict delete
fk_siscol_departement_cod_dep_cod_dep_naiss |
candidat.cod_dep_naiss_candidat
siscol_departement.cod_dep
| Restrict delete
fk_civilite_candidat_cod_civ |
candidat.cod_civ
civilite.cod_civ
| Restrict delete
fk_candidat_adresse_id_adr |
candidat.id_adr
adresse.id_adr
| Restrict delete
fk_candidat_langue_id_langue |
candidat.cod_langue
langue.cod_langue
| Restrict delete
fk_candidat_siscol_pays_cod_pay_nat |
candidat.cod_pay_nat
siscol_pays.cod_pay
| Restrict delete
fk_formulaire_cand_formulaire_id_formulaire |
formulaire_cand.id_formulaire
formulaire.id_formulaire
| Restrict delete
fk_formulaire_cand_candidature_id_cand |
formulaire_cand.id_cand
candidature.id_cand
| Restrict delete
fk_batch_histo_batch_cod_batch |
batch_histo.cod_batch
batch.cod_batch
| Restrict delete
fk_pj_form_pj_id_pj |
pj_form.id_pj
piece_justif.id_pj
| Restrict delete
fk_pj_form_form_id_form |
pj_form.id_form
formation.id_form
| Restrict delete

### Check Constraints

Table | Constraint Name | Constraint
--- | --- | ---
None detected