Context Map Table Schema (context_map)


Description

Map context hierarchy into a flat structure to make parent-child queries in Totara SQL access more efficient

context_map table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
parentid BIGINT 19 null

ID of parent context

childid BIGINT 19 null

ID of child context

Table contained -1 rows

context_map table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
contmap_parchi_uix Must be unique Asc/Asc parentid + childid