Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.siscol_bac_oux_equ Rérérentiel SiScol : Baccalaureats ou equivalences | Generated by SchemaSpy

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_bac | varchar | 4 |  |  |  |
candidat_bac_ou_equ.cod_bac | fk_bac_ou_equ_siscol_bac_ou_equ_cod_bac R
|  | Code Baccalaureat ou Equivalence
lib_bac | varchar | 40 |  |  |  |  |  | Libelle Long Baccalaureat ou Equivalence
lic_bac | varchar | 10 |  |  |  |  |  | Libelle Court Baccalaureat ou Equivalence
daa_deb_vld_bac | varchar | 4 | √ |  | null |  |  | Date de début de validité du bac
daa_fin_vld_bac | varchar | 4 | √ |  | null |  |  | Date de fin de validité du bac
tem_nat_bac | bit | 1 |  |  |  |  |  | Temoin Nature de Bac
tem_en_sve_bac | bit | 1 |  |  | b'0' |  |  | Témoin en service
tem_ctrl_ine_bac | bit | 1 |  |  | b'0' |  |  | Temoin de controle de l'ine
ann_ctrl_ine_bac | varchar | 4 | √ |  | null |  |  | Annee de controle de l'ine
Table contained 68 rows at ven. juin 01 10:59 CEST 2018

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
cod_bac | Primary key | Asc | PRIMARY

Close relationships within one two degrees of separation: