DocumentWorkspaceConnector

DocumentWorkspaceConnector is a junction table that records the relationship between a Document and the WorkspaceConnector responsible for ingesting or distributing it. Each row captures which connector handled a given document, in which direction (input = ingested from a source, output = routed to a destination), and when the link was created. It is the provenance ledger for the document sync pipeline: every document that enters or leaves Well through a connector has at least one DWC row, and the table is the primary surface queried during sync-status range checks (filtered by workspace_connector_pk + created_at BETWEEN). The entity carries no public UUID key — it is an internal infrastructure join record, not a user-facing resource.

Naming	Value
Object	DocumentWorkspaceConnector
Resource type (JSON:API `type`)	`document_workspace_connector`
Collection / records root	— _{(not a records root)}
REST base	`/v1/document-workspace-connectors`
Entity class	`DocumentWorkspaceConnector`

Internal object. Not currently exposed on the public REST API. The operations below describe the intended contract.

API operations

Operation	Method & path	Status
List	`GET /v1/document-workspace-connectors`	🟡 Planned
Retrieve	`GET /v1/document-workspace-connectors/{id}`	🟡 Planned
Create	`POST /v1/document-workspace-connectors`	🟡 Planned
Update	`PATCH /v1/document-workspace-connectors/{id}`	🟡 Planned
Delete	`DELETE /v1/document-workspace-connectors/{id}`	🟡 Planned

Data model

Attributes

Field	Type	Required	Constraints	Allowed values	Description
direction	string (native enum: direction_enum)	✅ Yes	NOT NULL; stored as PostgreSQL native enum core_api.direction_enum	’input’ \| ‘output’	Flow direction of the document through the connector. ‘input’ means the connector ingested the document into Well (source connector). ‘output’ means Well routed the document outward through the connector (destination connector).
created_at	🔒 system — timestamptz	✅ Yes	NOT NULL; set by onCreate: () => new Date()	—	Timestamp when the DWC link was created. Set once via onCreate hook; also set explicitly by DocumentWorkspaceConnectorService. Used as the right-hand operand in sync-status range queries (indexed via idx_dwc_wc_created_at and idx_dwc_input_active_doc_created).
updated_at	🔒 system — timestamptz	⚪ No	NULLABLE	—	Timestamp of the last mutation. Set by onCreate and onUpdate hooks; also set explicitly by the service methods.
deleted_at	🔒 system — timestamptz	⚪ No	NULLABLE	—	Soft-delete timestamp. NULL means the link is active. Set by application code; never populated by the normal create/stage paths.

Relationships

Name	Type	Required	Description
document	to-one (ManyToOne)	✅ Yes	The Document this connector link is associated with. Foreign key references core_api.documents(pk) ON UPDATE CASCADE. Indexed as the leading column of idx_dwc_input_active_doc_created (document_pk, created_at) for document-first access patterns.
workspaceConnector	to-one (ManyToOne)	✅ Yes	The WorkspaceConnector (activated connector instance for a workspace) that ingested or distributed this document. Foreign key references core_api.workspace_connectors(pk) ON UPDATE CASCADE. Indexed as the leading column of idx_dwc_wc_created_at (workspace_connector_pk, created_at) for sync-status range queries.

System-computed

created_at — set once by onCreate: () => new Date(); also set explicitly to new Date() by DocumentWorkspaceConnectorService.createDocumentWorkspaceConnector() and .stage()
updated_at — set by onCreate and onUpdate hooks; also set explicitly by the service methods
deleted_at — soft-delete sentinel; NULL on creation; not written by the pipeline’s normal create/stage paths
pk — auto-increment serial primary key assigned by Postgres; internal join target only, never exposed in the public API
No public UUID (*_id) column — this is a pure infrastructure junction record with no user-facing stable identifier beyond pk

Example

{
  "data": {
    "type": "document_workspace_connector",
    "attributes": {
      "direction": "input",
      "created_at": "2026-01-15T09:23:11.000Z",
      "updated_at": "2026-01-15T09:23:11.000Z",
      "deleted_at": null
    },
    "relationships": {
      "document": {
        "data": { "type": "document", "id": "e3f1a2b4-cc90-4d5e-b8f7-123456789abc" }
      },
      "workspace_connector": {
        "data": { "type": "workspace_connector", "id": "a9b2c3d4-1111-2222-3333-abcdef012345" }
      }
    }
  }
}

_{Source: apps/api/src/database/entities/DocumentWorkspaceConnector.ts · domain: ingestion · tier: Infrastructure}

Main objects

Supporting objects

Platform objects

Activity objects

Infrastructure objects

API operations

Data model

Attributes

Relationships

System-computed

Example

​API operations

​Data model

​Attributes

​Relationships

​System-computed

​Example

API operations

Data model

Attributes

Relationships

System-computed

Example