Create
Query
pilot.db
—
students
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 students
trainer_id
INTEGER NOT NULL
name
TEXT NOT NULL
email
TEXT
phone
TEXT
hcpi
REAL
tags
TEXT NOT NULL (default '[]')
marketing_consent
INTEGER NOT NULL (default 0)
video_consent
INTEGER NOT NULL (default 0)
video_consent_date
TEXT
notes
TEXT
created_at
TEXT NOT NULL (default datetime('now'))
status
TEXT NOT NULL (default 'active')
birthday
TEXT
member_since
TEXT
home_club
TEXT
source
TEXT
contact_channel
TEXT
prefs
TEXT
video_consent_granted_at
TEXT
example_note
TEXT
address
TEXT
calendar_token
TEXT
password_hash
TEXT
activation_token
TEXT
activation_expires_at
TEXT
activated_at
TEXT
password_reset_token
TEXT
password_reset_expires_at
TEXT
payment_method
TEXT
payment_notes
TEXT
marketing_consent_at
TEXT
marketing_consent_source
TEXT
marketing_token
TEXT
privacy_accepted_at
TEXT
Insert
Cancel