# mail

### Description

table des mails

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id_mail | INT | 10 |  | √ | null |
type_decision.id_mail | fk_type_decision_mail_id_mail R
|  | identifiant du mail
cod_typ_avis | VARCHAR | 2 | √ |  | null |  |
type_avis.cod_typ_avis | fk_mail_type_avis_cod_typ_avis R
| type de décision lié au mail
cod_mail | VARCHAR | 30 |  |  | null |  |  | code du mail
lib_mail | VARCHAR | 100 |  |  | null |  |  | libelle du mail
id_ctr_cand | INT | 10 | √ |  | null |  |
centre_candidature.id_ctr_cand | fk_mail_centre_candidature_id_ctr_cand R
| identifiant du centre de candidature éventuel
tem_is_modele_mail | BIT | 1 |  |  | null |  |  | temoin si le mail est un modele de mail
tes_mail | BIT | 1 |  |  | null |  |  | temoin en service
id_i18n_sujet_mail | INT | 10 |  |  | null |  |
i18n.id_i18n | fk_mail_i18n_id_i18n_sujet_mail R
| identifiant i18n du sujet du mail
id_i18n_corps_mail | INT | 10 |  |  | null |  |
i18n.id_i18n | fk_mail_i18n_id_i18n_corps_mail R
| identifiant i18n du corps du mail
dat_cre_mail | DATETIME | 19 |  |  | null |  |  | date de création
user_cre_mail | VARCHAR | 50 |  |  | null |  |  | user de création
dat_mod_mail | DATETIME | 19 |  |  | null |  |  | date de modification
user_mod_mail | VARCHAR | 50 |  |  | null |  |  | user de modification

Table contained 38 rows

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id_mail
cod_mail | Must be unique | Asc | cod_mail
fk_mail_centre_candidature_id_ctr_cand | Performance | Asc | id_ctr_cand
fk_mail_i18n_id_i18n_corps_mail | Performance | Asc | id_i18n_corps_mail
fk_mail_i18n_id_i18n_sujet_mail | Performance | Asc | id_i18n_sujet_mail
fk_mail_type_avis_cod_typ_avis | Performance | Asc | cod_typ_avis

### Relationships