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
Update row 2 in students
id
Primary key.
INTEGER
trainer_id
INTEGER NOT NULL
name
Nico Mueller
TEXT NOT NULL
email
nico.mueller@digifors.de
TEXT
phone
1704746184
TEXT
hcpi
REAL
tags
["Anfänger","Platzreife","10er-Karte"]
TEXT NOT NULL (default '[]'
marketing_consent
INTEGER NOT NULL (default 0
video_consent
INTEGER NOT NULL (default 0
video_consent_date
2026-07-22T16:17:51.963Z
TEXT
notes
NULL
TEXT
created_at
2026-07-22 15:13:31
TEXT NOT NULL (default datetime('now')
status
active
TEXT NOT NULL (default 'active'
birthday
04.07.1974
TEXT
member_since
NULL
TEXT
home_club
Golf & Country Club Leipzig
TEXT
source
Empfehlung
TEXT
contact_channel
E-Mail
TEXT
prefs
{"days":["Di","Mi","Do","Fr"],"cadence":"wöchentlich","note":""}
TEXT
video_consent_granted_at
2026-07-22T16:17:51.963Z
TEXT
example_note
NULL
TEXT
address
An der Ritterburg 3, 04827 Machern
TEXT
calendar_token
62bd99d0eafaca719d54f5f56d48ccf90d680c4d82700b38
TEXT
password_hash
$2a$12$UufqLc5eFnlTUhBH0vH3TOBOKX1X8NIkJLy3j24k6MlbhLpYfQ8Qq
TEXT
activation_token
NULL
TEXT
activation_expires_at
NULL
TEXT
activated_at
2026-07-22 15:13:31
TEXT
password_reset_token
NULL
TEXT
password_reset_expires_at
NULL
TEXT
payment_method
NULL
TEXT
payment_notes
NULL
TEXT
marketing_consent_at
2026-07-22 15:48:47
TEXT
marketing_consent_source
student_portal
TEXT
marketing_token
4b363c65a23195aab7a96973440af7c89670b5bb3d86918e
TEXT
privacy_accepted_at
2026-07-22T15:48:39.100Z
TEXT
Update
Cancel