Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.pj_cand table des pj déposées par le candidat pour une formation | 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_pj | int | 10 |  |  |  |  |
piece_justif.id_pj | fk_pj_cand_pj_id_pj R
| identifiant de la pj
id_cand | int | 10 |  |  |  |  |
candidature.id_cand | fk_cand_pj_form_cand_pk R
| identifiant de la candidature
id_fichier | int | 10 | √ |  | null |  |
fichier.id_fichier | fk_fichier_pj_cand_id_fichier R
| fichier en demat'
cod_typ_statut_piece | varchar | 2 |  |  |  |  |
type_statut_piece.cod_typ_statut_piece | fk_pj_cand_type_statut_piece_cod R
| statut de la pièce
lib_file_pj_cand | varchar | 500 | √ |  | null |  |  | libellé de la pj déposée par le candidat
comment_pj_cand | varchar | 500 | √ |  | null |  |  | commentaire éventuel du gestionnaire
dat_cre_pj_cand | datetime | 19 |  |  |  |  |  | date de création
user_cre_pj_cand | varchar | 30 |  |  |  |  |  | user de création
dat_mod_pj_cand | datetime | 19 |  |  |  |  |  | date de modification
user_mod_pj_cand | varchar | 30 |  |  |  |  |  | user de modification
dat_mod_statut_pj_cand | datetime | 19 | √ |  | null |  |  | date de modif du statut de la piece
user_mod_statut_pj_cand | varchar | 30 | √ |  | null |  |  | user de modif de statut de la piece
Table contained 10 rows at lun. févr. 20 13:02 CET 2017

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_pj + id_cand | Primary key | Asc/Asc | PRIMARY
id_cand | Performance | Asc | fk_cand_pj_form_cand_pk
id_fichier | Performance | Asc | fk_fichier_pj_cand_id_fichier
id_pj | Performance | Asc | fk_pj_cand_pj_id_pj
cod_typ_statut_piece | Performance | Asc | fk_pj_cand_type_statut_piece_cod

Close relationships within one two degrees of separation: