Query

branch.sqlite — local_checks

SQL

CREATE TABLE "local_checks"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_checks" PRIMARY KEY,
  "BilledAt" TEXT NULL,
  "CashRegisterSessionId" TEXT NULL,
  "ChannelCode" TEXT NOT NULL,
  "CheckNo" TEXT NOT NULL,
  "ClosedAt" TEXT NULL,
  "ClosedByUserId" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "DeletedAt" TEXT NULL,
  "DiscountMinor" INTEGER NOT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "Notes" TEXT NULL,
  "OpenedAt" TEXT NOT NULL,
  "OpenedByUserId" TEXT NOT NULL,
  "PaxCount" INTEGER NOT NULL,
  "ServiceAreaId" TEXT NULL,
  "ServiceModeCode" TEXT NOT NULL,
  "ServiceTableId" TEXT NULL,
  "Status" TEXT NOT NULL,
  "SubtotalMinor" INTEGER NOT NULL,
  "TaxMinor" INTEGER NOT NULL,
  "TotalMinor" INTEGER NOT NULL,
  "UpdatedAt" TEXT NOT NULL,
  "SurchargeMinor" INTEGER NOT NULL DEFAULT 0
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
BilledAt TEXT ✓ Rename | Drop
CashRegisterSessionId TEXT ✓ Rename | Drop
ChannelCode TEXT Rename | Drop
CheckNo TEXT Rename | Drop
ClosedAt TEXT ✓ Rename | Drop
ClosedByUserId TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
DeletedAt TEXT ✓ Rename | Drop
DiscountMinor INTEGER Rename | Drop
IsDeleted INTEGER Rename | Drop
Notes TEXT ✓ Rename | Drop
OpenedAt TEXT Rename | Drop
OpenedByUserId TEXT Rename | Drop
PaxCount INTEGER Rename | Drop
ServiceAreaId TEXT ✓ Rename | Drop
ServiceModeCode TEXT Rename | Drop
ServiceTableId TEXT ✓ Rename | Drop
Status TEXT Rename | Drop
SubtotalMinor INTEGER Rename | Drop
TaxMinor INTEGER Rename | Drop
TotalMinor INTEGER Rename | Drop
UpdatedAt TEXT Rename | Drop
SurchargeMinor INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_local_checks_CashRegisterSessionId CashRegisterSessionId SQL 
CREATE INDEX "IX_local_checks_CashRegisterSessionId"
ON "local_checks" ("CashRegisterSessionId")
Drop
IX_local_checks_CheckNo CheckNo ✓ SQL 
CREATE UNIQUE INDEX "IX_local_checks_CheckNo"
ON "local_checks" ("CheckNo")
Drop
IX_local_checks_OpenedAt OpenedAt SQL 
CREATE INDEX "IX_local_checks_OpenedAt"
ON "local_checks" ("OpenedAt")
Drop
IX_local_checks_ServiceAreaId ServiceAreaId SQL 
CREATE INDEX "IX_local_checks_ServiceAreaId"
ON "local_checks" ("ServiceAreaId")
Drop
IX_local_checks_ServiceTableId ServiceTableId SQL 
CREATE INDEX "IX_local_checks_ServiceTableId"
ON "local_checks" ("ServiceTableId")
Drop
IX_local_checks_Status Status SQL 
CREATE INDEX "IX_local_checks_Status"
ON "local_checks" ("Status")
Drop
sqlite_autoindex_local_checks_1 Id ✓ SQL
-- no sql found --
 Drop