Query

branch.sqlite — local_check_status_history

SQL

CREATE TABLE "local_check_status_history"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_check_status_history" PRIMARY KEY,
  "TargetEntityId" TEXT NOT NULL,
  "FromStatus" TEXT NOT NULL,
  "ToStatus" TEXT NOT NULL,
  "ChangedByUserId" TEXT NOT NULL,
  "ChangedAt" TEXT NOT NULL,
  "Reason" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "UpdatedAt" TEXT NOT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "DeletedAt" TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
TargetEntityId TEXT Rename | Drop
FromStatus TEXT Rename | Drop
ToStatus TEXT Rename | Drop
ChangedByUserId TEXT Rename | Drop
ChangedAt TEXT Rename | Drop
Reason TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
UpdatedAt TEXT Rename | Drop
IsDeleted INTEGER Rename | Drop
DeletedAt TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_local_check_status_history_ChangedAt ChangedAt SQL 
CREATE INDEX "IX_local_check_status_history_ChangedAt"
ON "local_check_status_history" ("ChangedAt")
Drop
IX_local_check_status_history_TargetEntityId TargetEntityId SQL 
CREATE INDEX "IX_local_check_status_history_TargetEntityId"
ON "local_check_status_history" ("TargetEntityId")
Drop
sqlite_autoindex_local_check_status_history_1 Id ✓ SQL
-- no sql found --
 Drop