Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.siscol_utilisateur Rérérentiel SiScol : Table des utilisateurs | 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_uti | int | 10 |  |  |  |  |  | id de l'utilisateur
cod_uti | varchar | 30 |  |  |  |  |  | Code Utilisateur D"APOGEE connu d"ORACLE
cod_cge | varchar | 3 | √ |  | null |  |
siscol_centre_gestion.cod_cge | fk_siscol_centre_gestion_utilisateur_cod_cge R
| (COPIED)Code Centre de Gestion d"appartenance de l"utilisateur
lib_cmt_uti | varchar | 200 | √ |  | null |  |  | Libelle long associe a l"utilisateur
tem_en_sve_uti | bit | 1 |  |  |  |  |  | Temoin code en service de l"utilisateur
adr_mail_uti | varchar | 200 | √ |  | null |  |  | Adresse mail de l'utilisateur
Table contained 2 160 rows at lun. févr. 20 13:02 CET 2017

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_uti | Primary key | Asc | PRIMARY
cod_cge | Performance | Asc | fk_siscol_centre_gestion_utilisateur_cod_cge

Close relationships within one two degrees of separation: