Champion Stats Hub - Complete Metrics Documentation¶

Total Database Tables: 53 Total Unique Data Fields: 386 Health/Fitness Specific Metrics: 200

1. VITALS & BIOMETRICS¶

From `health_metrics` table¶

Field	Type	Description
`metric_type`	string	Type of health metric (hr, hrv, steps, etc.)
`metric_value`	number	The recorded value
`metric_unit`	string	Unit of measurement (bpm, ms, steps, etc.)
`recorded_at`	timestamp	When the metric was recorded
`source_device`	string	Device that recorded the metric (Apple Watch, WHOOP, etc.)

From `client_health_metrics` table¶

Field	Type	Description
`resting_heart_rate`	number	Resting heart rate in BPM. Normal: 60-100, Athletes: 40-60
`hrv`	number	Heart Rate Variability in milliseconds (RMSSD). Higher = better recovery. Normal: 20-70ms
`sleep_hours`	number	Total hours of sleep
`sleep_score`	number	Quality score 0-100 based on duration, efficiency, architecture
`recovery_score`	number	Overall recovery status 0-100
`readiness_score`	number	Training readiness 0-100 (similar to WHOOP/Oura)
`strain_score`	number	Daily cardiovascular load 0-21 (WHOOP-style)
`stress_level`	number	Perceived or measured stress level 0-100
`steps`	number	Daily step count
`active_minutes`	number	Minutes of active movement
`calories_burned`	number	Total calories burned (BMR + activity)
`hydration_level`	number	Hydration percentage 0-100
`health_score`	number	Overall health composite score 0-100
`body_fat_percentage`	number	Body fat as percentage of total weight
`weight_kg`	number	Body weight in kilograms
`spo2`	number	Blood oxygen saturation percentage (normal: 95-100%)
`respiratory_rate`	number	Breaths per minute (normal: 12-20)

From `face_scan_results` table¶

Field	Type	Description
`wellness_score`	number	AI-derived wellness score from facial analysis
`metrics`	JSON	Detailed facial scan metrics (stress indicators, skin health, etc.)

From `body_scan_results` table¶

Field	Type	Description
`overall_score`	number	Body composition score 0-100
`metrics`	JSON	Detailed body measurements and analysis

2. BODY COMPOSITION¶

From `smart_scale_readings` table¶

Field	Type	Description
`weight`	number	Body weight (primary measurement)
`body_fat`	number	Body fat percentage via bioimpedance
`muscle_mass`	number	Estimated muscle mass in kg
`bone_mass`	number	Estimated bone mass in kg
`water_percent`	number	Body water percentage (optimal: 50-65%)
`visceral_fat`	number	Visceral fat rating (1-12 healthy, 13+ high)
`bmr`	number	Basal Metabolic Rate - calories burned at rest
`metabolic_age`	number	Estimated metabolic age based on BMR

From `profiles` table¶

Field	Type	Description
`height_cm`	number	Height in centimeters
`weight_kg`	number	Current weight in kg
`target_weight_kg`	number	Goal weight in kg
`weight_class`	string	Competition weight class (if applicable)
`gender`	string	male/female - affects calculations
`date_of_birth`	date	Used to calculate age
`body_fat_percentage`	number	Current body fat %

From `coach_clients` table¶

Field	Type	Description
`weight_kg`	number	Client's current weight
`height_cm`	number	Client's height
`target_weight_kg`	number	Client's goal weight
`fitness_level`	string	beginner/intermediate/advanced/elite

3. STRENGTH & POWER METRICS¶

From `power_to_weight_metrics` table¶

Field	Type	Description
`bodyweight_kg`	number	Body weight at time of measurement
`squat_1rm`	number	1-rep max squat in kg
`bench_1rm`	number	1-rep max bench press in kg
`deadlift_1rm`	number	1-rep max deadlift in kg
`overhead_press_1rm`	number	1-rep max overhead press in kg
`clean_1rm`	number	1-rep max clean in kg
`vertical_jump_cm`	number	Vertical jump height in cm
`broad_jump_cm`	number	Standing broad jump distance in cm
`power_output_watts`	number	Peak power output in watts
`power_to_weight_ratio`	number	Power divided by bodyweight (watts/kg)
`relative_strength_score`	number	Strength relative to bodyweight 0-100
`athletic_ready_score`	number	Overall athletic readiness 0-100
`athletic_ready_tier`	string	bronze/silver/gold/elite classification

Cardio Fitness Metrics¶

Field	Type	Description
`vo2_max_estimate`	number	Estimated VO2max in ml/kg/min. Elite: 60+, Good: 40-50
`cooper_test_meters`	number	Distance covered in 12-min Cooper test
`mile_time_seconds`	number	Time to run 1 mile in seconds
`resting_heart_rate`	number	Lower = better cardiovascular fitness

