Query

database.sqlite — test_run

+/- table definition

Query 

CREATE TABLE "test_run"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "workflowId" varchar(36) NOT NULL,
  "status" varchar NOT NULL,
  "errorCode" varchar,
  "errorDetails" text,
  "runAt" datetime(3),
  "completedAt" datetime(3),
  "metrics" 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 "FK_d6870d3b6e4c185d33926f423c8" FOREIGN KEY ("workflowId") REFERENCES "workflow_entity" ("id") ON DELETE CASCADE
)
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