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
Add Index
Indexed Columns
id (INTEGER)
account_id (INTEGER)
invoice_no (TEXT)
period_start (TEXT)
period_end (TEXT)
seats (INTEGER)
unit_price_cents (INTEGER)
subtotal_cents (INTEGER)
vat_rate (INTEGER)
vat_cents (INTEGER)
total_cents (INTEGER)
currency (TEXT)
status (TEXT)
reverse_charge (INTEGER)
mollie_payment_id (TEXT)
paid_at (TEXT)
pdf_path (TEXT)
created_at (TEXT)
commission_base_cents (INTEGER)
commission_pct (REAL)
commission_cents (INTEGER)
Unique?
No
Yes
Add index
Cancel