Totara Core Certification Vis Map Table Schema (totara_core_certification_vis_map)


Description

Certification view hidden capability to role map

totara_core_certification_vis_map table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
programid BIGINT 19 null
prog.id totacorecertvismap_pro2_fk R
roleid BIGINT 19 null
role.id totacorecertvismap_rol2_fk R

Table contained -1 rows

totara_core_certification_vis_map table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totacorecertvismap_pro_ix Performance Asc programid
totacorecertvismap_prorol_uix Must be unique Asc/Asc programid + roleid
totacorecertvismap_rol_ix Performance Asc roleid

totara_core_certification_vis_map table relationships

Close relationships within degrees of separation