0 rows


Steps in an tour


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
tourid BIGINT 19 null 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


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tooluserstep_tou2_ix Performance Asc tourid
tooluserstep_tousor2_ix Performance Asc/Asc tourid + sortorder