Schema

The core entities behind the MVP.

D1 stores normalized metadata and card records. R2 stores raw and large artifacts.

D1 tables

Table	Purpose
`issuers`	Company/business entities.
`listings`	Exchange-specific tradable listings.
`sectors`	Sector metadata.
`price_bars_daily`	Daily OHLCV and delivery metrics.
`market_moves`	Computed move diagnostics and interestingness scores.
`corporate_events`	Classified filings and public events.
`filing_documents`	Raw document metadata and R2 object keys.
`evidence_items`	Claim-ready source-backed facts.
`evidence_packets`	Canonical packet JSON passed to generation.
`insight_cards`	Draft, reviewed, and published cards.
`verifier_reports`	Verifier status and issue list per card.
`card_reviews`	Human review decisions and quality scores.
`knowledge_edges`	Curated peer, sector, commodity, FX, policy, and macro sensitivities.
`watchlists`	User followed companies, sectors, themes, and indices.
`feedback`	User feedback ratings and comments.
`pipeline_runs`	Batch run metadata and summaries.