# adresse

### Description

table des adresses

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id_adr | INT | 10 |  | √ | null |
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 |  |  | null |  |
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 85919 rows

### Indexes

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

### Relationships