Query
CREATE TABLE commission_runs (
id INTEGER PRIMARY KEY AUTOINCREMENT,
trainer_id INTEGER NOT NULL REFERENCES trainers(id),
period TEXT NOT NULL,
-- 'YYYY-MM'
base_cents INTEGER NOT NULL,
-- fakturierter Umsatz im Zeitraum
commission_cents INTEGER NOT NULL,
-- berechnete Provision
breakdown TEXT NOT NULL,
-- JSON: [{category,
base_cents,
rate_bps,
commission_cents}]
created_at TEXT NOT NULL DEFAULT (datetime('now')),
UNIQUE(trainer_id, period)
)