Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.candidat_cursus_interne table des cursus interne du 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_cursus_interne | int | 10 |  | √ |  |  |  | identifiant du cursus interne
id_candidat | int | 10 |  |  |  |  |
candidat.id_candidat | fk_candidat_cursus_interne_candidat_id_candidat R
| identifiant du candidat
annee_univ_cursus_interne | int | 10 | √ |  | null |  |  | annee universitaire du cursus interne
cod_vet_cursus_interne | varchar | 100 | √ |  | null |  |  | code de la vet du cursus interne
lib_cursus_interne | varchar | 255 | √ |  | null |  |  | libelle du cursus interne
cod_men_cursus_interne | varchar | 2 | √ |  | null |  |
siscol_mention.cod_men | fk_siscol_mention_cursus_interne_cod_men R
| code de la mention du cursus interne
cod_tre_cursus_interne | varchar | 4 | √ |  | null |  |
siscol_typ_resultat.cod_tre | fk_siscol_typ_resultat_candidat_cursus_interne_cod_tre R
| temoin d'obention du cursus interne
Table contained 27 rows at lun. févr. 20 13:02 CET 2017

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_cursus_interne | Primary key | Asc | PRIMARY
id_candidat | Performance | Asc | fk_candidat_cursus_interne_candidat_id_candidat
cod_men_cursus_interne | Performance | Asc | fk_siscol_mention_cursus_interne_cod_men
cod_tre_cursus_interne | Performance | Asc | fk_siscol_typ_resultat_candidat_cursus_interne_cod_tre

Close relationships within one two degrees of separation: