# SQLite Schema

Canonical database: `/intel.db.gz`.

Core tables:

- `nodes(id, type, name, attrs, created_at, updated_at)`
- `edges(id, src, dst, rel, weight, attrs, created_at, updated_at)`
- `allocation_signals(id, signal_type, subject_id, subject_name, subject_type, strategy, status, signal_date, deadline, next_review, amount, confidence, attrs, created_at, updated_at)`
- `citations(id, entity_type, entity_id, source_type, source_path, excerpt, page_ref, confidence, added_at, as_of_date, valid_until)`

Node `attrs` contains derived metrics such as `pagerank`, `community`,
`transcendence_score`, `freshness_score`, and `stale` when available.