Create
Query
pilot.db
—
services
account_invites
accounts
applied_migrations
audit_log
availability
availability_exceptions
bookings
campaign_leads
campaign_offers
campaigns
cards
commission_rates
commission_runs
drills_library
invoices
magic_tokens
offers
practice_logs
quotes
saas_invoices
service_student_prices
services
sessions
sqlite_sequence
student_summaries
students
subscription_events
trainer_settings
trainers
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 22 in services
id
Primary key.
INTEGER
trainer_id
INTEGER NOT NULL
label
Schnupperkurs
TEXT NOT NULL
duration_min
INTEGER
price_cents
INTEGER NOT NULL (default 0
unit
Std
TEXT NOT NULL (default 'Std'
category
trial
TEXT NOT NULL (default 'lesson'
is_card_redemption
INTEGER NOT NULL (default 0
active
INTEGER NOT NULL (default 1
sort_order
INTEGER NOT NULL (default 0
created_at
2026-08-18 08:46:58
TEXT NOT NULL (default datetime('now')
updated_at
2026-08-18 08:46:58
TEXT NOT NULL (default datetime('now')
units
INTEGER
is_trial
INTEGER NOT NULL (default 0
Update
Cancel