The Campaign Repository persists everything about a firmware rollout: the campaign itself, its staged schedule, the signed firmware artifact it ships, and the per-device rollout targets.
Storage profile
PostgreSQL. Firmware binaries are not stored here — only a reference
(storage_url) to the signed artifact in
Object Storage.
The schema captures the campaign → stage → target hierarchy plus the firmware artifact metadata. The ERD is embedded on the Overview tab.
cohort_query is a saved device selector evaluated by the
Targeting Engine.ROLLOUT_TARGET.state mirrors the per-device progress reported back through
the Progress Tracker.