Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
The ID of the player achievement. |
||||
| player_id | MEDIUMINT UNSIGNED | 8 | null |
|
|
||||||
| achievement_id | VARCHAR | 36 | null |
|
|
The ID of the referenced achievement (FK). |
|||||
| current_steps | INT UNSIGNED | 10 | √ | null |
|
|
The current steps for an incremental achievement. |
||||
| state | enum('HIDDEN', 'REVEALED', 'UNLOCKED') | 8 | null |
|
|
The state of the achievement. Possible values are: “HIDDEN” - Achievement is hidden. “REVEALED” - Achievement is revealed. “UNLOCKED” - Achievement is unlocked. |
|||||
| create_time | TIMESTAMP | 19 | current_timestamp() |
|
|
||||||
| update_time | TIMESTAMP | 19 | current_timestamp() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| fk_achievement | Performance | Asc | achievement_id |
| id_UNIQUE | Must be unique | Asc | id |
| player_achievement_UNIQUE | Must be unique | Asc/Asc | player_id + achievement_id |
| player_achievements_state_index | Performance | Asc | state |
Relationships
Close relationships within degrees of separation
