Create
Query
pilot.db
—
saas_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 3 in saas_invoices
id
Primary key.
INTEGER
account_id
INTEGER NOT NULL
invoice_no
GS-2026-0003
TEXT NOT NULL
period_start
2026-07-23
TEXT NOT NULL
period_end
2026-08-31
TEXT NOT NULL
seats
INTEGER NOT NULL
unit_price_cents
INTEGER NOT NULL
subtotal_cents
INTEGER NOT NULL
vat_rate
INTEGER NOT NULL
vat_cents
INTEGER NOT NULL
total_cents
INTEGER NOT NULL
currency
EUR
TEXT NOT NULL (default 'EUR'
status
paid
TEXT NOT NULL (default 'draft'
reverse_charge
INTEGER NOT NULL (default 0
mollie_payment_id
tr_mE7NJJvkPZquWcaEza4VJ
TEXT
paid_at
2026-08-07 14:43:43
TEXT
pdf_path
NULL
TEXT
created_at
2026-08-07 14:43:43
TEXT NOT NULL (default datetime('now')
commission_base_cents
INTEGER NOT NULL (default 0
commission_pct
REAL
commission_cents
INTEGER NOT NULL (default 0
Update
Cancel