Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 36 | null |
|
|
The ID of the achievement. |
|||||
| order | INT UNSIGNED | 10 | null |
|
|
The order in which the achievement is displayed to the user. |
|||||
| name_key | VARCHAR | 255 | null |
|
|
The message key for the name of the achievement. |
|||||
| description_key | VARCHAR | 255 | null |
|
|
The message key for the description of the achievement. |
|||||
| type | enum('STANDARD', 'INCREMENTAL') | 11 | null |
|
|
The type of the achievement. Possible values are: “STANDARD” - Achievement is either locked or unlocked. “INCREMENTAL” - Achievement is incremental. |
|||||
| total_steps | INT UNSIGNED | 10 | √ | null |
|
|
The total steps for an incremental achievement, NULL for standard achievements. |
||||
| revealed_icon_url | VARCHAR | 2000 | √ | null |
|
|
The image URL for the revealed achievement icon. |
||||
| unlocked_icon_url | VARCHAR | 2000 | √ | null |
|
|
The image URL for the unlocked achievement icon. |
||||
| initial_state | enum('HIDDEN', 'REVEALED') | 8 | null |
|
|
The initial state of the achievement. Possible values are: “HIDDEN” - Achievement is hidden. “REVEALED” - Achievement is revealed. “UNLOCKED” - Achievement is unlocked. |
|||||
| experience_points | INT UNSIGNED | 10 | null |
|
|
Experience points which will be earned when unlocking this achievement. Multiple of 5. Reference: 5 - Easy to achieve 20 - Medium 50 - Hard to achieve |
|||||
| create_time | TIMESTAMP | 19 | current_timestamp() |
|
|
||||||
| update_time | TIMESTAMP | 19 | current_timestamp() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| id_UNIQUE | Must be unique | Asc | id |
| name_key_UNIQUE | Must be unique | Asc | name_key |
Relationships
Close relationships within degrees of separation
