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')),
CONSTRAINT "CHK_workflow_publication_outbox_status" CHECK ("status" IN ('pending', 'in_progress', 'completed', 'partial_success', 'failed'))
)