Query

branch.sqlite — local_cash_movements

SQL

CREATE TABLE "local_cash_movements"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_cash_movements" PRIMARY KEY,
  "Amount" INTEGER NOT NULL,
  "CashRegisterSessionId" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "DeletedAt" TEXT NULL,
  "Description" TEXT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "MovementType" TEXT NOT NULL,
  "OccurredAt" TEXT NOT NULL,
  "PosShiftId" TEXT NULL,
  "Reference" TEXT NULL,
  "UpdatedAt" TEXT NOT NULL,
  "UserId" TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
Amount INTEGER Rename | Drop
CashRegisterSessionId TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
DeletedAt TEXT ✓ Rename | Drop
Description TEXT ✓ Rename | Drop
IsDeleted INTEGER Rename | Drop
MovementType TEXT Rename | Drop
OccurredAt TEXT Rename | Drop
PosShiftId TEXT ✓ Rename | Drop
Reference TEXT ✓ Rename | Drop
UpdatedAt TEXT Rename | Drop
UserId TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_local_cash_movements_CashRegisterSessionId CashRegisterSessionId SQL 
CREATE INDEX "IX_local_cash_movements_CashRegisterSessionId"
ON "local_cash_movements" ("CashRegisterSessionId")
Drop
IX_local_cash_movements_MovementType MovementType SQL 
CREATE INDEX "IX_local_cash_movements_MovementType"
ON "local_cash_movements" ("MovementType")
Drop
IX_local_cash_movements_OccurredAt OccurredAt SQL 
CREATE INDEX "IX_local_cash_movements_OccurredAt"
ON "local_cash_movements" ("OccurredAt")
Drop
IX_local_cash_movements_PosShiftId PosShiftId SQL 
CREATE INDEX "IX_local_cash_movements_PosShiftId"
ON "local_cash_movements" ("PosShiftId")
Drop
sqlite_autoindex_local_cash_movements_1 Id ✓ SQL
-- no sql found --
 Drop