TransactionWorkspaceConnector

​

API operations

​

Data model

​

Attributes

​

Relationships

​

System-computed

• pk — serial integer primary key, internal only, never exposed on the public API
• created_at — set to new Date() on insert via MikroORM onCreate hook; never user-writable
• updated_at — set to new Date() on insert and on every update via MikroORM onCreate + onUpdate hooks; null until first update
• deleted_at — null on creation; written by application code for soft-delete; never hard-deleted
• No transaction_workspace_connector_id UUID field is present on this entity — it uses only the internal serial pk (junction tables in this codebase omit the public *_id UUID unless externally referenced)
• Rows are written exclusively by the connector sync pipeline (input direction) or by egress sync writers (output direction, iteration 4+); no user-facing PATCH route exists
• Migration20260507000000 backfilled historical input rows from legacy entity.source_workspace_connector_pk values using an idempotent INSERT…SELECT NOT EXISTS guard; idempotency is NOT enforced by a UNIQUE constraint — no UNIQUE on (transaction_pk, workspace_connector_pk, direction) was shipped by design (deduplication is iteration 3+ work)
• Two covering B-tree indexes ship with the table: idx_transaction_workspace_connectors_record_created on (transaction_pk, created_at) for record-led traversals; idx_transaction_workspace_connectors_wc_created_at on (workspace_connector_pk, created_at) for sync-status range queries

​

Example

{
  "data": {
    "type": "transaction_workspace_connector",
    "id": "a3f92c01-4e5b-47dc-9a13-001b8e2d7f44",
    "attributes": {
      "direction": "input",
      "created_at": "2026-05-07T14:23:11.000Z",
      "updated_at": "2026-05-07T14:23:11.000Z",
      "deleted_at": null
    },
    "relationships": {
      "transaction": {
        "data": { "type": "transaction", "id": "f1d3c8a2-0011-4bcd-8f2e-ab91c42e7001" }
      },
      "workspace_connector": {
        "data": { "type": "workspace_connector", "id": "9b2a5d3e-ccf1-4a89-b027-0f3d1e7c8a55" }
      }
    }
  }
}