Query

branch.sqlite — local_check_lines

SQL

CREATE TABLE "local_check_lines"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_check_lines" PRIMARY KEY,
  "CheckId" TEXT NOT NULL,
  "ProductId" TEXT NOT NULL,
  "ProductName" TEXT NOT NULL,
  "Quantity" INTEGER NOT NULL,
  "UnitPriceMinor" INTEGER NOT NULL,
  "LineDiscountMinor" INTEGER NOT NULL,
  "LineTotalMinor" INTEGER NOT NULL,
  "LineStatus" TEXT NOT NULL,
  "SentBatch" INTEGER NULL,
  "SentAt" TEXT NULL,
  "Notes" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "UpdatedAt" TEXT NOT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "DeletedAt" TEXT NULL,
  "SectionNo" INTEGER NULL,
  "TaxPercent" INTEGER NOT NULL DEFAULT 2000,
  "ComplimentaryReason" TEXT NULL,
  "IsComplimentary" INTEGER NOT NULL DEFAULT 0
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
CheckId TEXT Rename | Drop
ProductId TEXT Rename | Drop
ProductName TEXT Rename | Drop
Quantity INTEGER Rename | Drop
UnitPriceMinor INTEGER Rename | Drop
LineDiscountMinor INTEGER Rename | Drop
LineTotalMinor INTEGER Rename | Drop
LineStatus TEXT Rename | Drop
SentBatch INTEGER ✓ Rename | Drop
SentAt TEXT ✓ Rename | Drop
Notes TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
UpdatedAt TEXT Rename | Drop
IsDeleted INTEGER Rename | Drop
DeletedAt TEXT ✓ Rename | Drop
SectionNo INTEGER ✓ Rename | Drop
TaxPercent INTEGER Rename | Drop
ComplimentaryReason TEXT ✓ Rename | Drop
IsComplimentary INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_local_check_lines_CheckId CheckId SQL 
CREATE INDEX "IX_local_check_lines_CheckId"
ON "local_check_lines" ("CheckId")
Drop
IX_local_check_lines_CheckId_LineStatus
  • CheckId
  • LineStatus
 SQL 
CREATE INDEX "IX_local_check_lines_CheckId_LineStatus"
ON "local_check_lines" ("CheckId", "LineStatus")
Drop
sqlite_autoindex_local_check_lines_1 Id ✓ SQL
-- no sql found --
 Drop