Create
Query
pilot.db
—
commission_runs
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 1 in commission_runs
id
Primary key.
INTEGER
trainer_id
INTEGER NOT NULL
period
2026-07
TEXT NOT NULL
base_cents
INTEGER NOT NULL
commission_cents
INTEGER NOT NULL
breakdown
[{"category":"other","base_cents":49900,"rate_bps":500,"commission_cents":2495},{"category":"lesson","base_cents":5900,"rate_bps":500,"commission_cents":295},{"category":"offer","base_cents":329999,"rate_bps":500,"commission_cents":16500},{"category":"video_analysis","base_cents":1497,"rate_bps":500,"commission_cents":75}]
TEXT NOT NULL
created_at
2026-07-27 19:09:53
TEXT NOT NULL (default datetime('now')
Update
Cancel