4. SLEEP METRICS¶

From `daily_summaries` table¶

Field	Type	Description
`sleep_hours`	number	Total sleep duration
`sleep_score`	number	Calculated sleep quality 0-100

Derived Sleep Metrics (from health data)¶

Metric	Description	Calculation
`sleep_duration_hours`	Total time asleep	Direct from device
`sleep_quality`	Overall quality score	Composite of efficiency + architecture
`sleep_efficiency`	Time asleep / Time in bed × 100	Optimal: >85%
`deep_sleep_percent`	% of sleep in deep/N3 stage	Optimal: 15-25%
`rem_sleep_percent`	% of sleep in REM stage	Optimal: 20-25%

5. NUTRITION METRICS¶

From `client_nutrition_logs` table¶

Field	Type	Description
`calories`	number	Total calories consumed in meal
`protein_g`	number	Protein in grams
`carbs_g`	number	Carbohydrates in grams
`fat_g`	number	Fat in grams
`fiber_g`	number	Fiber in grams
`water_ml`	number	Water intake in milliliters
`meal_type`	string	breakfast/lunch/dinner/snack
`supplements`	JSON	List of supplements taken

From `daily_summaries` table¶

Field	Type	Description
`total_calories`	number	Total daily calorie intake
`nutrition_compliance`	number	% adherence to nutrition plan 0-100

From `program_meal_plans` table¶

Field	Type	Description
`calorie_target`	number	Daily calorie goal
`macro_targets`	JSON	Target macros

6. WORKOUT & TRAINING METRICS¶

From `workouts` table¶

Field	Type	Description
`workout_type`	string	strength/cardio/hiit/flexibility/sport
`duration_minutes`	number	Workout length in minutes
`calories_burned`	number	Estimated calories burned
`exercises`	JSON	List of exercises with sets/reps/weight
`status`	string	planned/in_progress/completed/skipped

From `training_sessions` table¶

Field	Type	Description
`session_type`	string	Type of training session
`duration_minutes`	number	Planned/actual duration
`avg_heart_rate`	number	Average HR during session
`calories_burned`	number	Calories burned in session
`workout_plan`	JSON	Planned exercises
`actual_exercises`	JSON	What was actually performed

From `program_workouts` table¶

Field	Type	Description
`workout_type`	string	Type of programmed workout
`day_of_week`	number	1-7 (Monday-Sunday)
`week_number`	number	Week in the program
`exercises`	JSON	Prescribed exercises
`completed`	boolean	Whether workout was done
`performance_data`	JSON	Actual performance vs planned
`skipped_due_to_recovery`	boolean	AI-adjusted rest day

From `daily_summaries` table¶

Field	Type	Description
`workouts_completed`	number	Count of workouts done that day
`total_duration_minutes`	number	Total workout time
`total_strain`	number	Cumulative strain score
`xp_earned`	number	Gamification XP points
`coins_earned`	number	Gamification coins

7. RECOVERY & READINESS METRICS¶

From `weekly_check_ins` table¶

Field	Type	Description
`actual_weight`	number	Weigh-in weight
`expected_weight`	number	Predicted weight based on plan
`variance_kg`	number	Difference from expected
`actual_body_fat`	number	Measured body fat %
`expected_body_fat`	number	Predicted body fat %
`compliance_score`	number	Adherence to program 0-100
`workouts_completed`	number	Workouts done this week
`workouts_planned`	number	Workouts scheduled
`avg_daily_calories`	number	Average calories consumed
`target_calories`	number	Calorie target
`avg_recovery_score`	number	Average recovery this week
`is_on_track`	boolean	Whether progress is on track
`ai_analysis`	string	AI-generated progress analysis
`ai_recommendations`	JSON	AI suggestions for next week

From `recovery_adjustments` table¶

Field	Type	Description
`adjustment_type`	string	rest_day/reduce_volume/modify_intensity
`recovery_score_at_trigger`	number	Recovery level that triggered adjustment
`original_workout`	JSON	What was planned
`adjusted_workout`	JSON	Modified workout
`ai_reasoning`	string	Why the AI made this adjustment
`user_accepted`	boolean	Did user accept the suggestion

8. TRANSFORMATION PROGRAM METRICS¶

From `transformation_programs` table¶

Field	Type	Description
`goal_type`	string	fat_loss/muscle_gain/recomp/performance
`starting_metrics`	JSON	Baseline measurements
`target_metrics`	JSON	Goal measurements
`daily_calorie_target`	number	Daily calorie goal
`daily_deficit`	number	Planned calorie deficit (for fat loss)
`weekly_training_days`	number	Workouts per week
`intensity_level`	string	low/moderate/high/extreme
`recovery_sensitivity`	string	low/normal/high (affects AI adjustments)

