FitTrack_ReportGenerator/specs/002-feature-use-centraldb/data-model.md

Data Model

Entities

WorkoutAnalysis (Cache)

• Description: Represents a cached workout analysis result. This is an in-memory object to speed up subsequent requests for the same analysis.
• Fields:
  • activity_id: The ID of the activity.
  • analysis_summary: JSON object containing the summary of the analysis.
  • charts: Dictionary of chart types to chart data.
  • timestamp: The time when the analysis was cached.

AnalysisArtifact (CentralDB)

• Description: Represents a stored analysis artifact in the CentralDB. This is the long-term storage for the analysis results.
• Fields (based on the CentralDB API):
  • id: Unique identifier of the artifact.
  • activity_id: The ID of the activity.
  • data: JSON object containing the analysis results.
  • created_at: Timestamp of when the artifact was created.