Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.pj_candidat table des pièces d'un candidat provenant du SiScol | 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_candidat | int | 10 |  |  |  |  |
candidat.id_candidat | fk_candidat_pj_candidat_id_candidat R
| id du candidat
cod_anu_pj_candidat | varchar | 4 |  |  |  |  |  | code de l'année
cod_tpj_pj_candidat | varchar | 5 |  |  |  |  |  | code de la pièce du siScol
nom_fic_pj_candidat | varchar | 30 |  |  |  |  |  | nom du fichier
dat_exp_pj_candidat | datetime | 19 | √ |  | null |  |  | date d'expiration de la pièce
dat_cre_pj_candidat | datetime | 19 |  |  |  |  |  | date de creation de la pièce
Table contained 12 rows at lun. févr. 20 13:02 CET 2017

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_candidat + cod_anu_pj_candidat + cod_tpj_pj_candidat | Primary key | Asc/Asc/Asc | PRIMARY
id_candidat | Performance | Asc | fk_candidat_pj_candidat_id_candidat

Close relationships within one two degrees of separation: