Reminder Sent Table Schema (reminder_sent)


Description

Totara course reminders log of messages sent

reminder_sent table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
reminderid BIGINT 19 null
reminder.id Implied Constraint R
messageid BIGINT 19 null
message.id Implied Constraint R
userid BIGINT 19 null
user.id Implied Constraint R
timesent BIGINT 19 null

Table contained -1 rows

reminder_sent table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
remisent_mes_ix Performance Asc messageid
remisent_rem_ix Performance Asc reminderid
remisent_use_ix Performance Asc userid

reminder_sent table relationships

Close relationships within degrees of separation