Create
Query
mira.db
—
transactions
access_codes
balances
event_attachments
events
identities
profiles
room_boardings
rooms
sessions
settings
transactions
users
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into transactions
id
Primary key.
TEXT
user_id
TEXT NOT NULL
scanned_by
TEXT NOT NULL
amount
INTEGER NOT NULL (default -1)
created_at
INTEGER NOT NULL (default unixepoch())
Insert
Cancel