Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.alert_sva table des couleurs d'alertes SVA | 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
--- | --- | --- | --- | --- | --- | --- | --- | ---
id_sva | int | 10 |  | √ |  |  |  | identifiant alerte sva
nb_jour_sva | int | 10 |  |  |  |  |  | nombre de jour sur laquelle l'alerte SVA aura effet
color_sva | varchar | 20 |  |  |  |  |  | couleur de l'alerte (code hexa)
tes_sva | bit | 1 |  |  |  |  |  | témoin en service
Table contained 7 rows at lun. févr. 20 13:02 CET 2017

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id_sva | Primary key | Asc | PRIMARY
nb_jour_sva | Must be unique | Asc | nb_jour_sva