workspace_merge_transform


Description

Tracks individual transform merges. Linked to workspace_merge for batch merges, standalone for single-transform merges.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Unique numeric identifier for this merge-transform record.”,“why”:“Provides a stable key for referencing the record in other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:11.372364355+00:00”}

workspace_merge_id int4 10 null
workspace_merge.id fk_workspace_merge_transform_workspace_merge_id C

{“what”:“Identifier of the merge operation this transform was part of.”,“why”:“Links the transform application to the specific merge event it belongs to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:11.386044375+00:00”}

workspace_id int4 10 √ null
workspace.id fk_workspace_merge_transform_workspace_id N

{“what”:“Identifier of the workspace being merged, if known.”,“why”:“Allows filtering merge-transform records by workspace even when the workspace name changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:11.406405177+00:00”}

workspace_name text 2147483647 null

{“what”:“Name of the workspace at the time of the merge.”,“why”:“Preserves the workspace name snapshot for audit, since workspace_id may be null or renamed later.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:11.424721651+00:00”}

transform_id int4 10 √ null
transform.id fk_workspace_merge_transform_transform_id C

{“what”:“Identifier of the transform applied during the merge.”,“why”:“Identifies which transform was used; null if no transform was applied.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:11.435695052+00:00”}

commit_message text 2147483647 null

{“what”:“Commit message associated with the merge-transform action.”,“why”:“Records the user-provided description of the change for history and review.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:11.445539171+00:00”}

merging_user_id int4 10 null
core_user.id fk_workspace_merge_transform_merging_user_id R

{“what”:“Identifier of the user who performed the merge.”,“why”:“Attributes the action to a user for accountability and audit trails.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:11.455240232+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the merge-transform record was created.”,“why”:“Provides chronological ordering and time-based filtering of merge-transform events.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:11.473296732+00:00”}

Indexes

Constraint Name Type Sort Column(s)
workspace_merge_transform_pkey Primary key Asc id
idx_workspace_merge_transform_merging_user_id Performance Asc merging_user_id
idx_workspace_merge_transform_transform_id Performance Asc transform_id
idx_workspace_merge_transform_workspace_id Performance Asc workspace_id
idx_workspace_merge_transform_workspace_merge_id Performance Asc workspace_merge_id

Relationships