Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | varchar | 255 | null |
|
|
{“what”:“Change set identifier, e.g., ‘1’ or ‘create-table’.”,“why”:“Uniquely identifies a change set within a file for tracking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:44.703490771+00:00”} |
||
| varchar | 255 | null |
|
|
{“what”:“Name of the change set author.”,“why”:“Part of the unique key (id+author+filename) to distinguish same IDs from different authors.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:44.809493543+00:00”} |
|||
| filename | varchar | 255 | null |
|
|
{“what”:“Path to the changelog file containing the change set.”,“why”:“Identifies the source file, part of the unique key.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:44.857166031+00:00”} |
||
| dateexecuted | timestamp | 29,6 | null |
|
|
{“what”:“Timestamp when the change was applied.”,“why”:“Shows when each change was applied for audit and rollback ordering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:44.887161955+00:00”} |
||
| orderexecuted | int4 | 10 | null |
|
|
{“what”:“Sequential integer order of execution across all changes.”,“why”:“Preserves the order changes were applied, needed for rollback.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:45.157575729+00:00”} |
||
| exectype | varchar | 10 | null |
|
|
{“what”:“Execution status, e.g., EXECUTED, FAILED, RERAN.”,“why”:“Indicates whether the change was applied successfully or needs attention.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:45.180450480+00:00”} |
||
| md5sum | varchar | 35 | √ | null |
|
|
{“what”:“MD5 checksum of the change set content.”,“why”:“Detects if a change set was modified after being applied.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:45.196657176+00:00”} |
|
| description | varchar | 255 | √ | null |
|
|
{“what”:“Short description of the change set’s purpose.”,“why”:“Provides human-readable context for what the change does.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:45.220750353+00:00”} |
|
| comments | varchar | 255 | √ | null |
|
|
{“what”:“Free-form comments from the change set.”,“why”:“Adds extra context for developers and auditors.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:45.234581532+00:00”} |
|
| tag | varchar | 255 | √ | null |
|
|
{“what”:“Tag name assigned to the change set.”,“why”:“Allows marking rollback points or release versions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:45.253312329+00:00”} |
|
| liquibase | varchar | 20 | √ | null |
|
|
{“what”:“Liquibase version that executed the change.”,“why”:“Tracks tool version for compatibility and debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:45.271525301+00:00”} |
|
| contexts | varchar | 255 | √ | null |
|
|
{“what”:“Comma-separated contexts where the change set runs.”,“why”:“Filters which changes apply to which environments.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:45.320363325+00:00”} |
|
| labels | varchar | 255 | √ | null |
|
|
{“what”:“Comma-separated labels for the change set.”,“why”:“Provides another filtering mechanism for execution.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:45.334661478+00:00”} |
|
| deployment_id | varchar | 10 | √ | null |
|
|
{“what”:“Identifier for the deployment run that applied the change.”,“why”:“Groups changes applied in a single deployment for tracking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:45.514245251+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| idx_databasechangelog_id_author_filename | Must be unique | Asc/Asc/Asc | id + author + filename |