# tool_usertours_steps

0 rows

### Description

Steps in an tour

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
tourid | BIGINT | 19 |  |  | null |  |
tool_usertours_tours.id | tooluserstep_tou2_fkR
title | LONGTEXT | 2147483647 | √ |  | null |  |  | Title of the step
content | LONGTEXT | 2147483647 | √ |  | null |  |  | Content of the user tour - allow for multilang tags
contentformat | SMALLINT | 5 |  |  | 0 |  |  |
targettype | TINYINT | 3 |  |  | null |  |  | Type of the target (e.g. block, CSS selector, etc.)
targetvalue | LONGTEXT | 2147483647 |  |  | null |  |  | The value for the specified target type.
sortorder | BIGINT | 19 |  |  | 0 |  |  |
configdata | LONGTEXT | 2147483647 |  |  | null |  |  |

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
tooluserstep_tou_ix | Performance | Asc | tourid
tooluserstep_tousor_ix | Performance | Asc/Asc | tourid + sortorder

### Relationships