workspace_merge


Description

{“what”:“Log of workspace merge operations, one row per merge.”,“why”:“Tracks merge history for audit and rollback decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:01.603883759+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
workspace_merge_transform.workspace_merge_id fk_workspace_merge_transform_workspace_merge_id C

{“what”:“Unique merge event identifier; primary key.”,“why”:“Uniquely identifies each merge for referencing in logs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:01.620650038+00:00”}

workspace_id int4 10 √ null
workspace.id fk_workspace_merge_workspace_id N

{“what”:“ID of the workspace being merged into; null if workspace deleted.”,“why”:“Links merge to workspace; null preserves history if workspace removed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:01.639584803+00:00”}

workspace_name text 2147483647 null

{“what”:“Workspace name at merge time; denormalized copy.”,“why”:“Keeps name searchable even if workspace renamed or deleted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:01.663715868+00:00”}

commit_message text 2147483647 null

{“what”:“User-supplied message describing the merge.”,“why”:“Provides context for why merge was done; used in audit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:01.683395330+00:00”}

creator_id int4 10 null
core_user.id fk_workspace_merge_creator_id R

{“what”:“User ID who performed the merge.”,“why”:“Attributes merge to a user for accountability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:01.697520574+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when merge was recorded, timezone-aware.”,“why”:“Orders merges chronologically; supports time-based queries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:01.720489436+00:00”}

Indexes

Constraint Name Type Sort Column(s)
workspace_merge_pkey Primary key Asc id
idx_workspace_merge_creator_id Performance Asc creator_id
idx_workspace_merge_workspace_id Performance Asc workspace_id

Relationships