Query

branch.sqlite — local_check_lines

+/- table definition

Query 

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
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop