Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.gestionnaire table des gestionnaires de ctr candidature | 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_droit_profil_ind | int | 10 |  |  |  |
gestionnaire_commission.id_droit_profil_ind | gestionnaire_gestionnaire_commission_id_droit_profil_ind R
droit_profil_ind.id_droit_profil_ind | fk_gestionnaire_droit_profil_ind_id_droit_profil_ind R
| identifiant du profil individu
id_ctr_cand | int | 10 |  |  |  |  |
centre_candidature.id_ctr_cand | fk_centre_candidature_gestionnaire_id_ctr_cand R
| identifiant du centre de candidature
login_apo_gest | varchar | 20 | √ |  | null |  |  | login apogee eventuel du gestionnaire
cod_cge | varchar | 3 | √ |  | null |  |
siscol_centre_gestion.cod_cge | fk_gestionnaire_cge_cod_cge R
| code cge du gestionnaire
tem_all_comm_gest | bit | 1 |  |  |  |  |  | témoin si le gestionnaire est gestionnaire de toutes les commissions du centre de candidature
Table contained 2 rows at lun. févr. 20 13:02 CET 2017

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_droit_profil_ind | Primary key | Asc | PRIMARY
id_ctr_cand | Performance | Asc | fk_centre_candidature_gestionnaire_id_ctr_cand
cod_cge | Performance | Asc | fk_gestionnaire_cge_cod_cge
id_droit_profil_ind | Performance | Asc | fk_gestionnaire_droit_profil_ind_id_droit_profil_ind

Close relationships within one two degrees of separation: