AlertEvent Schema
Description: A normalized broker notice persisted by the listener.
Every received notice lands here regardless of whether anything
matched — the table backs dedup (unique source+external id), the
update/retraction lifecycle (``event_group_key`` groups all notices
for one astrophysical event), the filter backtest endpoint, and the
user-visible "recent alerts" feed. Bulky skymaps are stripped from
``payload`` and stored in MinIO under ``skymap_object_key``.
Properties
| Name | Type | Description |
|---|---|---|
| id | Integer |
No description |
| source_id | Integer |
No description |
| topic | String(255) |
No description |
| external_id | String(255) |
Per-notice identifier (Swift TrigID + packet serial, LVK superevent id + sequence, ZTF objectId + candid, …). |
| event_group_key | String(255) |
Stable per astrophysical event across its notice chain (Swift TrigID, LVK superevent id, ZTF objectId). |
| notice_type | Enum(initial, subsequent, update, retraction) |
No description |
| event_name | String(120) (Optional) |
No description |
| event_time | DateTime (Optional) |
No description |
| received_on | DateTime |
No description |
| ra_deg | Float (Optional) |
No description |
| dec_deg | Float (Optional) |
No description |
| error_radius_deg | Float (Optional) |
No description |
| containment_probability | Float (Optional) |
Containment fraction of error_radius_deg (gcn-schema defaults this to 0.9 when a mission omits it; recorded explicitly). |
| classification | JSONB |
No description |
| is_test | Boolean |
No description |
| skymap_object_key | String(512) (Optional) |
No description |
| payload | JSONB |
Raw notice (skymap bytes / cutout stamps stripped). |
Relationships
| Relationship Name | Type |
|---|---|
| source | AlertSource |
| triggers | AlertTrigger |