Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.commission table des commissions | 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_comm | int | 10 |  | √ |  |
commission_membre.id_comm | fk_commission_membre_commission_id_comm R
formation.id_comm | fk_formation_commission_id_comm R
gestionnaire_commission.id_comm | commission_gestionnaire_commission_id_comm R
|  | identifiant de la commission
id_ctr_cand | int | 10 |  |  |  |  |
centre_candidature.id_ctr_cand | fk_commission_centre_candidature_id_ctr_cand R
| identifiant du centre de candidature de la commissio
cod_comm | varchar | 30 |  |  |  |  |  | code de la commission
lib_comm | varchar | 200 |  |  |  |  |  | libellé de la commission
mail_comm | varchar | 80 |  |  |  |  |  | mail de contact de la commission
tel_comm | varchar | 20 | √ |  | null |  |  | telephone de contact de la commission
fax_comm | varchar | 20 | √ |  | null |  |  | fax de la commission
id_adr | int | 10 |  |  |  |  |
adresse.id_adr | fk_commission_adresse_id_adr R
| identifiant de l'adresse
comment_retour_comm | varchar | 500 | √ |  | null |  |  | commentaire lors du retour de dossier pour la commission
tes_comm | bit | 1 |  |  |  |  |  | temoin en service de la commission
signataire_comm | varchar | 255 | √ |  | null |  |  | signataire
id_fichier | int | 10 | √ |  | null |  |
fichier.id_fichier | fk_fichier_commission_id_fichier R
| fichier de la signature
tem_edit_lettre_comm | bit | 1 |  |  | b'0' |  |  | témoin indiquant que la commission autorise l'edition des lettres d'admission et de refus
tem_mail_lettre_comm | bit | 1 |  |  | b'0' |  |  | témoin indiquant que la commission autorise l'envoi par mail des lettres d'admission et de refus
tem_alert_prop_comm | bit | 1 |  |  | b'1' |  |  | témoin indiquant que la commission reçoit les alertes de proposition
tem_alert_annul_comm | bit | 1 |  |  | b'1' |  |  | témoin indiquant que la commission reçoit les alertes d'annulation
tem_alert_trans_comm | bit | 1 |  |  | b'1' |  |  | témoin indiquant que la commission reçoit les alertes de transmission de dossier
dat_cre_comm | datetime | 19 |  |  |  |  |  | date de création
user_cre_comm | varchar | 30 |  |  |  |  |  | user de création
dat_mod_comm | datetime | 19 |  |  |  |  |  | date de modification
user_mod_comm | varchar | 30 |  |  |  |  |  | user de modification
Table contained 9 rows at lun. févr. 20 13:02 CET 2017

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_comm | Primary key | Asc | PRIMARY
cod_comm | Must be unique | Asc | cod_comm
id_adr | Performance | Asc | fk_commission_adresse_id_adr
id_ctr_cand | Performance | Asc | fk_commission_centre_candidature_id_ctr_cand
id_fichier | Performance | Asc | fk_fichier_commission_id_fichier

Close relationships within one two degrees of separation: