Chart power vs time for official climb attempts

Snapshot average power per attempt in a nullable average_power_w column (backfilled from stored rides), plot each powered attempt on the climb page as duration vs average watts with ride hover and click-through, and show avg power in the attempts table.

1 files changed, 8 insertions, 0 deletions

diff --git a/web/frontend/types.d.ts b/web/frontend/types.d.ts
index 74e0765..a933d7d 100644
--- a/web/frontend/types.d.ts
+++ b/web/frontend/types.d.ts
@@ -134,6 +134,14 @@ export interface AnalyticsPoint {
   year: number;
 }
 
+export interface ClimbAttemptPoint {
+  durationS: number;
+  averagePowerW: number;
+  date: string;
+  rideName: string;
+  url: string;
+}
+
 export interface RateLimit {
   limit15: number;
   usage15: number;