Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.motivation_avis table des motivations d'avis | Generated by SchemaSpy

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_motiv | int | 10 |  | √ |  |
type_decision_candidature.id_motiv | fk_typ_dec_cand_motivation_avis_id_motiv R
|  | identifiant de la motivation d'avis
cod_motiv | varchar | 20 |  |  |  |  |  | code de la motivation d'avis
lib_motiv | varchar | 50 |  |  |  |  |  | libellé de la motivation
id_i18n_lib_motiv | int | 10 |  |  |  |  |
i18n.id_i18n | fk_motivation_avis_i18n_id_i18n_lib_motiv R
| identifiant i18n de la motivation d'avis
tes_motiv | bit | 1 |  |  |  |  |  | témoin en service de la motivation d'avis
dat_cre_motiv | datetime | 19 |  |  |  |  |  | date de création
user_cre_motiv | varchar | 30 |  |  |  |  |  | user de création
dat_mod_motiv | datetime | 19 |  |  |  |  |  | date de modification
user_mod_motiv | varchar | 30 |  |  |  |  |  | user de modification
Table contained 4 rows at lun. févr. 20 13:02 CET 2017

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_motiv | Primary key | Asc | PRIMARY
cod_motiv | Must be unique | Asc | cod_motiv
id_i18n_lib_motiv | Performance | Asc | fk_motivation_avis_i18n_id_i18n_lib_motiv

Close relationships within one two degrees of separation: