app_tool_usertours_steps

0 rows


Description

Steps in an tour

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_tool_usertours_steps_id_seq'::regclass)
tourid int8 19 null
app_tool_usertours_tours.id Defined in XMLR
title text 2147483647 null
content text 2147483647 null
targettype int2 5 null
targetvalue text 2147483647 null
sortorder int8 19 0
configdata text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
app_tooluserstep_id_pk Primary key Asc id
app_tooluserstep_tou_ix Performance Asc tourid
app_tooluserstep_tousor_ix Performance Asc/Asc tourid + sortorder

Relationships