Query

branch.sqlite — local_payment_lines

SQL

CREATE TABLE "local_payment_lines"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_payment_lines" PRIMARY KEY,
  "Amount" INTEGER NOT NULL,
  "AuthCode" TEXT NULL,
  "CardScheme" TEXT NULL,
  "CheckId" TEXT NOT NULL,
  "CheckLineId" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "DeletedAt" TEXT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "MaskedPan" TEXT NULL,
  "Method" TEXT NOT NULL,
  "Notes" TEXT NULL,
  "OccurredAt" TEXT NOT NULL,
  "ProviderRef" TEXT NULL,
  "Reference" TEXT NULL,
  "Status" TEXT NOT NULL,
  "TerminalId" TEXT NULL,
  "UpdatedAt" TEXT NOT NULL,
  "UserId" TEXT NOT NULL,
  "VoidReason" TEXT NULL,
  "VoidedAt" TEXT NULL,
  "VoidedByUserId" TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
Amount INTEGER Rename | Drop
AuthCode TEXT ✓ Rename | Drop
CardScheme TEXT ✓ Rename | Drop
CheckId TEXT Rename | Drop
CheckLineId TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
DeletedAt TEXT ✓ Rename | Drop
IsDeleted INTEGER Rename | Drop
MaskedPan TEXT ✓ Rename | Drop
Method TEXT Rename | Drop
Notes TEXT ✓ Rename | Drop
OccurredAt TEXT Rename | Drop
ProviderRef TEXT ✓ Rename | Drop
Reference TEXT ✓ Rename | Drop
Status TEXT Rename | Drop
TerminalId TEXT ✓ Rename | Drop
UpdatedAt TEXT Rename | Drop
UserId TEXT Rename | Drop
VoidReason TEXT ✓ Rename | Drop
VoidedAt TEXT ✓ Rename | Drop
VoidedByUserId TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_local_payment_lines_CheckId_Status
  • CheckId
  • Status
 SQL 
CREATE INDEX "IX_local_payment_lines_CheckId_Status"
ON "local_payment_lines" ("CheckId", "Status")
Drop
IX_local_payment_lines_CheckLineId CheckLineId SQL 
CREATE INDEX "IX_local_payment_lines_CheckLineId"
ON "local_payment_lines" ("CheckLineId")
Drop
IX_local_payment_lines_Method Method SQL 
CREATE INDEX "IX_local_payment_lines_Method"
ON "local_payment_lines" ("Method")
Drop
IX_local_payment_lines_OccurredAt OccurredAt SQL 
CREATE INDEX "IX_local_payment_lines_OccurredAt"
ON "local_payment_lines" ("OccurredAt")
Drop
IX_local_payment_lines_ProviderRef ProviderRef SQL 
CREATE INDEX "IX_local_payment_lines_ProviderRef"
ON "local_payment_lines" ("ProviderRef")
Drop
IX_local_payment_lines_Status Status SQL 
CREATE INDEX "IX_local_payment_lines_Status"
ON "local_payment_lines" ("Status")
Drop
IX_local_payment_lines_TerminalId TerminalId SQL 
CREATE INDEX "IX_local_payment_lines_TerminalId"
ON "local_payment_lines" ("TerminalId")
Drop
sqlite_autoindex_local_payment_lines_1 Id ✓ SQL
-- no sql found --
 Drop