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