Totara Navigation Table Schema (totara_navigation)


Description

Totara navigation menu

totara_navigation table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
totara_navigation_settings.itemid totanavisett_ite2_fk R
parentid BIGINT 19 0
title VARCHAR 1024
url VARCHAR 255 null
classname VARCHAR 255 null
sortorder BIGINT 19 null
depth BIT 0 1
path VARCHAR 50 null
custom BIT 0 1
customtitle BIT 0 1
visibility BIT 0 0
visibilityold BIT 0 null

Stores the last visibility state

targetattr VARCHAR 100
timemodified BIGINT 19 0

Table contained -1 rows

totara_navigation table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totanavi_par_ix Performance Asc parentid
totanavi_sor_ix Performance Asc sortorder

totara_navigation table relationships