app_context

41 rows


Description

one of these must be set

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_context_id_seq'::regclass)
app_block_instances.parentcontextid Defined in XMLR
app_block_positions.contextid Defined in XMLR
app_blog_association.contextid Defined in XMLR
app_cohort.contextid Defined in XMLR
app_enrol_lti_tools.contextid Defined in XMLR
app_external_tokens.contextid Defined in XMLR
app_files.contextid Defined in XMLR
app_filter_active.contextid Defined in XMLR
app_filter_config.contextid Defined in XMLR
app_grading_areas.contextid Defined in XMLR
app_logstore_standard_log.contextid Defined in XMLR
app_notifiable_event_preference.context_id Defined in XMLR
app_notifiable_event_queue.context_id Defined in XMLR
app_notifiable_event_user_preference.context_id Defined in XMLR
app_notification_event_log.context_id Defined in XMLR
app_notification_preference.context_id Defined in XMLR
app_notification_queue.context_id Defined in XMLR
app_question_usages.contextid Defined in XMLR
app_rating.contextid Defined in XMLR
app_reaction.contextid Defined in XMLR
app_role_assignments.contextid Defined in XMLR
app_role_capabilities.contextid Defined in XMLR
app_role_names.contextid Defined in XMLR
app_search_index_requests.contextid Defined in XMLR
app_tag_instance.contextid Defined in XMLR
app_totara_reportedcontent.context_id Defined in XMLR
contextlevel int8 19 0
instanceid int8 19 0
path varchar 255 √ null
depth int2 5 0
parentid int8 19 √ null
tenantid int8 19 √ null
app_tenant.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_cont_id_pk Primary key Asc id
app_cont_conins_uix Must be unique Asc/Asc contextlevel + instanceid
app_cont_ins_ix Performance Asc instanceid
app_cont_par_ix Performance Asc parentid
app_cont_pat_ix Performance Asc path
app_cont_pat_ix_pattern Performance Asc path
app_cont_ten_ix Performance Asc tenantid

Relationships

Close relationships within degrees of separation