We want to implement a core stats system for the game using a dedicated stats table:
Each row represents one card's stat profile
Each column represents a different stat
card_id
power
charm
stat_name
INT
INT
INT
INT
card_id – references the card from the main cards table
power – represents the strength or effectiveness of the card
charm – represents the appeal or vibe of the card
Benefits
Easy to query and compare card stats
Simple schema for a fixed set of stat types
Scalable if new stat columns are added later
Scope for Now
Only power and charm will be implemented to start
Focus on a minimal and functional implementation
We want to implement a core stats system for the game using a dedicated stats table:
- Each row represents one card's stat profile
- Each column represents a different stat
| card_id | power | charm | stat_name |
| -------- | -------- | -------- | -------- |
| INT | INT | INT | INT |
- card_id – references the card from the main cards table
- power – represents the strength or effectiveness of the card
- charm – represents the appeal or vibe of the card
Benefits
- Easy to query and compare card stats
- Simple schema for a fixed set of stat types
- Scalable if new stat columns are added later
Scope for Now
- Only power and charm will be implemented to start
- Focus on a minimal and functional implementation
We want to implement a core stats system for the game using a dedicated stats table:
Each row represents one card's stat profile
Each column represents a different stat
card_id – references the card from the main cards table
power – represents the strength or effectiveness of the card
charm – represents the appeal or vibe of the card
Benefits
Easy to query and compare card stats
Simple schema for a fixed set of stat types
Scalable if new stat columns are added later
Scope for Now
Only power and charm will be implemented to start
Focus on a minimal and functional implementation