Card Evolution Phase 1

cal · 2026-03-12T20:59:50Z

cal commented

2026-03-12 20:59:50 +00:00

Tracking issue for all Phase 1 work packages. PRD: docs/prd-evolution/ | Plan: docs/prd-evolution/PHASE1_PROJECT_PLAN.md (v2.1)

Key Design Decisions:

Single metric per track with escalating thresholds (no multi-milestone tiers)
Career-scoped — tiers permanent once earned, progress accumulates across seasons
No retroactive backfill — fresh start at Season 11, all cards begin T0
Ranked legality limits competitive lifespan to ~2 seasons per card

Formulas & Thresholds (LOCKED):

Track	Formula	T1	T2	T3	T4
Batter	PA + (TB × 2)	37	149	448	896
Starting Pitcher	IP + K	10	40	120	240
Relief Pitcher	IP + K	3	12	35	70

Phase 1a: Schema & Data Foundation

#66 — WP-01: Evolution Peewee Models
#67 — WP-02: PlayerSeasonStats Peewee Model
#68 — WP-03: Track and Threshold Seed Data
#69 — WP-04: SQL Migration Script
#70 — WP-05: PlayerSeasonStats Incremental Update Logic

Phase 1b: API & Formula Engine

#71 — WP-06: Track Catalog API Endpoints
#72 — WP-07: Card State API Endpoints
#73 — WP-08: Evaluate Endpoint
#74 — WP-09: Formula Engine
#75 — WP-10: Pack Opening Hook — evolution_card_state Initialization

Phase 1c: Bot Integration

#76 — WP-11: /evo status Slash Command (discord-app repo)
#77 — WP-12: Tier Badge on Card Embed (discord-app repo)
#78 — WP-13: Post-Game Callback Integration (discord-app + database)
#79 — WP-14: Tier Completion Notifications (discord-app repo)

Phase 1d: Deployment

#80 — WP-15: Deployment and Smoke Testing (all repos)

Parallelization Notes:

WP-01, WP-02, WP-03 can start in parallel (no dependencies)
WP-06/07 can start once WP-01 + WP-04 are done
WP-09 can start once WP-02 + WP-03 are done
Phase 1c requires Phase 1b API endpoints
WP-15 is the final gate

Repos involved:

paper-dynasty-database — schema, API, formula engine (WP-01 through WP-10, WP-13 API side)
paper-dynasty/discord-app — bot commands, embeds, notifications (WP-11, WP-12, WP-13 hook, WP-14)
paper-dynasty/card-creation — PRD and simulator tool (reference only)

## Card Evolution Phase 1 Tracking issue for all Phase 1 work packages. PRD: `docs/prd-evolution/` | Plan: `docs/prd-evolution/PHASE1_PROJECT_PLAN.md` (v2.1) **Key Design Decisions:** - Single metric per track with escalating thresholds (no multi-milestone tiers) - Career-scoped — tiers permanent once earned, progress accumulates across seasons - No retroactive backfill — fresh start at Season 11, all cards begin T0 - Ranked legality limits competitive lifespan to ~2 seasons per card **Formulas & Thresholds (LOCKED):** | Track | Formula | T1 | T2 | T3 | T4 | |-------|---------|----|----|----|-----| | Batter | PA + (TB × 2) | 37 | 149 | 448 | 896 | | Starting Pitcher | IP + K | 10 | 40 | 120 | 240 | | Relief Pitcher | IP + K | 3 | 12 | 35 | 70 | --- ### Phase 1a: Schema & Data Foundation - [ ] #66 — WP-01: Evolution Peewee Models - [ ] #67 — WP-02: PlayerSeasonStats Peewee Model - [ ] #68 — WP-03: Track and Threshold Seed Data - [ ] #69 — WP-04: SQL Migration Script - [ ] #70 — WP-05: PlayerSeasonStats Incremental Update Logic ### Phase 1b: API & Formula Engine - [ ] #71 — WP-06: Track Catalog API Endpoints - [ ] #72 — WP-07: Card State API Endpoints - [ ] #73 — WP-08: Evaluate Endpoint - [ ] #74 — WP-09: Formula Engine - [ ] #75 — WP-10: Pack Opening Hook — evolution_card_state Initialization ### Phase 1c: Bot Integration - [ ] #76 — WP-11: /evo status Slash Command (`discord-app` repo) - [ ] #77 — WP-12: Tier Badge on Card Embed (`discord-app` repo) - [ ] #78 — WP-13: Post-Game Callback Integration (`discord-app` + `database`) - [ ] #79 — WP-14: Tier Completion Notifications (`discord-app` repo) ### Phase 1d: Deployment - [ ] #80 — WP-15: Deployment and Smoke Testing (all repos) --- **Parallelization Notes:** - WP-01, WP-02, WP-03 can start in parallel (no dependencies) - WP-06/07 can start once WP-01 + WP-04 are done - WP-09 can start once WP-02 + WP-03 are done - Phase 1c requires Phase 1b API endpoints - WP-15 is the final gate **Repos involved:** - `paper-dynasty-database` — schema, API, formula engine (WP-01 through WP-10, WP-13 API side) - `paper-dynasty/discord-app` — bot commands, embeds, notifications (WP-11, WP-12, WP-13 hook, WP-14) - `paper-dynasty/card-creation` — PRD and simulator tool (reference only)

cal added this to the Card Evolution Phase 1 milestone 2026-03-12 20:59:55 +00:00

cal added the

evolution

label 2026-03-12 20:59:56 +00:00

cal referenced this issue

2026-03-18 00:26:58 +00:00

Card Evolution Phase 1a: Schema & Data Foundation #104

Sign in to join this conversation.