Create
Query
branch.sqlite
—
local_terminal_transa...
__EFMigrationsHistory
__EFMigrationsLock
local_audit_log
local_branch_info
local_cash_movements
local_cash_register_s...
local_cash_registers
local_categories
local_check_adjustments
local_check_lines
local_check_status_history
local_checks
local_discount_reasons
local_inventory_docum...
local_inventory_documents
local_payment_lines
local_pos_devices
local_pos_shifts
local_products
local_recipe_lines
local_recipes
local_service_areas
local_service_tables
local_stock
local_stock_movements
local_terminal_transa...
local_units_of_measure
local_users
local_warehouses
sync_inbox
sync_log
sync_outbox
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into local_terminal_transactions
Id
Primary key.
TEXT NOT NULL
TerminalId
TEXT NOT NULL
ProviderName
TEXT NOT NULL
Direction
TEXT NOT NULL
Status
TEXT NOT NULL
AmountMinor
INTEGER NOT NULL
ActualAmountMinor
INTEGER
BasketId
TEXT
CheckId
TEXT
PaymentLineId
TEXT
OriginalProviderRef
TEXT
AuthCode
TEXT
MaskedPan
TEXT
CardScheme
TEXT
ProviderRef
TEXT
RawRequest
TEXT
RawResponse
TEXT
FailureReason
TEXT
UserId
TEXT
SentAt
TEXT NOT NULL
CompletedAt
TEXT
CreatedAt
TEXT NOT NULL
UpdatedAt
TEXT NOT NULL
IsDeleted
INTEGER NOT NULL
DeletedAt
TEXT
Insert
Cancel