# siscol_commune

### Description

Rérérentiel SiScol : Table des communes

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
cod_com | VARCHAR | 5 |  |  | null |
adresse.cod_com | fk_adresse_siscol_commune_cod_com R
candidat_bac_ou_equ.cod_com | fk_bac_ou_equ_siscol_commune_cod_com R
candidat_cursus_post_bac.cod_com | fk_cursus_siscol_commune_cod_com R
siscol_etablissement.cod_com | fk_siscol_commune_siscol_etab_cod_com R
|  | Code INSEE Commune
cod_dep | VARCHAR | 3 |  |  | null |  |
siscol_departement.cod_dep | fk_siscol_departement_commune_cod_dep R
| Code Departement
lib_com | VARCHAR | 32 |  |  | null |  |  | libelle Long Commune
tem_en_sve_com | BIT | 1 |  |  | null |  |  | Temoin en Service

Table contained 39655 rows

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | cod_com
fk_siscol_departement_commune_cod_dep | Performance | Asc | cod_dep

### Relationships