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