Query

branch.sqlite — local_service_tables

SQL

CREATE TABLE "local_service_tables"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_service_tables" PRIMARY KEY,
  "ServiceAreaId" TEXT NOT NULL,
  "TableNo" TEXT NOT NULL,
  "Capacity" INTEGER NOT NULL,
  "TableStatus" TEXT NOT NULL,
  "IsActive" INTEGER NOT NULL,
  "SortOrder" INTEGER NOT 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
ServiceAreaId TEXT Rename | Drop
TableNo TEXT Rename | Drop
Capacity INTEGER Rename | Drop
TableStatus TEXT Rename | Drop
IsActive INTEGER Rename | Drop
SortOrder INTEGER 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_service_tables_ServiceAreaId ServiceAreaId SQL 
CREATE INDEX "IX_local_service_tables_ServiceAreaId"
ON "local_service_tables" ("ServiceAreaId")
Drop
IX_local_service_tables_ServiceAreaId_TableNo
  • ServiceAreaId
  • TableNo
 ✓ SQL 
CREATE UNIQUE INDEX "IX_local_service_tables_ServiceAreaId_TableNo"
ON "local_service_tables" ("ServiceAreaId", "TableNo")
Drop
IX_local_service_tables_TableStatus TableStatus SQL 
CREATE INDEX "IX_local_service_tables_TableStatus"
ON "local_service_tables" ("TableStatus")
Drop
sqlite_autoindex_local_service_tables_1 Id ✓ SQL
-- no sql found --
 Drop