Create
Query
pilot.db
—
invoices
account_invites
accounts
applied_migrations
audit_log
availability
availability_exceptions
bookings
cards
invoices
magic_tokens
sessions
sqlite_sequence
students
trainer_settings
trainers
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 17 in invoices
id
Primary key.
INTEGER
trainer_id
INTEGER NOT NULL
student_id
INTEGER NOT NULL
invoice_no
2026-0002
TEXT NOT NULL
category
lesson
TEXT NOT NULL
lines
[{"service":"Einzelstunde 50 Min","when":"2026-06-26","quantity":1,"unit":"Std","net_cents":6303,"vat_rate":19,"vat_cents":1197,"gross_cents":7500},{"service":"Stunde auf dem Platz","when":"2026-06-17","quantity":1,"unit":"Std","net_cents":10084,"vat_rate":19,"vat_cents":1916,"gross_cents":12000}]
TEXT NOT NULL
total_cents
INTEGER NOT NULL
status
open
TEXT NOT NULL (default 'open'
issued_at
2026-06-26 14:06:00
TEXT NOT NULL (default datetime('now')
paid_at
NULL
TEXT
archived_at
TIMESTAMP
Update
Cancel