databasechangelog


Description

{“what”:“History of database changes applied via Liquibase; one row per execution.”,“why”:“Ensures each change set runs exactly once and provides an audit trail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:44.662751631+00:00”}

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”}

author 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

Relationships