Message Conversations Table Schema (message_conversations)


Stores all message conversations

message_conversations table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
message_conversation_actions.conversationid messconvacti_con2_fk R
message_conversation_members.conversationid messconvmemb_con2_fk R
message_email_messages.conversationid messemaimess_con2_fk R
messages.conversationid mess_con2_fk R
type BIGINT 19 1
name VARCHAR 255 null
convhash VARCHAR 40 null
component VARCHAR 100 null

Defines the Moodle component which the area was added to

itemtype VARCHAR 100 null
itemid BIGINT 19 null
contextid BIGINT 19 null messconv_con3_fk R

The context id of the itemid or course of the itemtype was added

enabled BIT 1 0
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Table contained -1 rows

message_conversations table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
messconv_comiteitecon_ix Performance Asc/Asc/Asc/Asc component + itemtype + itemid + contextid
messconv_con2_ix Performance Asc contextid
messconv_con_ix Performance Asc convhash
messconv_typ_ix Performance Asc type

message_conversations table relationships