Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
|||||
| map_version_id | MEDIUMINT UNSIGNED | 8 | √ | null |
|
|
|||||
| title_key | VARCHAR | 255 | null |
|
|
The key for the title of the tutorial shown in client |
|||||
| description_key | VARCHAR | 255 | √ | null |
|
|
The key for the description of the tutorial, the text in the messages table must be in HTML |
||||
| category | INT UNSIGNED | 10 | null |
|
|
||||||
| image | VARCHAR | 255 | √ | null |
|
|
The ‘image’-path for to a preview image of the tutorial, relative to the base url defined in the api |
||||
| ordinal | INT | 10 | null |
|
|
The ‘ordinal’ which defines in which order the tutorials are shown in the client (within their category) |
|||||
| launchable | BIT | 1 | null |
|
|
Boolean that defines whether or not the tutorial can be launched |
|||||
| technical_name | VARCHAR | 255 | null |
|
|
The ‘technical_name’ of the tutorial given to the tutorial mod to decide what tutorial to start, when implemented |
|||||
| create_time | TIMESTAMP | 19 | current_timestamp() |
|
|
||||||
| update_time | TIMESTAMP | 19 | current_timestamp() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| tutorial_category | Performance | Asc | category |
| tutorial_map_version | Performance | Asc | map_version_id |
Relationships
Close relationships within degrees of separation
