AccountWorkspaceConnector

​

API operations

​

Data model

​

Attributes

​

Relationships

​

System-computed

• pk — auto-increment serial primary key, internal only; never exposed on the public API.
• created_at — set automatically via MikroORM onCreate hook (and Postgres default now()); not writable after insert.
• updated_at — set automatically via MikroORM onCreate and onUpdate hooks; updated on every flush.
• deleted_at — populated exclusively by soft-delete logic in the sync pipeline; no user-initiated deletion path.
• direction — written at row creation time by the connector sync orchestrator based on the connector’s role; never changed after insert.
• No workspace_pk column: tenant scope is resolved by traversing the account → workspace or workspaceConnector → workspace relationship, consistent with the document_workspace_connectors design precedent.
• No UNIQUE constraint on (account_pk, workspace_connector_pk, direction) — duplicate rows are allowed by design in the current schema; deduplication is deferred to iteration 3+ per migration comments.
• No external_id field — external object identity is deferred to a future iteration; this table records the connector pointer only.
• Rows are created exclusively by the connector sync pipeline (connector sync writer). There is no resource PATCH endpoint for this entity.

​

Example

{
  "data": {
    "type": "account_workspace_connector",
    "id": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
    "attributes": {
      "direction": "input",
      "created_at": "2026-05-10T08:14:22.000Z",
      "updated_at": "2026-05-10T08:14:22.000Z",
      "deleted_at": null
    },
    "relationships": {
      "account": {
        "data": { "type": "account", "id": "a1b2c3d4-0000-0000-0000-000000000001" }
      },
      "workspace_connector": {
        "data": { "type": "workspace_connector", "id": "d4c3b2a1-0000-0000-0000-000000000002" }
      }
    }
  }
}