From `program_phases` table¶

Field	Type	Description
`phase_name`	string	Name of training phase
`phase_number`	number	Order in program
`focus`	string	Primary focus (strength/hypertrophy/endurance/cut)
`start_week`	number	Phase start week
`end_week`	number	Phase end week
`workout_plan`	JSON	Phase-specific workouts
`nutrition_targets`	JSON	Phase-specific nutrition
`recovery_thresholds`	JSON	When to trigger recovery adjustments

From `program_milestones` table¶

Field	Type	Description
`title`	string	Milestone name
`metric_type`	string	What metric to track
`target_value`	number	Target to achieve
`week_number`	number	Expected achievement week
`achieved`	boolean	Whether milestone was hit
`achieved_at`	timestamp	When it was achieved
`celebrated`	boolean	User celebrated in app
`shared_to_circle`	boolean	Shared with health circle

9. LEADERBOARD & COMPETITION METRICS¶

From `leaderboard_snapshots` table¶

Field	Type	Description
`week_number`	number	Week of the snapshot
`current_rank`	number	Current leaderboard position
`previous_rank`	number	Last week's position
`progress_percentage`	number	% progress toward goal
`compliance_score`	number	Program adherence
`milestones_achieved`	number	Count of milestones hit
`weight_class`	string	Competition weight class
`discipline`	string	Sport/discipline category
`p_kg_score`	number	Power-to-weight score

10. DNA & GENETIC INSIGHTS¶

From `dna_test_results` table¶

Field	Type	Description
`test_provider`	string	23andMe/AncestryDNA/etc.
`diet_profile`	JSON	Genetic diet recommendations
`nutrition_needs`	JSON	Nutrient sensitivities/requirements
`sports_fitness`	JSON	Athletic genetic markers
`stress_sleep`	JSON	Stress response and sleep genetics
`well_being`	JSON	Mental health genetic factors

11. CALCULATED/DERIVED SCORES (15 Advanced Metrics)¶

These are calculated in src/lib/advancedHealthScores.ts:

Score	Scale	Description	Formula
Biological Age	Years	How old your body acts	`age + HRV_adj + RHR_adj + sleep_adj + exercise_adj + bodyfat_adj`
Biological Age Delta	Years	Difference from actual age	`chronological_age - biological_age` (positive = younger)
Metabolic Health	0-100	Overall metabolic function	`BMI_score + body_fat_score + calorie_score + protein_score`
Cardiovascular Fitness	0-100	Heart & lung health	`RHR_score + HRV_score + VO2max_score + BP_score`
Readiness Score	0-100	Training readiness today	`(HRV×0.4) + (sleep×0.3) + (recovery×0.2) + (RHR×0.1)`
Recovery Potential	0-100	Baseline recovery ability	`(HRV_capacity×0.4) + (sleep_efficiency×0.3) + (deep_sleep×0.2) + (quality×0.1)`
Sleep Performance	0-100	Sleep quality composite	`duration_score + quality_score + efficiency_score + architecture_score`
Stress Resilience	0-100	Ability to handle stress	`(HRV×0.45) + (RHR×0.25) + (recovery×0.15) + exercise_bonus + sleep_bonus`
Longevity Score	0-100	Long-term health outlook	`(cardio×0.3) + (metabolic×0.2) + (sleep×0.2) + (stress×0.15) + (activity×0.15) + age_bonus`
Athletic Potential	0-100	Performance capacity	`VO2_score + heart_efficiency + training_score + energy_score`
Injury Risk Index	0-100	Injury risk (lower=better)	`(recovery_risk×0.35) + (sleep_risk×0.25) + (HRV_risk×0.25) + (overtraining×0.15)`
Overtraining Risk	0-100	Overtraining signs (lower=better)	`(HRV_suppression×0.35) + (RHR_elevation×0.2) + (sleep_issue×0.2) + (volume×0.1) + (recovery×0.15)`
Fuel Efficiency	0-100	Nutrition supporting activity	`calorie_balance + protein_adequacy + hydration + energy_balance`
Strain Score	0-21	Daily cardiovascular load	`21 × (1 - e^(-rawStrain/200))` where rawStrain = Σ(zone_mins × zone_multiplier)
Fitness Score	0-∞	Cumulative fitness (CTL)	`Σ(TSS × e^(-daysAgo/42)) / 42` with 42-day decay

12. DEVICE & INTEGRATION METRICS¶

From `user_devices` table¶

