# siscol_etablissement

### Description

Rérérentiel SiScol : Etablissements francais sec ou sup

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
cod_etb | VARCHAR | 8 |  |  | null |
candidat_bac_ou_equ.cod_etb | fk_bac_ou_equ_siscol_etablissement_cod_etb R
candidat_cursus_post_bac.cod_etb | fk_cursus_siscol_etablissement_cod_etb R
|  | Code National de l"Etablissement
cod_tpe_etb | VARCHAR | 2 |  |  | 00 |  |  | Code Type Etablissement
cod_dep | VARCHAR | 3 |  |  | null |  |
siscol_departement.cod_dep | fk_siscol_departement_etab_cod_dep R
| Code Departement
cod_com | VARCHAR | 5 | √ |  | null |  |
siscol_commune.cod_com | fk_siscol_commune_siscol_etab_cod_com R
| code commune
lib_etb | VARCHAR | 40 |  |  | null |  |  | Libelle Long Etablissement
lic_etb | VARCHAR | 10 |  |  | null |  |  | Libelle Court Etablissement
tem_en_sve_etb | BIT | 1 |  |  | null |  |  | Temoin Code en Service
lib_web_etb | VARCHAR | 120 | √ |  | null |  |  | Libellé Web

Table contained 12384 rows

### Indexes

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

### Relationships