Tool Usertours Steps Table Schema (tool_usertours_steps)


Steps in an tour

tool_usertours_steps table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
tourid BIGINT 19 null tooluserstep_tou2_fk R
title LONGTEXT 2147483647 null

Title of the step

content LONGTEXT 2147483647 null

Content of the user tour - allow for multilang tags

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

Table contained -1 rows

tool_usertours_steps table 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

tool_usertours_steps table relationships