app_context_map

84 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_context_map_id_seq'::regclass)
parentid int8 19 null
childid int8 19 null

Indexes

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

Relationships