Query

whatsapp_automation.db — Messages

Add Column

Cancel

Current Schema

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
)