activity_records
Latest case for a selected publication. Stores its publication date, checked_at timestamp, and complete case payload as JSONB.
PK document_numberactivity_assessments
Immutable assessment snapshots, including research, validation findings, and model reviews. A content fingerprint deduplicates identical cases. Each assessment belongs to one selected publication.
PK fingerprint · FK document_numberSource fields in the payload
Selected publication, linked history, source URLs, linkage method, completeness, limitations, official excerpt, and current status.
JSONB fields, not a separate tableForecast fields in the payload
Target event, issue date, window end, reasons, counterargument, and watch signals. AI metadata retains tool actions, source excerpts, comparisons, review, model, prompt, and input hash.
JSONB fields, not a separate table
Drag to pan · Scroll or + / − to zoom · Select a card to focus · Fit to reset