The symptoms of episodic migraine can vary from person to person, but common symptoms include:
| Component | Suggestion | |-----------|-------------| | | Event table: date, type (migraine/headache/aura), pain scale, meds, triggers | | Rolling window | SQL: COUNT(CASE WHEN type='migraine' THEN 1 END) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) | | MOH detection | Sum triptan/opioid/NSAID days per 30 days; threshold ≥10 (triptan), ≥15 (NSAID) | | Trigger correlation | Logistic regression or simple relative risk: P(migraine | trigger) / P(migraine | no trigger) | | Transition alert | Moving average of migraine days crossing ≥15 | episodic migraine