Table ttk.public.schema_version
Flyway-työkalun käyttämä aputaulu tietokantamuutosten kirjanpitoon.

 Generated by
SchemaSpy
Legend: SourceForge.net
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
version_rank int4 10
installed_rank int4 10
version varchar 50
description varchar 200
type varchar 20
script varchar 1000
checksum int4 10  √  null
installed_by varchar 100
installed_on timestamp 29,6 now()
execution_time int4 10
success bool 1

Table contained 148 rows at Tue Feb 20 12:38 UTC 2018

Indexes:
Column(s) Type Sort Constraint Name
version Primary key Asc schema_version_pk
installed_rank Performance Asc schema_version_ir_idx
success Performance Asc schema_version_s_idx
version_rank Performance Asc schema_version_vr_idx