Tool Usertours Steps table / tool_usertours_steps - Totara Learn 12 Database schema / Zoola Analytics

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

Showing 1 to 8 of 8 entries

Table contained -1 rows

tool_usertours_steps table indexes

Search:

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

Showing 1 to 3 of 3 entries

tool_usertours_steps table relationships

Close relationships within degrees of separation

One

Tool Usertours Steps Table Schema (tool_usertours_steps)

Description

tool_usertours_steps table columns

tool_usertours_steps table indexes

tool_usertours_steps table relationships

Close relationships within degrees of separation