Query

branch.sqlite — local_devices

SQL

CREATE TABLE "local_devices"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_devices" PRIMARY KEY,
  "Category" TEXT NOT NULL,
  "Code" TEXT NOT NULL,
  "Name" TEXT NOT NULL,
  "DeviceType" TEXT NOT NULL,
  "ServiceAreaId" TEXT NULL,
  "Usage" TEXT NULL,
  "IpAddress" TEXT NULL,
  "Port" TEXT NULL,
  "Note" TEXT NULL,
  "IsActive" INTEGER NOT NULL,
  "LastSeenAt" TEXT NULL,
  "PrinterRole" TEXT NULL,
  "CopyCount" INTEGER NULL,
  "AutoPrint" INTEGER NULL,
  "ScreenSource" TEXT NULL,
  "KioskPayment" TEXT NULL,
  "KioskMenu" 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
Category TEXT Rename | Drop
Code TEXT Rename | Drop
Name TEXT Rename | Drop
DeviceType TEXT Rename | Drop
ServiceAreaId TEXT ✓ Rename | Drop
Usage TEXT ✓ Rename | Drop
IpAddress TEXT ✓ Rename | Drop
Port TEXT ✓ Rename | Drop
Note TEXT ✓ Rename | Drop
IsActive INTEGER Rename | Drop
LastSeenAt TEXT ✓ Rename | Drop
PrinterRole TEXT ✓ Rename | Drop
CopyCount INTEGER ✓ Rename | Drop
AutoPrint INTEGER ✓ Rename | Drop
ScreenSource TEXT ✓ Rename | Drop
KioskPayment TEXT ✓ Rename | Drop
KioskMenu 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_devices_Category Category SQL 
CREATE INDEX "IX_local_devices_Category"
ON "local_devices" ("Category")
Drop
IX_local_devices_Code Code ✓ SQL 
CREATE UNIQUE INDEX "IX_local_devices_Code"
ON "local_devices" ("Code")
Drop
IX_local_devices_IsActive IsActive SQL 
CREATE INDEX "IX_local_devices_IsActive"
ON "local_devices" ("IsActive")
Drop
IX_local_devices_ServiceAreaId ServiceAreaId SQL 
CREATE INDEX "IX_local_devices_ServiceAreaId"
ON "local_devices" ("ServiceAreaId")
Drop
sqlite_autoindex_local_devices_1 Id ✓ SQL
-- no sql found --
 Drop