Reminder Message Table Schema (reminder_message)


Description

Totara course reminder messages

reminder_message table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
reminderid BIGINT 19 null
reminder.id Implied Constraint R
type VARCHAR 10 null
period BIGINT 19 null
copyto LONGTEXT 2147483647 null
subject LONGTEXT 2147483647 null
message LONGTEXT 2147483647 null
deleted BIT 1 null

Table contained -1 rows

reminder_message table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
remimess_del_ix Performance Asc deleted
remimess_rem_ix Performance Asc reminderid
remimess_typ_ix Performance Asc type

reminder_message table relationships