Query

branch.sqlite — local_check_line_canc...

SQL

CREATE TABLE "local_check_line_cancellations"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_check_line_cancellations" PRIMARY KEY,
  "CheckId" TEXT NOT NULL,
  "CheckLineId" TEXT NOT NULL,
  "Quantity" INTEGER NOT NULL,
  "ReasonCode" TEXT NOT NULL,
  "ReasonText" TEXT NULL,
  "Status" TEXT NOT NULL,
  "CancelledByUserId" TEXT NOT NULL,
  "CancelledAt" TEXT NOT NULL,
  "ReversedAt" TEXT NULL,
  "ReversedByUserId" TEXT NULL,
  "ReverseReason" 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
CheckId TEXT Rename | Drop
CheckLineId TEXT Rename | Drop
Quantity INTEGER Rename | Drop
ReasonCode TEXT Rename | Drop
ReasonText TEXT ✓ Rename | Drop
Status TEXT Rename | Drop
CancelledByUserId TEXT Rename | Drop
CancelledAt TEXT Rename | Drop
ReversedAt TEXT ✓ Rename | Drop
ReversedByUserId TEXT ✓ Rename | Drop
ReverseReason 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_line_cancellations_CancelledAt CancelledAt SQL 
CREATE INDEX "IX_local_check_line_cancellations_CancelledAt"
ON "local_check_line_cancellations" ("CancelledAt")
Drop
IX_local_check_line_cancellations_CheckId CheckId SQL 
CREATE INDEX "IX_local_check_line_cancellations_CheckId"
ON "local_check_line_cancellations" ("CheckId")
Drop
IX_local_check_line_cancellations_CheckLineId_Status
  • CheckLineId
  • Status
 SQL 
CREATE INDEX "IX_local_check_line_cancellations_CheckLineId_Status"
ON "local_check_line_cancellations" ("CheckLineId", "Status")
Drop
sqlite_autoindex_local_check_line_cancellations_1 Id ✓ SQL
-- no sql found --
 Drop