| Field | Type | Null | Key | Default |
|---|---|---|---|---|
| id | int(11) | NO | PRI | |
| username | varchar(255) | YES | MUL | |
| char_symbol | char(10) | NO | ||
| session_date | datetime | YES | MUL | current_timestamp() |
| attempts | int(11) | YES | 0 | |
| correct | int(11) | YES | 0 | |
| accuracy | decimal(5,2) | YES | 0.00 | |
| avg_response_time | decimal(6,2) | YES | 0.00 | |
| min_response_time | decimal(6,2) | YES | 0.00 | |
| max_response_time | decimal(6,2) | YES | 0.00 | |
| common_errors | longtext | YES | ||
| error_patterns | longtext | YES | ||
| improvement_rate | decimal(5,2) | YES | 0.00 | |
| mastery_level | enum('learning','practicing','mastered','expert') | YES | MUL | learning |
| consecutive_correct | int(11) | YES | 0 | |
| char_speed | int(11) | YES | 20 | |
| effective_speed | int(11) | YES | 17 | |
| session_id | bigint(20) | YES |
| Field | Type | Null | Key | Default |
|---|---|---|---|---|
| id | int(11) | NO | PRI | |
| username | varchar(255) | YES | MUL | |
| session_date | datetime | YES | current_timestamp() | |
| characters_in_rotation | int(11) | YES | 2 | |
| characters_introduced | longtext | YES | ||
| characters_mastered | longtext | YES | ||
| characters_struggling | longtext | YES | ||
| session_duration | int(11) | YES | 0 | |
| total_characters_sent | int(11) | YES | 0 | |
| overall_accuracy | decimal(5,2) | YES | 0.00 | |
| effective_wpm | decimal(4,1) | YES | 0.0 | |
| character_wpm | decimal(4,1) | YES | 0.0 | |
| learning_velocity | decimal(5,2) | YES | 0.00 | |
| retention_score | decimal(5,2) | YES | 0.00 | |
| session_difficulty | enum('easy','moderate','challenging','difficult') | YES | moderate | |
| recommended_next_character | varchar(10) | YES |
| Field | Type | Null | Key | Default |
|---|---|---|---|---|
| id | int(11) | NO | PRI | |
| username | varchar(255) | NO | MUL | |
| analysis_date | date | YES | curdate() | |
| avg_session_duration | int(11) | YES | 0 | |
| sessions_per_day | decimal(3,1) | YES | 0.0 | |
| preferred_time_slots | longtext | YES | ||
| best_performing_hours | longtext | YES | ||
| consistency_score | decimal(5,2) | YES | 0.00 | |
| learns_better_with | longtext | YES | ||
| optimal_character_count | int(11) | YES | 2 | |
| plateau_risk | tinyint(1) | YES | 0 | |
| breakthrough_potential | decimal(5,2) | YES | 0.00 | |
| week_start_date | date | YES | ||
| week_end_date | date | YES |
| Field | Type | Null | Key | Default |
|---|---|---|---|---|
| id | int(11) | NO | PRI | |
| username | varchar(255) | YES | MUL | |
| session_date | datetime | YES | current_timestamp() | |
| character_speed | int(11) | YES | 20 | |
| effective_speed | int(11) | YES | 17 | |
| achieved_speed | decimal(4,1) | YES | 0.0 | |
| speed_trend | enum('improving','stable','declining','fluctuating') | YES | stable | |
| speed_improvement_rate | decimal(5,2) | YES | 0.00 | |
| character_speeds | longtext | YES | ||
| slowest_characters | longtext | YES | ||
| recommended_char_speed | int(11) | YES | ||
| recommended_effective_speed | int(11) | YES | ||
| speed_comfort_zone | decimal(4,1) | YES | 0.0 |
| Field | Type | Null | Key | Default |
|---|---|---|---|---|
| id | int(11) | NO | PRI | |
| username | varchar(255) | NO | MUL | |
| achievement_type | enum('character_mastery','speed_milestone','session_streak','accuracy_goal','learning_velocity') | NO | ||
| achievement_name | varchar(100) | NO | ||
| achievement_description | text | YES | ||
| achievement_data | longtext | YES | ||
| points_earned | int(11) | YES | 0 | |
| earned_date | datetime | YES | MUL | current_timestamp() |
| notification_sent | tinyint(1) | YES | 0 |