🏑 POWLAX Data Flow Diagrams
Complete System Architecture
This diagram shows all 34 tables and their relationships across the entire POWLAX ecosystem.
- Pink boxes: Entry points (Registration, WordPress)
- Blue boxes: Core content (Drills)
- Green boxes: User management
- Purple boxes: Game structure from CSV analysis
graph TB
%% User Entry Points
subgraph “User Entry”
REG[Registration System]
WP[WordPress APIs]
end
%% User Management Core
subgraph “User Management”
UP[user_profiles]
TM[teams]
TMB[team_memberships]
UP –>|primary_team_id| TM
UP –>|parent/child arrays| UP
TMB –>|user_id| UP
TMB –>|team_id| TM
TM –>|parent_team_id| TM
end
%% Core Content
subgraph “Core Content”
D[drills]
DV[drill_variations]
W[workouts]
Q[quizzes]
DR[drill_requirements]
D –>|has many| DV
W –>|position-based| UP
DR –>|defines success| D
end
%% Game Structure (CSV)
subgraph “Game Structure”
GP[game_phases]
PS[player_states]
PSI[phase_state_integration]
GP –>|preceded_by/leads_to| GP
PS –>|transitions_to| PS
PSI –>|maps| GP
PSI –>|maps| PS
end
%% Teaching System (CSV)
subgraph “Teaching & Skills”
MT[master_terms]
CV[context_variations]
TC[teaching_concepts]
MP[movement_principles]
SH[skills_hierarchy]
SCR[skill_cross_reference]
DS[developmental_stages]
MT –>|has variations| CV
TC –>|teaches| SH
MP –>|applied in| SH
SH –>|prerequisites/leads_to| SH
DS –>|skill progression| SH
SCR –>|universal skills| SH
end
%% Communication (CSV)
subgraph “Communication”
CM[communication_matrix]
CM –>|phase meanings| GP
CM –>|state usage| PS
CV –>|contextual| CM
end
%% Practice Planning
subgraph “Practice Planning”
PP[practice_plans]
PPD[practice_plan_drills]
PP –>|belongs to| TM
PPD –>|drill_id| D
PPD –>|practice_plan_id| PP
PPD –>|selected_variation| DV
end
%% Strategic Enhancement
subgraph “Strategic Layer”
S[strategies]
C[concepts]
SK[skills]
DS1[drill_strategies]
DC[drill_concepts]
DSK[drill_skills]
DS1 –>|drill_id| D
DS1 –>|strategy_id| S
DC –>|drill_id| D
DC –>|concept_id| C
DSK –>|drill_id| D
DSK –>|skill_id| SK
SK –>|corresponds to| SH
end
%% Progress & Gamification
subgraph “Progress Tracking”
UPR[user_progress]
US[user_stats]
PT[point_types]
BT[badge_types]
B[badges]
UPR –>|user_id| UP
UPR –>|content_id| D
UPR –>|content_id| W
UPR –>|content_id| Q
UPR –>|team_id| TM
US –>|aggregates| UPR
B –>|type| BT
W –>|awards| B
end
%% System Configuration
subgraph “System Config”
AB[age_bands]
SS[system_settings]
AB –>|spectrum access| AB
TM –>|age_division| AB
UP –>|age_band| AB
end
%% WordPress Integration
subgraph “WordPress Sync”
WSL[wp_sync_log]
MA[media_assets]
MA –>|used_in| D
end
%% Major Data Flows
REG ==>|Creates| UP
REG ==>|Creates| TM
REG ==>|Creates| TMB
WP ==>|Syncs to| D
WP ==>|Syncs to| W
WP ==>|Syncs to| Q
D –>|enhanced by| TC
D –>|applies| MP
D –>|trains| PS
D –>|relevant to| GP
style REG fill:#f9f,stroke:#333,stroke-width:4px
style D fill:#bbf,stroke:#333,stroke-width:4px
style UP fill:#bfb,stroke:#333,stroke-width:4px
style GP fill:#fbf,stroke:#333,stroke-width:4px
style PS fill:#fbf,stroke:#333,stroke-width:4px
Registration Flow
Shows how the unified registration system handles different user roles and enforces the 25-player limit for teams.
graph LR
REG[Registration] –> UD{User Decision}
UD –>|Player| PC[Check 25 Player Limit]
UD –>|Coach| CC[Create Coach Account]
UD –>|Parent| PA[Link to Child]
PC –> TM[Team Assignment]
CC –> TM
PA –> PV[Parent Visibility]
TM –> BG[BuddyBoss Groups]
TM –> SA[Skills Academy Access]
Practice Planning Flow
Illustrates the enhanced practice planner with strategic depth – showing how drills connect to strategies, concepts, and skills.
graph TD
COACH[Coach] –> SELECT[Select Drills]
SELECT –> ENHANCE[Strategic Enhancement]
ENHANCE –> AGE[Age Adaptation]
AGE –> PRACTICE[Practice Plan]
PRACTICE –> EXEC[Live Execution]
EXEC –> TRACK[Progress Tracking]
TRACK –> ANALYTICS[Team Analytics]
ENHANCE -.->|Links to| STRAT[Strategies]
ENHANCE -.->|Links to| CONC[Concepts]
ENHANCE -.->|Links to| SKILLS[Skills]
Skills Academy Flow
Shows the progressive skill development system with position-specific workouts (A1-A13, M1-M13, D1-D13) and the 5x point multiplier for 5-drill workouts.
graph TD
PLAYER[Player] –> POS{Position?}
POS –>|Attack| A[A1-A13 Workouts]
POS –>|Midfield| M[M1-M13 Workouts]
POS –>|Defense| D[D1-D13 Workouts]
A –> COMPLETE[Complete Workout]
M –> COMPLETE
D –> COMPLETE
COMPLETE –> POINTS[5x Points for 5-drill]
COMPLETE –> BADGES[Progressive Badges]
POINTS –> LEADERBOARD[Team Leaderboard]
BADGES –> PROFILE[Player Profile]
Game Phase Integration
Revolutionary integration showing how the 10 game phases connect with 5 player states and 50 communication terms. This enables context-aware training.
graph LR
GAME[Game Play] –> PHASE[Current Phase]
PHASE –> STATE[Player States]
STATE –> DECISIONS[Key Decisions]
DECISIONS –> SKILLS[Required Skills]
SKILLS –> COMM[Communication]
PHASE -.->|10 Phases| GP[(game_phases)]
STATE -.->|5 States| PS[(player_states)]
COMM -.->|50 Terms| CM[(communication_matrix)]