+/- table definition

Query

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
)
Use Shift + Up/Down to navigate recently-executed queries