Create
Query
pilot.db
—
quotes
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 6 in quotes
id
Primary key.
INTEGER
trainer_id
INTEGER NOT NULL
student_id
INTEGER NOT NULL
title
Ferienkurs für Anfänger
TEXT NOT NULL
intro
Schön, dass du den Golfsport entdecken möchtest! In unserem Ferienkurs lernst du in entspannter Atmosphäre die ersten Grundlagen – ganz ohne Vorkenntnisse. Ich freue mich darauf, dich auf deinen ersten Schwung vorzubereiten.
TEXT
lines
[{"label":"Schnupperkurs","qty":1,"price_cents":5900},{"label":"Einzelstunde","qty":3,"price_cents":5000},{"label":"Ferienkurs-Materialpaket","qty":1,"price_cents":0}]
TEXT NOT NULL (default '[]'
total_cents
INTEGER NOT NULL (default 0
valid_until
NULL
TEXT
status
accepted
TEXT NOT NULL (default 'draft'
token
f1a7b8f0efb1798b7f0c560d0cc71bdfef0816f393570a55
TEXT
auto_invoice
INTEGER NOT NULL (default 1
proposed_service_id
INTEGER
proposed_starts_at
NULL
TEXT
invoice_id
INTEGER
booking_id
INTEGER
sent_at
2026-10-03 11:46:54
TEXT
decided_at
2026-10-03 11:47:31
TEXT
created_at
2026-10-03 11:46:49
TEXT NOT NULL (default datetime('now')
updated_at
2026-10-03 11:47:31
TEXT NOT NULL (default datetime('now')
Update
Cancel