Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.pj_form table associative liant des pièces et des formations | 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
--- | --- | --- | --- | --- | --- | --- | --- | ---
id_pj | int | 10 |  |  |  |  |
piece_justif.id_pj | fk_pj_form_pj_id_pj R
| identifiant de la pj
id_form | int | 10 |  |  |  |  |
formation.id_form | fk_pj_form_form_id_form R
| identifiant de la formation
Table contained 3 rows at ven. juin 01 10:59 CEST 2018

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_pj + id_form | Primary key | Asc/Asc | PRIMARY
id_form | Performance | Asc | fk_pj_form_form_id_form
id_pj | Performance | Asc | fk_pj_form_pj_id_pj

Close relationships within one two degrees of separation: