Query
CREATE TABLE raw_webhooks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
source TEXT NOT NULL,
-- e.g. 'beds24'
payload TEXT NOT NULL,
-- JSON string
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
processed_status TEXT DEFAULT 'pending' -- pending,
processed,
failed
)