Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
|||||
| gameId | INT UNSIGNED | 10 | null |
|
|
||||||
| playerId | MEDIUMINT UNSIGNED | 8 | null |
|
|
||||||
| AI | BIT | 1 | null |
|
|
||||||
| faction | TINYINT UNSIGNED | 3 | null |
|
|
||||||
| color | TINYINT | 3 | null |
|
|
||||||
| team | TINYINT | 3 | null |
|
|
||||||
| place | TINYINT UNSIGNED | 3 | null |
|
|
||||||
| mean | FLOAT | 12 | null |
|
|
||||||
| deviation | FLOAT UNSIGNED | 12 | null |
|
|
||||||
| after_mean | FLOAT | 12 | √ | null |
|
|
|||||
| after_deviation | FLOAT UNSIGNED | 12 | √ | null |
|
|
|||||
| score | TINYINT | 3 | √ | null |
|
|
|||||
| scoreTime | TIMESTAMP | 19 | √ | null |
|
|
|||||
| result | enum('VICTORY', 'DEFEAT', 'DRAW', 'MUTUAL_DRAW', 'UNKNOWN', 'CONFLICTING') | 11 | √ | UNKNOWN |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| game_player_stats_AI_index | Performance | Asc | AI |
| game_player_stats_faction_index | Performance | Asc | faction |
| game_player_stats_scoreTime_index | Performance | Asc | scoreTime |
| gameIdIdx | Performance | Asc | gameId |
| playerId | Performance | Asc | playerId |
Relationships
Close relationships within degrees of separation
