Create
Query
pilot.db
—
bookings
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
Insert row into bookings
trainer_id
INTEGER NOT NULL
student_id
INTEGER NOT NULL
service_key
TEXT NOT NULL
starts_at
TEXT NOT NULL
duration_min
INTEGER NOT NULL
card_id
INTEGER
invoice_id
INTEGER
video_analysis
TEXT
notes
TEXT
status
TEXT NOT NULL (default 'confirmed')
created_at
TEXT NOT NULL (default datetime('now'))
protocol
TEXT
protocol_approved_at
TEXT
confirmation_sent_at
TEXT
reminder_sent_at
TEXT
cancellation_sent_at
TEXT
video_unlocked_at
TEXT
video_invoice_id
INTEGER
swing_metrics
TEXT
student_note
TEXT
Insert
Cancel