# motivation_avis

### Description

table des motivations d'avis

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id_motiv | INT | 10 |  | √ | null |
type_decision_candidature.id_motiv | fk_typ_dec_cand_motivation_avis_id_motiv R
|  | identifiant de la motivation d'avis
cod_motiv | VARCHAR | 20 |  |  | null |  |  | code de la motivation d'avis
lib_motiv | VARCHAR | 50 |  |  | null |  |  | libellé de la motivation
id_i18n_lib_motiv | INT | 10 |  |  | null |  |
i18n.id_i18n | fk_motivation_avis_i18n_id_i18n_lib_motiv R
| identifiant i18n de la motivation d'avis
id_ctr_cand | INT | 10 | √ |  | null |  |
centre_candidature.id_ctr_cand | fk_motivation_avis_centre_candidature_id_ctr_cand R
| identifiant du centre de candidature éventuel
tes_motiv | BIT | 1 |  |  | null |  |  | témoin en service de la motivation d'avis
dat_cre_motiv | DATETIME | 19 |  |  | null |  |  | date de création
user_cre_motiv | VARCHAR | 50 |  |  | null |  |  | user de création
dat_mod_motiv | DATETIME | 19 |  |  | null |  |  | date de modification
user_mod_motiv | VARCHAR | 50 |  |  | null |  |  | user de modification

Table contained 9 rows

### Indexes

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

### Relationships