Tables Relationships Utility Tables Constraints Anomalies Columns Donate

SchemaSpy Analysis of ecandidat - Constraints | Generated by SchemaSpy

106 Foreign Key Constraints: |

Constraint Name | Child Column | Parent Column | Delete Rule
--- | --- | --- | ---
campagne_id_camp_id_camp | campagne.archiv_id_camp | campagne.id_camp | Restrict delete
commission_gestionnaire_commission_id_comm | gestionnaire_commission.id_comm | commission.id_comm | Restrict delete
fk_adresse_siscol_commune_cod_com | adresse.cod_com | siscol_commune.cod_com | Restrict delete
fk_adresse_siscol_pays_cod_pay | adresse.cod_pay | siscol_pays.cod_pay | 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_bac_ou_equ_cod_bac | candidat_bac_ou_equ.cod_bac | siscol_bac_oux_equ.cod_bac | 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_departement_cod_dep | candidat_bac_ou_equ.cod_dep | siscol_departement.cod_dep | 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_mention_niv_bac_cod_mnb | candidat_bac_ou_equ.cod_mnb | siscol_mention_niv_bac.cod_mnb | Restrict delete
fk_bac_ou_equ_siscol_pays_cod_pay | candidat_bac_ou_equ.cod_pay | siscol_pays.cod_pay | Restrict delete
fk_batch_histo_batch_cod_batch | batch_histo.cod_batch | batch.cod_batch | Restrict delete
fk_camp_cpt_min_id_camp | compte_minima.id_camp | campagne.id_camp | Restrict delete
fk_campagne_i18n_id_i18n_id_i18n_libelle_campagne | campagne.id_i18n_libelle_campagne | i18n.id_i18n | Restrict delete
fk_cand_opi_id_cand | opi.id_cand | candidature.id_cand | Restrict delete
fk_cand_pj_form_cand_pk | pj_cand.id_cand | candidature.id_cand | Restrict delete
fk_candidat_adresse_id_adr | candidat.id_adr | adresse.id_adr | Restrict delete
fk_candidat_cursus_interne_candidat_id_candidat | candidat_cursus_interne.id_candidat | candidat.id_candidat | Restrict delete
fk_candidat_formulaire_candidat_id_candidat | formulaire_candidat.id_candidat | candidat.id_candidat | Restrict delete
fk_candidat_langue_id_langue | candidat.cod_langue | langue.cod_langue | Restrict delete
fk_candidat_opi_pj_id_candidat | pj_opi.id_candidat | candidat.id_candidat | Restrict delete
fk_candidat_pj_candidat_id_candidat | pj_candidat.id_candidat | candidat.id_candidat | Restrict delete
fk_candidat_siscol_pays_cod_pay_nat | candidat.cod_pay_nat | siscol_pays.cod_pay | Restrict delete
fk_candidat_siscol_pays_cod_pays_naiss | candidat.cod_pay_naiss | siscol_pays.cod_pay | Restrict delete
fk_candidat_stage_candidat_id_candidat | candidat_stage.id_candidat | candidat.id_candidat | Restrict delete
fk_candidature_candidat_id_candidat | candidature.id_candidat | candidat.id_candidat | Restrict delete
fk_candidature_formation_id_form | candidature.id_form | formation.id_form | Restrict delete
fk_candidature_post_it_id_candidature | post_it.id_cand | candidature.id_cand | Restrict delete
fk_candidature_tag_id_tag | candidature.id_tag | tag.id_tag | Restrict delete
fk_candidature_type_statut_cod_typ_statut | candidature.cod_typ_statut | type_statut.cod_typ_statut | Restrict delete
fk_candidature_type_traitement_cod_typ_trait | candidature.cod_typ_trait | type_traitement.cod_typ_trait | Restrict delete
fk_centre_candidature_formulaire_id_ctr_cand | formulaire.id_ctr_cand | centre_candidature.id_ctr_cand | Restrict delete
fk_centre_candidature_gestionnaire_id_ctr_cand | gestionnaire.id_ctr_cand | centre_candidature.id_ctr_cand | 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_civilite_candidat_cod_civ | candidat.cod_civ | civilite.cod_civ | Restrict delete
fk_commission_adresse_id_adr | commission.id_adr | adresse.id_adr | Restrict delete
fk_commission_centre_candidature_id_ctr_cand | commission.id_ctr_cand | centre_candidature.id_ctr_cand | Restrict delete
fk_commission_i18n_id_i18n_comment_retour_comm | commission.id_i18n_comment_retour_comm | i18n.id_i18n | Restrict delete
fk_commission_membre_commission_id_comm | commission_membre.id_comm | commission.id_comm | Restrict delete
fk_compte_minima_candidat_id_cpt_min | candidat.id_cpt_min | compte_minima.id_cpt_min | Restrict delete
fk_cursus_post_bac_candidat_id_candidat | candidat_cursus_post_bac.id_candidat | candidat.id_candidat | Restrict delete
fk_cursus_pro_candidat_id_candidat | candidat_cursus_pro.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_dip_aut_cur_cod_dac | candidat_cursus_post_bac.cod_dac | siscol_dip_aut_cur.cod_dac | Restrict delete
fk_cursus_siscol_etablissement_cod_etb | candidat_cursus_post_bac.cod_etb | siscol_etablissement.cod_etb | Restrict delete
fk_cursus_siscol_mention_cod_men | candidat_cursus_post_bac.cod_men | siscol_mention.cod_men | Restrict delete
fk_cursus_siscol_pays_cod_pay | candidat_cursus_post_bac.cod_pay | siscol_pays.cod_pay | 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_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_droit_profil_ind_individu_login_ind | droit_profil_ind.login_ind | individu.login_ind | Restrict delete
fk_droit_user_profil_droit_profil_id_profil | droit_profil_ind.id_profil | droit_profil.id_profil | Restrict delete
fk_faq_i18n_id_i18n_question_faq | faq.id_i18n_question_faq | i18n.id_i18n | Restrict delete
fk_faq_i18n_id_i18n_reponse_faq | faq.id_i18n_reponse_faq | i18n.id_i18n | Restrict delete
fk_fichier_commission_id_fichier | commission.id_fichier | fichier.id_fichier | Restrict delete
fk_fichier_piece_justif_id_fichier | piece_justif.id_fichier | fichier.id_fichier | Restrict delete
fk_fichier_pj_cand_id_fichier | pj_cand.id_fichier | fichier.id_fichier | Restrict delete
fk_formation_commission_id_comm | formation.id_comm | commission.id_comm | Restrict delete
fk_formation_i18n_id_i18n_info_comp_form | formation.id_i18n_info_comp_form | i18n.id_i18n | 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_decision_id_typ_dec_fav_form | formation.id_typ_dec_fav | type_decision.id_typ_dec | 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_traitement_cod_typ_trait | formation.cod_typ_trait | type_traitement.cod_typ_trait | Restrict delete
fk_formulaire_cand_candidature_id_cand | formulaire_cand.id_cand | candidature.id_cand | Restrict delete
fk_formulaire_cand_formulaire_id_formulaire | formulaire_cand.id_formulaire | formulaire.id_formulaire | 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_gestionnaire_cge_cod_cge | gestionnaire.cod_cge | siscol_centre_gestion.cod_cge | 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_i18n_formulaire_id18n_lib | formulaire.id_i18n_lib_formulaire | i18n.id_i18n | Restrict delete
fk_i18n_formulaire_id18n_url | formulaire.id_i18n_url_formulaire | i18n.id_i18n | Restrict delete
fk_individu_preference_ind_login_ind | preference_ind.login_ind | individu.login_ind | Restrict delete
fk_mail_i18n_id_i18n_corps_mail | mail.id_i18n_corps_mail | i18n.id_i18n | Restrict delete
fk_mail_i18n_id_i18n_sujet_mail | mail.id_i18n_sujet_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_message_i18n_id_i18n | message.id_i18n_val_msg | i18n.id_i18n | Restrict delete
fk_motivation_avis_i18n_id_i18n_lib_motiv | motivation_avis.id_i18n_lib_motiv | i18n.id_i18n | 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_i18n_id_i18n_lib_pj | piece_justif.id_i18n_lib_pj | i18n.id_i18n | 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_pj_form_form_id_form | pj_form.id_form | formation.id_form | Restrict delete
fk_pj_form_pj_id_pj | pj_form.id_pj | piece_justif.id_pj | Restrict delete
fk_siscol_centre_gestion_utilisateur_cod_cge | siscol_utilisateur.cod_cge | siscol_centre_gestion.cod_cge | Restrict delete
fk_siscol_commune_siscol_etab_cod_com | siscol_etablissement.cod_com | siscol_commune.cod_com | Restrict delete
fk_siscol_departement_cod_dep_cod_dep_naiss | candidat.cod_dep_naiss_candidat | siscol_departement.cod_dep | Restrict delete
fk_siscol_departement_commune_cod_dep | siscol_commune.cod_dep | siscol_departement.cod_dep | Restrict delete
fk_siscol_departement_etab_cod_dep | siscol_etablissement.cod_dep | siscol_departement.cod_dep | Restrict delete
fk_siscol_mention_cursus_interne_cod_men | candidat_cursus_interne.cod_men_cursus_interne | siscol_mention.cod_men | 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_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_typ_dec_cand_candidature_id_cand | type_decision_candidature.id_cand | candidature.id_cand | 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_typ_dec_id_typ_dec | type_decision_candidature.id_typ_dec | type_decision.id_typ_dec | Restrict delete
fk_type_decision_i18n_id_i18n_lib_typ_dec | type_decision.id_i18n_lib_typ_dec | i18n.id_i18n | Restrict delete
fk_type_decision_mail_id_mail | type_decision.id_mail | mail.id_mail | Restrict delete
fk_type_statut_i18n_id_i18n_lib_typ_statut | type_statut.id_i18n_lib_typ_statut | i18n.id_i18n | 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_type_traduction_cod_typ_trad | i18n.cod_typ_trad | type_traduction.cod_typ_trad | Restrict delete
fk_type_trait_i18n_id_i18n_lib_typ_trait | type_traitement.id_i18n_lib_typ_trait | i18n.id_i18n | Restrict delete
fktype_decision_type_avis_cod_typ_avis | type_decision.cod_typ_avis | type_avis.cod_typ_avis | Restrict delete
gestionnaire_gestionnaire_commission_id_droit_profil_ind | gestionnaire_commission.id_droit_profil_ind | gestionnaire.id_droit_profil_ind | Restrict delete

Check Constraints:

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