Field	Type	Description
`device_type`	string	apple_watch/whoop/oura/garmin/fitbit/scale
`device_name`	string	User-friendly device name
`is_connected`	boolean	Currently connected
`last_sync_at`	timestamp	Last data sync
`battery_level`	number	Device battery %
`firmware_version`	string	Device software version

From `device_connections` table¶

Field	Type	Description
`device_type`	string	Type of connected device
`auto_checkin_enabled`	boolean	Auto-sync weekly check-ins
`last_sync`	timestamp	Most recent sync

13. USER PATTERNS & INSIGHTS¶

From `user_health_patterns` table¶

Field	Type	Description
`metric_a`	string	First metric in correlation
`metric_b`	string	Second metric in correlation
`correlation_strength`	number	Correlation coefficient (-1 to 1)
`is_positive`	boolean	Positive or negative correlation
`is_significant`	boolean	Statistically significant
`p_value`	number	Statistical significance
`sample_size`	number	Data points analyzed
`lag_days`	number	Time delay in correlation
`ai_insight`	string	AI explanation of pattern
`recommendation`	string	Action recommendation

SUMMARY BY CATEGORY¶

Category	Count	Description
Vitals & Biometrics	27	Heart rate, HRV, SpO2, respiratory rate, blood metrics
Body Composition	20	Weight, fat, muscle, water
Strength & Power	15	1RM, jumps, power output
Sleep	10	Duration, quality, stages
Nutrition	12	Calories, macros, hydration
Workout & Training	25	Exercises, duration, strain
Recovery & Readiness	18	Recovery scores, adjustments
Transformation	20	Program progress, milestones
Leaderboard	10	Rankings, competition
DNA & Genetics	6	Genetic insights
Calculated Scores	15	AI-derived composite scores
Device/Integration	10	Connected devices
User Patterns	12	AI-discovered correlations

GRAND TOTAL: 200 unique trackable metrics

DATA SOURCES¶

Manual Input - User enters data directly
Wearable Devices - Apple Watch, WHOOP, Oura, Garmin, Fitbit
Smart Scales - Weight, body composition
Face/Body Scans - AI-powered analysis
DNA Tests - 23andMe, AncestryDNA integration
AI Calculations - Derived from other metrics
Coach Input - Trainer-entered assessments

Generated: 2026-02-03 Source: champion-stats-hub Supabase schema + advancedHealthScores.ts

Champion Stats Hub - Complete Metrics Documentation¶

1. VITALS & BIOMETRICS¶

From health_metrics table¶

From client_health_metrics table¶

From face_scan_results table¶

From body_scan_results table¶

2. BODY COMPOSITION¶

From smart_scale_readings table¶

From profiles table¶

From coach_clients table¶

3. STRENGTH & POWER METRICS¶

From power_to_weight_metrics table¶

Cardio Fitness Metrics¶

4. SLEEP METRICS¶

From daily_summaries table¶

Derived Sleep Metrics (from health data)¶

5. NUTRITION METRICS¶

From client_nutrition_logs table¶

From daily_summaries table¶

From program_meal_plans table¶

6. WORKOUT & TRAINING METRICS¶

From workouts table¶

From training_sessions table¶

From program_workouts table¶

From daily_summaries table¶

7. RECOVERY & READINESS METRICS¶

From weekly_check_ins table¶

From recovery_adjustments table¶

8. TRANSFORMATION PROGRAM METRICS¶

From transformation_programs table¶

From program_phases table¶

From program_milestones table¶

9. LEADERBOARD & COMPETITION METRICS¶

From leaderboard_snapshots table¶

10. DNA & GENETIC INSIGHTS¶

From dna_test_results table¶

11. CALCULATED/DERIVED SCORES (15 Advanced Metrics)¶

12. DEVICE & INTEGRATION METRICS¶

From user_devices table¶

From device_connections table¶

13. USER PATTERNS & INSIGHTS¶

From user_health_patterns table¶

SUMMARY BY CATEGORY¶

DATA SOURCES¶

From `health_metrics` table¶

From `client_health_metrics` table¶

From `face_scan_results` table¶

From `body_scan_results` table¶

From `smart_scale_readings` table¶

From `profiles` table¶

From `coach_clients` table¶

From `power_to_weight_metrics` table¶

From `daily_summaries` table¶

From `client_nutrition_logs` table¶

From `daily_summaries` table¶

From `program_meal_plans` table¶

From `workouts` table¶

From `training_sessions` table¶

From `program_workouts` table¶

From `daily_summaries` table¶

From `weekly_check_ins` table¶

From `recovery_adjustments` table¶

From `transformation_programs` table¶

From `program_phases` table¶

From `program_milestones` table¶

From `leaderboard_snapshots` table¶

From `dna_test_results` table¶

From `user_devices` table¶

From `device_connections` table¶

From `user_health_patterns` table¶