Query

database.sqlite — workflow_publication_...

+/- table definition

Query 

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'))
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop