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 |
|
|
{“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 |
|
|
{“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 |
|
|
{“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 |
|
|
{“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 |