Query

avatarai.db — OutboundMessages

SQL

CREATE TABLE "OutboundMessages"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_OutboundMessages" PRIMARY KEY,
  "AvatarId" TEXT NOT NULL,
  "ToNumber" TEXT NOT NULL,
  "Message" TEXT NOT NULL,
  "Status" TEXT NOT NULL,
  "CreatedAt" TEXT NOT NULL,
  "SentAt" TEXT NULL,
  "ErrorMessage" TEXT NULL,
  "SessionId" TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
AvatarId TEXT Rename | Drop
ToNumber TEXT Rename | Drop
Message TEXT Rename | Drop
Status TEXT Rename | Drop
CreatedAt TEXT Rename | Drop
SentAt TEXT ✓ Rename | Drop
ErrorMessage TEXT ✓ Rename | Drop
SessionId TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_OutboundMessages_1 Id ✓ SQL
-- no sql found --
 Drop