Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table ecandidat.schema_version Version du schema de base de données | 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
--- | --- | --- | --- | --- | --- | --- | --- | ---
installed_rank | int | 10 |  |  |  |  |  | Identifiant de l'installation
version | varchar | 50 | √ |  | null |  |  |
description | varchar | 200 |  |  |  |  |  | Description de la version
type | varchar | 20 |  |  |  |  |  | Type de version
script | varchar | 1000 |  |  |  |  |  | Nom du script
checksum | int | 10 | √ |  | null |  |  | Checksum du script
installed_by | varchar | 100 |  |  |  |  |  | Utilisateur installant la version
installed_on | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  | Date d'installation
execution_time | int | 10 |  |  |  |  |  | Temps d'execution de mise à jour
success | bit | 0 |  |  |  |  |  | Témoin de réussite
Table contained 17 rows at ven. juin 01 10:59 CEST 2018

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
installed_rank | Primary key | Asc | PRIMARY
success | Performance | Asc | schema_version_s_idx