message_conversations

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_fkR
message_conversation_members.conversationid	messconvmemb_con2_fkR
message_email_messages.conversationid	messemaimess_con2_fkR
messages.conversationid	mess_con2_fkR

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_con2_fkR

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

enabled

BIT

1

0

timecreated

BIGINT

19

null

Showing 1 to 10 of 11 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
messconv_comiteitecon2_ix	Performance	Asc/Asc/Asc/Asc	component + itemtype + itemid + contextid
messconv_con3_ix	Performance	Asc	convhash
messconv_con5_ix	Performance	Asc	contextid
messconv_typ2_ix	Performance	Asc	type

Showing 1 to 5 of 5 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation