Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.formulaire_cand table des formulaires (NC) de la candidature | 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_formulaire | int | 10 |  |  |  |  |
formulaire.id_formulaire | fk_formulaire_cand_formulaire_id_formulaire R
| identifiant du formulaire
id_cand | int | 10 |  |  |  |  |
candidature.id_cand | fk_formulaire_cand_candidature_id_cand R
| identifiant de la candidature
dat_cre_formulaire_cand | datetime | 19 |  |  |  |  |  | date de création
user_cre_formulaire_cand | varchar | 30 |  |  |  |  |  | user de création
dat_mod_formulaire_cand | datetime | 19 |  |  |  |  |  | date de modification
user_mod_formulaire_cand | varchar | 30 |  |  |  |  |  | user de modification
Table contained 0 rows at lun. févr. 20 13:02 CET 2017

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_formulaire + id_cand | Primary key | Asc/Asc | PRIMARY
id_cand | Performance | Asc | fk_formulaire_cand_candidature_id_cand
id_formulaire | Performance | Asc | fk_formulaire_cand_formulaire_id_formulaire

Close relationships within one two degrees of separation: