Message Conversations Table Schema (message_conversations)


Description

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
context.id 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

Close relationships within degrees of separation