Query

whatsapp_automation.db — Messages

+/- table definition

Query 

CREATE TABLE "Messages"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_Messages" PRIMARY KEY,
  "SessionId" TEXT NOT NULL,
  "ChatId" TEXT NOT NULL,
  "FromNumber" TEXT NULL,
  "ToNumber" TEXT NULL,
  "Content" TEXT NOT NULL,
  "Type" INTEGER NOT NULL,
  "Direction" INTEGER NOT NULL,
  "Status" INTEGER NOT NULL,
  "Timestamp" TEXT NOT NULL,
  "MessageId" TEXT NULL,
  "ErrorMessage" TEXT NULL,
  "SentBy" INTEGER NOT NULL,
  CONSTRAINT "FK_Messages_Sessions_SessionId" FOREIGN KEY ("SessionId") REFERENCES "Sessions" ("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 view : create view : drop