Create
Query
pilot.db
—
cards
account_invites
accounts
applied_migrations
audit_log
availability
availability_exceptions
bookings
cards
invoices
magic_tokens
sessions
sqlite_sequence
students
trainer_settings
trainers
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 7 in cards
id
Primary key.
INTEGER
trainer_id
INTEGER NOT NULL
student_id
INTEGER NOT NULL
card_type
10er
TEXT NOT NULL
total_units
INTEGER NOT NULL
used_units
INTEGER NOT NULL (default 0
price_cents
INTEGER NOT NULL
purchase_date
2026-05-12
TEXT NOT NULL
expires_date
2027-05-12
TEXT
status
active
TEXT NOT NULL (default 'active'
created_at
2026-06-26 13:44:24
TEXT NOT NULL (default datetime('now')
Update
Cancel