Query

branch.sqlite — local_terminal_transa...

SQL

CREATE TABLE "local_terminal_transactions"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_terminal_transactions" PRIMARY KEY,
  "TerminalId" TEXT NOT NULL,
  "ProviderName" TEXT NOT NULL,
  "Direction" TEXT NOT NULL,
  "Status" TEXT NOT NULL,
  "AmountMinor" INTEGER NOT NULL,
  "ActualAmountMinor" INTEGER NULL,
  "BasketId" TEXT NULL,
  "CheckId" TEXT NULL,
  "PaymentLineId" TEXT NULL,
  "OriginalProviderRef" TEXT NULL,
  "AuthCode" TEXT NULL,
  "MaskedPan" TEXT NULL,
  "CardScheme" TEXT NULL,
  "ProviderRef" TEXT NULL,
  "RawRequest" TEXT NULL,
  "RawResponse" TEXT NULL,
  "FailureReason" TEXT NULL,
  "UserId" TEXT NULL,
  "SentAt" TEXT NOT NULL,
  "CompletedAt" TEXT 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
TerminalId TEXT Rename | Drop
ProviderName TEXT Rename | Drop
Direction TEXT Rename | Drop
Status TEXT Rename | Drop
AmountMinor INTEGER Rename | Drop
ActualAmountMinor INTEGER ✓ Rename | Drop
BasketId TEXT ✓ Rename | Drop
CheckId TEXT ✓ Rename | Drop
PaymentLineId TEXT ✓ Rename | Drop
OriginalProviderRef TEXT ✓ Rename | Drop
AuthCode TEXT ✓ Rename | Drop
MaskedPan TEXT ✓ Rename | Drop
CardScheme TEXT ✓ Rename | Drop
ProviderRef TEXT ✓ Rename | Drop
RawRequest TEXT ✓ Rename | Drop
RawResponse TEXT ✓ Rename | Drop
FailureReason TEXT ✓ Rename | Drop
UserId TEXT ✓ Rename | Drop
SentAt TEXT Rename | Drop
CompletedAt TEXT ✓ 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_terminal_transactions_CheckId CheckId SQL 
CREATE INDEX "IX_local_terminal_transactions_CheckId"
ON "local_terminal_transactions" ("CheckId")
Drop
IX_local_terminal_transactions_PaymentLineId PaymentLineId SQL 
CREATE INDEX "IX_local_terminal_transactions_PaymentLineId"
ON "local_terminal_transactions" ("PaymentLineId")
Drop
IX_local_terminal_transactions_ProviderRef ProviderRef SQL 
CREATE INDEX "IX_local_terminal_transactions_ProviderRef"
ON "local_terminal_transactions" ("ProviderRef")
Drop
IX_local_terminal_transactions_Status Status SQL 
CREATE INDEX "IX_local_terminal_transactions_Status"
ON "local_terminal_transactions" ("Status")
Drop
IX_local_terminal_transactions_TerminalId_SentAt
  • TerminalId
  • SentAt
 SQL 
CREATE INDEX "IX_local_terminal_transactions_TerminalId_SentAt"
ON "local_terminal_transactions" ("TerminalId", "SentAt" DESC)
Drop
sqlite_autoindex_local_terminal_transactions_1 Id ✓ SQL
-- no sql found --
 Drop