Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.droit_profil table des profils | 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_profil | int | 10 |  | √ |  |
droit_profil_fonc.id_profil | fk_droit_profil_fonc_droit_profil_id_profil R
droit_profil_ind.id_profil | fk_droit_user_profil_droit_profil_id_profil R
|  | identifiant du profil
cod_profil | varchar | 20 |  |  |  |  |  | code du profil
lib_profil | varchar | 255 |  |  |  |  |  | libellé du profil
typ_profil | varchar | 1 |  |  | G |  |  | type de profil : admin (A), gestionnaire (G) ou commission (C)
tem_updatable | bit | 1 |  |  |  |  |  | temoin pour savoir si le droit est modifiable
tes_profil | bit | 1 |  |  |  |  |  | témoin en service du profil
dat_cre_profil | datetime | 19 |  |  |  |  |  | date de création
user_cre_profil | varchar | 30 |  |  |  |  |  | user de création
dat_mod_profil | datetime | 19 |  |  |  |  |  | date de modification
user_mod_profil | varchar | 30 |  |  |  |  |  | user de modification
Table contained 8 rows at lun. févr. 20 13:02 CET 2017

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_profil | Primary key | Asc | PRIMARY
cod_profil | Must be unique | Asc | cod_profil

Close relationships within one two degrees of separation: