Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.siscol_etablissement Rérérentiel SiScol : Etablissements francais sec ou sup | 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
--- | --- | --- | --- | --- | --- | --- | --- | ---
cod_etb | varchar | 8 |  |  |  |
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 |  |  |  |  |
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 |  |  |  |  |  | Libelle Long Etablissement
lic_etb | varchar | 10 |  |  |  |  |  | Libelle Court Etablissement
tem_en_sve_etb | bit | 1 |  |  |  |  |  | Temoin Code en Service
lib_web_etb | varchar | 120 | √ |  | null |  |  | Libellé Web
Table contained 7 948 rows at lun. févr. 20 13:02 CET 2017

Indexes:

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

Close relationships within one two degrees of separation: