tool_usertours_steps

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 9 of 9 entries

Indexes

Search:

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

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation