Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.candidat_cursus_pro table des cursus pro ou stage | 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_cursus_pro | int | 10 |  | √ |  |  |  | identifiant du curusus
id_candidat | int | 10 |  |  |  |  |
candidat.id_candidat | fk_cursus_pro_candidat_id_candidat R
| identifiant du candidat
annee_cursus_pro | int | 10 |  |  |  |  |  | année du curusus
duree_cursus_pro | varchar | 20 |  |  |  |  |  | durée du curusus
organisme_cursus_pro | varchar | 50 |  |  |  |  |  | organisme ou employeur du curusus
intitule_cursus_pro | varchar | 50 |  |  |  |  |  | intitulé du curusus
objectif_cursus_pro | varchar | 500 | √ |  | null |  |  | descriptif du curusus
Table contained 3 rows at lun. févr. 20 13:02 CET 2017

Indexes:

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

Close relationships within one two degrees of separation: