Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.pj_opi table des PJ OPI à déverser dans Apogée | Generated by SchemaSpy

Implied relationships 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
--- | --- | --- | --- | --- | --- | --- | --- | ---
cod_apo_pj | varchar | 5 |  |  |  |  |  | Code Apogée de la pièce
cod_opi | varchar | 10 |  |  |  |  |  | Code de l'opi
id_candidat | int | 10 |  |  |  |  |
candidat.id_candidat | fk_candidat_opi_pj_id_candidat R
| Identifiant du candidat
id_fichier | int | 10 |  |  |  |  |
fichier.id_fichier | Implied Constraint R
| Identifiant du fichier (non clé étrangère car le fichier peut disparaitre)
dat_deversement | datetime | 19 | √ |  | null |  |  | Date de déversement de la pièce
Table contained 0 rows at ven. juin 01 10:59 CEST 2018

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
cod_apo_pj + cod_opi | Primary key | Asc/Asc | PRIMARY
id_candidat | Performance | Asc | fk_candidat_opi_pj_id_candidat

Close relationships within one two degrees of separation: