Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.adresse table des adresses | 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_adr | int | 10 |  | √ |  |
candidat.id_adr | fk_candidat_adresse_id_adr R
commission.id_adr | fk_commission_adresse_id_adr R
|  | identifiant de l'adresse
cod_pay | varchar | 3 |  |  |  |  |
siscol_pays.cod_pay | fk_adresse_siscol_pays_cod_pay R
| code du pays de l'adresse
cod_bdi_adr | varchar | 5 | √ |  | null |  |  | code postal de l'adresse (fr)
cod_com | varchar | 5 | √ |  | null |  |
siscol_commune.cod_com | fk_adresse_siscol_commune_cod_com R
| code commune de l'adresse (fr)
lib_com_etr_adr | varchar | 32 | √ |  | null |  |  | libellé de la commune du candidat
adr1_adr | varchar | 32 | √ |  | null |  |  | libellé 1 de l'adresse
adr2_adr | varchar | 32 | √ |  | null |  |  | libellé 2 de l'adresse
adr3_adr | varchar | 32 | √ |  | null |  |  | libellé 3 de l'adresse
cedex_adr | varchar | 50 | √ |  | null |  |  | cedex de l'adresse
Table contained 38 rows at ven. juin 01 10:59 CEST 2018

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_adr | Primary key | Asc | PRIMARY
cod_com | Performance | Asc | fk_adresse_siscol_commune_cod_com
cod_pay | Performance | Asc | fk_adresse_siscol_pays_cod_pay

Close relationships within one two degrees of separation: