No Token Categorization Implementation

[wtfsayo]

Issue Description

The PRD (Product Requirements Document) describes token categorization functionality (DeFi, GameFi, etc.) as part of the Data Flow in Section 6, but this feature is not implemented in the codebase.

Expected Behavior

According to the PRD Section 6 - Data Flow:

• Tokens should be categorized by type (DeFi, GameFi, Meme, etc.)
• This categorization should be available in the token data returned by APIs
• The categorization would help users understand their portfolio composition by token type

Current Behavior

• No token categorization logic exists in the codebase
• Token data only includes basic metadata (symbol, name, image URL) from Jupiter Token List API
• No database columns or structures for storing token categories
• No UI components to display token categories

Affected Components

• src/services/solana.ts - Token fetching logic
• src/services/database.ts - Database schema
• src/routes/api.ts - API endpoints
• src/components/ModernDashboard.tsx - Dashboard display
• src/components/TokenDetail.tsx - Token detail view

Proposed Solution

1. Add category column to token_prices table in database schema
2. Implement categorization logic (either via external API or rule-based)
3. Update token fetching to include category data
4. Add category display to UI components
5. Consider adding portfolio breakdown by category view

Priority

Low - This is a nice-to-have feature that enhances user experience but doesn't affect core functionality

References

• Analysis document: /analysis.md (line 117)
• PRD Section 6 - Data Flow