Module schema 

Canonical SQLite projection schema for bones.

The schema is normalized for queryability and deterministic replay:

• items keeps the latest aggregate fields for each work item
• edge tables (item_labels, item_assignees, item_dependencies) model multi-valued relationships
• item_comments and event_redactions preserve event-driven side effects
• projection_meta tracks replay cursor metadata for incremental rebuilds

Constants

MIGRATION_V1_SQL

Migration v1: core normalized tables plus projection metadata.

MIGRATION_V2_SQL

Migration v2: read-path indexes and FTS5 table/triggers.

REQUIRED_INDEXES

Indexes expected by list/filter/triage query paths.