Reminder Table Schema (reminder)


Description

Totara course reminders

reminder table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
reminder_message.reminderid Implied Constraint R
reminder_sent.reminderid Implied Constraint R
courseid BIGINT 19 null
course.id Implied Constraint R
title LONGTEXT 2147483647 null
type VARCHAR 10 null
config LONGTEXT 2147483647 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
modifierid BIGINT 19 null
deleted BIT 0 null

Table contained -1 rows

reminder table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
remi_cou_ix Performance Asc courseid
remi_del_ix Performance Asc deleted
remi_typ_ix Performance Asc type

reminder table relationships