Create
Query
pilot.db
—
invoices
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 44 in invoices
id
Primary key.
INTEGER
trainer_id
INTEGER NOT NULL
student_id
INTEGER NOT NULL
invoice_no
2026-0017
TEXT NOT NULL
category
quote
TEXT NOT NULL
lines
[{"service":"Schnupperkurs","when":"2026-10-03","gross_cents":5900},{"service":"3× Einzelstunde","when":"2026-10-03","gross_cents":15000},{"service":"Ferienkurs-Materialpaket","when":"2026-10-03","gross_cents":0}]
TEXT NOT NULL
total_cents
INTEGER NOT NULL
status
paid
TEXT NOT NULL (default 'open'
issued_at
2026-10-03 11:47:31
TEXT NOT NULL (default datetime('now')
paid_at
2026-10-03 11:48:43
TEXT
archived_at
TIMESTAMP
reminder1_at
NULL
TEXT
reminder2_at
NULL
TEXT
paid_method
NULL
TEXT
Update
Cancel