SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"as_of":"2026-04-08T19:57:42.365437+00:00","earnings_date":"2026-04-14","earnings_time_hint":"bmo","enrichment":{"aggregator_url":null,"article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_baef8a13087e472b","canonical_host":null,"canonical_is_aggregator":false,"canonical_url":null,"content_type":"","enriched_at":"2026-04-09T09:05:06.877084+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"","html_truncated":false,"paywall_likely":false,"publisher_domain":null,"publisher_resolution":"unresolved","requested_url":"","source_event_id":"evt_ec9383f0a3d3","source_quality":"empty","status_code":null,"version":"signal_enrichment_v2"},"eps_estimate":"-0.0915","fp":"e2466e8c7de58230","kind":"earnings_calendar","published_at":"2026-04-14T00:00:00Z","revenue_estimate":"0","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":["2026-04-14"],"entities":[{"asset_class":"equity","name":"HOVR","relevance":"high","symbol":"HOVR","type":"company"}],"event_type":"earnings","information_gaps":["No article text was provided; only a brief source summary is available.","The signal does not specify the exact time (e.g., HH:MM) beyond the BMO session.","No validation/invalidation criteria or earnings outcome (actual EPS/revenue) is provided in the signal."],"key_facts":["Earnings date: 2026-04-14","Time/session: BMO (before market open)","EPS estimate: -0.0915","Revenue estimate: 0"],"numeric_claims":[{"label":"EPS est","value":"-0.0915"},{"label":"Revenue est","value":"0"}],"primary_claim":"HOVR earnings are scheduled for 2026-04-14 at BMO with an EPS estimate of -0.0915 and revenue estimate of 0.","relevance_score":0.55,"sentiment":"neutral","source_quality":"unknown","summary":"HOVR is scheduled to report earnings on 2026-04-14 before the market open (BMO). The provided estimates include EPS of -0.0915 and a revenue estimate of 0.","topics":["earnings calendar","earnings date/time","estimates"]},"source":"earnings_calendar","summary":"Earnings date 2026-04-14 \u00b7 Time bmo \u00b7 EPS est -0.0915 \u00b7 Revenue est 0","ticker":"HOVR","tickers":["HOVR"],"title":"HOVR earnings on 2026-04-14 (bmo)","url":""}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_2fc0cfea968a in signals