Architecture Overview
Watch the flow animate when you toggle between modes
Database Schema
sql
clinical_trials (
id SERIAL PRIMARY KEY,
webset_item_id VARCHAR(255) UNIQUE,
webset_id VARCHAR(255),
trial_name TEXT,
nct_id VARCHAR(50),
sponsor_name TEXT,
activation_date DATE,
url TEXT,
raw_data JSONB,
created_at TIMESTAMP,
updated_at TIMESTAMP
)Important Webhook Events
webset.item.created
Fired when a new clinical trial is added to the webset
→ UPSERT to database
webset.item.enriched
Fired when enrichments are added to an item
→ UPSERT with enrichment data
webset.idle
Fired when the webset completes processing
→ Log completion