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
content LONGTEXT 2147483647 null
targettype TINYINT 3 null
targetvalue LONGTEXT 2147483647 null
sortorder BIGINT 19 0
configdata LONGTEXT 2147483647 null

Indexes

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

Relationships