# type_decision

### Description

table des types de décision

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id_typ_dec | INT | 10 |  | √ | null |
centre_candidature.id_typ_dec_fav | fk_centre_candidature_typ_decision_id_typ_dec_fav R
centre_candidature.id_typ_dec_fav_list_comp | fk_centre_candidature_typ_decision_id_typ_dec_fav_list_comp R
formation.id_typ_dec_fav | fk_formation_type_decision_id_typ_dec_fav_form R
formation.id_typ_dec_fav_list_comp | fk_formation_type_decision_id_typ_dec_fav_list_comp R
type_decision_candidature.id_typ_dec | fk_typ_dec_cand_typ_dec_id_typ_dec R
|  | identifiant du type de decision
cod_typ_avis | VARCHAR | 2 |  |  | null |  |
type_avis.cod_typ_avis | fk_type_decision_type_avis_cod_typ_avis R
| type_d'avis correspondant au type de décision
cod_typ_dec | VARCHAR | 20 |  |  | null |  |  | code du type de decision
lib_typ_dec | VARCHAR | 50 |  |  | null |  |  | libellé type de decision
id_i18n_lib_typ_dec | INT | 10 |  |  | null |  |
i18n.id_i18n | fk_type_decision_i18n_id_i18n_lib_typ_dec R
| identifiant i18n du libellé du type de décision
id_mail | INT | 10 |  |  | null |  |
mail.id_mail | fk_type_decision_mail_id_mail R
| id mail du type de decision
id_ctr_cand | INT | 10 | √ |  | null |  |
centre_candidature.id_ctr_cand | fk_type_decision_centre_candidature_id_ctr_cand R
| identifiant du centre de candidature éventuel
tes_typ_dec | BIT | 1 |  |  | null |  |  | temoin en service du type de decision
tem_deverse_opi_typ_dec | BIT | 1 |  |  | null |  |  | temoin de deversement d'opi pour ce type de decision
tem_definitif_typ_dec | BIT | 1 |  |  | null |  |  | temoin pour indiquer si le type de decision est défnitif
tem_model_typ_dec | BIT | 1 |  |  | null |  |  | témoi si le type de decision est un modele
tem_aff_comment_typ_dec | BIT | 1 |  |  | b'1' |  |  | témoin si le commentaire s'affiche pour le candidat
dat_cre_typ_dec | DATETIME | 19 |  |  | null |  |  | date de création
user_cre_typ_dec | VARCHAR | 50 |  |  | null |  |  | user de création
dat_mod_typ_dec | DATETIME | 19 |  |  | null |  |  | date de modification
user_mod_typ_dec | VARCHAR | 50 |  |  | null |  |  | user de modification

Table contained 13 rows

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id_typ_dec
cod_typ_dec | Must be unique | Asc | cod_typ_dec
fk_type_decision_centre_candidature_id_ctr_cand | Performance | Asc | id_ctr_cand
fk_type_decision_i18n_id_i18n_lib_typ_dec | Performance | Asc | id_i18n_lib_typ_dec
fk_type_decision_mail_id_mail | Performance | Asc | id_mail
fk_type_decision_type_avis_cod_typ_avis | Performance | Asc | cod_typ_avis

### Relationships