workflow_publication_outbox¶

Description¶

Table Definition

CREATE TABLE "workflow_publication_outbox" ("id" integer PRIMARY KEY NOT NULL, "workflowId" varchar(36) NOT NULL, "publishedVersionId" varchar(36) NOT NULL, "status" varchar(20) NOT NULL, "errorMessage" text, "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "reason" varchar(20) NOT NULL DEFAULT ('publish'), CONSTRAINT "CHK_workflow_publication_outbox_status" CHECK (("status" IN ('pending', 'in_progress', 'completed', 'partial_success', 'failed'))), CONSTRAINT "CHK_workflow_publication_outbox_reason" CHECK ("reason" IN ('publish', 'startup', 'leadership-takeover', 'reconcile')))

Columns¶

Name	Type	Default	Nullable
createdAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false
errorMessage	TEXT		true
id	INTEGER		false
publishedVersionId	varchar(36)		false
reason	varchar(20)	'publish'	false
status	varchar(20)		false
updatedAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false
workflowId	varchar(36)		false

Constraints¶

Name	Type	Definition
-	CHECK	CHECK (("status" IN ('pending', 'in_progress', 'completed', 'partial_success', 'failed')))
-	CHECK	CHECK ("reason" IN ('publish', 'startup', 'leadership-takeover', 'reconcile'))
id	PRIMARY KEY	PRIMARY KEY (id)

Indexes¶

Name	Definition
IDX_workflow_publication_outbox_active_workflow_status	CREATE UNIQUE INDEX "IDX_workflow_publication_outbox_active_workflow_status" ON "workflow_publication_outbox" ("workflowId", "status") WHERE status IN ('pending', 'in_progress')

Relations¶

erDiagram


"workflow_publication_outbox" {
  datetime_3_ createdAt
  TEXT errorMessage
  INTEGER id
  varchar_36_ publishedVersionId
  varchar_20_ reason
  varchar_20_ status
  datetime_3_ updatedAt
  varchar_36_ workflowId
}

Generated by tbls