Practice Menu DB Structuring — AI Analysis 5 Years Out
When a coach retires, years of 'menus that develop players well' know-how disappears. Footnote Phase L's practice menu DB uses 3 tables (club_practice_menus + practice_sessions + practice_attendance) to permanently record 'what was practiced and how much' per player. 5 years of accumulation will enable AI analysis of 'practice histories of players who became successful.' This article covers structure, philosophy linkage, multi-age aggregation, and AI analysis prospects.
3-Table Structure
club_practice_menus (definitions) + practice_sessions (executions) + practice_attendance (individual participation) — fully normalized 'who, when, what, how much.'
- club_practice_menus: master data — name, duration, drills (jsonb), tags (text[]), philosophy_link
- practice_sessions: 'today we did this' — club_id, team_id, menu_id, conducted_at, menu_snapshot (jsonb)
- practice_attendance: per-player participation — session_id × player_id, attended boolean, notes, training_log_id linkage
menu_snapshot design: 'menu edits after the fact don't change past session records' — preserves history.
Philosophy Linkage
Each menu tags which philosophy element it reinforces. Menus without philosophy links can't justify 'why we're doing this.'
philosophy_link FK to club_philosophies.id, nullable but UI warns when null. Forces coach awareness of 'why this practice?' tag examples: Possession, Pressing, Transition, Finishing, SSG.
5-Year AI Analysis Vision
5 years of accumulation enables 'practice patterns of successful players (pro promotion, PVS 80+ maintenance) from U-12 to U-18' analysis.
- 'Pro-promoted players averaged X hours of Pressing-system at U-15'
- 'PVS-80-maintained players did 3+ first-touch drills weekly at U-13'
- 'Practice composition of CMFs who became successful at U-12'
- 'Practice intensity patterns of injury-free, long-career players'
AI-recommended 'practice allocation based on past successful patterns' for current PVS-top U-12 players (future vision).
References
- [1] Ford P.R., Ward P., Hodges N.J., Williams A.M. (2009). “The role of deliberate practice and play in career progression in sport” High Ability Studies.
- [2] Côté J., Baker J., Abernethy B. (2007). “Practice and play in the development of sport expertise” Handbook of Sport Psychology.
Related Articles
Attendance × PVS Correlation — Data-Driven Development Efficiency
2 min read
Verbalizing Club Philosophy — A 3-Question Framework
2 min read
Improving PVS — 30 Concrete Monthly Actions Across 4 Axes
3 min read
PVS (Player Value Score) — Complete Guide to Footnote's Composite Player Metric
7 min read
Mascot Evolution System — The Behavioral Psychology of Footnote's Gamification
3 min read
Track Your Growth with Footnote
Just record your matches — AI analyzes every 5 games. Visualize growth with PVS Score. All features free during beta.
30-second signup · No credit card required
Last updated: 2026-05-18 ・ Footnote Editorial