SQLite Web: event

id

Primary key. TEXT

status

TEXT NOT NULL (default 'pending'

signal_type

TEXT NOT NULL

source

TEXT NOT NULL

url

TEXT

headline

TEXT

source_event_id

TEXT NOT NULL

dedupe_key

TEXT NOT NULL

claim_id

TEXT

claimed_by

TEXT

claimed_at

TEXT

lease_expires_at

TEXT

attempt_count

INTEGER NOT NULL (default 0

failed_at

TEXT

last_error

TEXT

output_event_id

TEXT

created_at

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

updated_at

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

event_store.db — signal_candidates