WorkspaceConnectorSyncTarget

​

API operations

​

Data model

​

Attributes

​

Relationships

​

System-computed

• pk — auto-increment SERIAL primary key assigned by PostgreSQL on INSERT; never exposed as a public UUID. The formatter surfaces String(row.pk) as the JSON:API id field because this junction has no dedicated *_id UUID column by design — consumers are expected to reference targets by their (workspace_connector_id, target_workspace_id) tuple.
• created_at — stamped once on INSERT by MikroORM onCreate: () => new Date().
• updated_at — stamped on INSERT and on every subsequent UPDATE by MikroORM onUpdate: () => new Date().
• deleted_at — set to the current timestamp by WorkspaceConnectorSyncTargetService when a target is removed via the PUT set-semantics diff; set to NULL (re-add) when a soft-deleted row is reactivated. Never set by the connector sync pipeline directly.
• Backfill rows — the creation migration (Migration20260527140000) inserts one row per active WorkspaceConnector pointing at its own carrier workspace with created_by_pk = NULL, preserving pre-feature 1:1 behaviour for legacy connectors without any code change.
• Partial unique index idx_wcst_unique_active — enforced by PostgreSQL: UNIQUE (workspace_connector_pk, target_workspace_pk) WHERE deleted_at IS NULL. Guarantees at most one active target per (connector, workspace) pair; soft-deleted tombstones are excluded so a re-add is always safe.

​

Example

{
  "data": {
    "type": "workspaceConnectorSyncTarget",
    "id": "4182",
    "attributes": {
      "created_at": "2026-05-27T14:12:33.000Z",
      "updated_at": "2026-05-27T14:12:33.000Z"
    },
    "relationships": {
      "workspace_connector": {
        "data": {
          "type": "workspaceConnector",
          "id": "wc_01hwzgq3pk8f0qb3cns7x4ye2t"
        }
      },
      "target_workspace": {
        "data": {
          "type": "workspace",
          "id": "ws_01hwzgq3pk8f0qb3cns7x4ye2t"
        }
      },
      "created_by": {
        "data": {
          "type": "people",
          "id": "ppl_01hwzgq3pk8f0qb3cns7x4ye2t"
        }
      }
    }
  }
}