Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.candidat_stage table des stages d'un candidat | 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_stage | int | 10 |  | √ |  |  |  | identifiant du stage
id_candidat | int | 10 |  |  |  |  |
candidat.id_candidat | fk_candidat_stage_candidat_id_candidat R
| identifiant du candidat
annee_stage | int | 10 |  |  |  |  |  | année du stage
duree_stage | varchar | 20 |  |  |  |  |  | durée du stage
organisme_stage | varchar | 50 |  |  |  |  |  | organisme ou employeur du stage
descriptif_stage | varchar | 500 |  |  |  |  |  | descriptif du stage
nb_h_sem_stage | int | 10 | √ |  | null |  |  | nb d'heure / semaine du stage
Table contained 6 rows at ven. juin 01 10:59 CEST 2018

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_stage | Primary key | Asc | PRIMARY
id_candidat | Performance | Asc | fk_candidat_stage_candidat_id_candidat

Close relationships within one two degrees of separation: