Data Requirements and Schema Design for TheRock Ingestion (Phase 1)

[HereThereBeDragons]

Phase: 1 Design
Labels: quartz, phase-1, design
Blocks: Phase 1 A2, Phase 1 B+C, Phase 1 D

Design work that must be completed before Phase 1 implementation can begin. All
four issues feed into the implementation — the database schema and status.json
structure must be stable before any code is written.

Subissues

• Phase 1 Design 1: Define Required Grafana Metrics (phase1-design-1-grafana-metrics.md)
• Phase 1 Design 2: Data Extraction Spec (phase1-design-2-data-extraction-spec.md)
• Phase 1 Design 3: Database Schema Design (phase1-design-3-db-schema.md)
• Phase 1 Design 4: status.json Schema Design (phase1-design-4-status-json-schema.md)

Dependency Order

1. Grafana Metrics
      ↓
2. Data Extraction Spec
      ↓
3. Database Schema  ←─ parallel ─→  4. status.json Schema