Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.i18n tables des identifiants i18n | Generated by SchemaSpy

Implied relationships Related columns Constraints Comments Legend |
Legend: |
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id_i18n | int | 10 |  | √ |  |
campagne.id_i18n_libelle_campagne | fk_campagne_i18n_id_i18n_id_i18n_libelle_campagne R
commission.id_i18n_comment_retour_comm | fk_commission_i18n_id_i18n_comment_retour_comm R
faq.id_i18n_question_faq | fk_faq_i18n_id_i18n_question_faq R
faq.id_i18n_reponse_faq | fk_faq_i18n_id_i18n_reponse_faq R
formation.id_i18n_info_comp_form | fk_formation_i18n_id_i18n_info_comp_form R
formulaire.id_i18n_lib_formulaire | fk_i18n_formulaire_id18n_lib R
formulaire.id_i18n_url_formulaire | fk_i18n_formulaire_id18n_url R
i18n_traduction.id_i18n | fk_traduction_i18n_id_i18n R
mail.id_i18n_corps_mail | fk_mail_i18n_id_i18n_corps_mail R
mail.id_i18n_sujet_mail | fk_mail_i18n_id_i18n_sujet_mail R
message.id_i18n_val_msg | fk_message_i18n_id_i18n R
motivation_avis.id_i18n_lib_motiv | fk_motivation_avis_i18n_id_i18n_lib_motiv R
piece_justif.id_i18n_lib_pj | fk_piece_justif_i18n_id_i18n_lib_pj R
type_decision.id_i18n_lib_typ_dec | fk_type_decision_i18n_id_i18n_lib_typ_dec R
type_statut.id_i18n_lib_typ_statut | fk_type_statut_i18n_id_i18n_lib_typ_statut R
type_statut_piece.id_i18n_lib_typ_statut_piece | fk_type_statut_piece_i18n_id_i18n_lib_typ_statut_piece R
type_traitement.id_i18n_lib_typ_trait | fk_type_trait_i18n_id_i18n_lib_typ_trait R
|  | identifiant i18n
cod_typ_trad | varchar | 20 |  |  |  |  |
type_traduction.cod_typ_trad | fk_type_traduction_cod_typ_trad R
| code du type de traduction
Table contained 112 rows at ven. juin 01 10:59 CEST 2018

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_i18n | Primary key | Asc | PRIMARY
cod_typ_trad | Performance | Asc | fk_type_traduction_cod_typ_trad

Close relationships within one two degrees of separation: