Message Conversations table / message_conversations - Moodle LMS 3.9 Database schema / Zoola Analytics

message_conversations table columns

Related columns Constraint Comments

Search:

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

Showing 1 to 11 of 11 entries

Table contained -1 rows

message_conversations table indexes

Search:

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

Showing 1 to 5 of 5 entries

Message Conversations Table Schema (message_conversations)

Description

message_conversations table columns

message_conversations table indexes

message_conversations table relationships

Close relationships within degrees of separation