# message_conversations

0 rows

### Description

Stores all message conversations

### Columns

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 |  |  |
timemodified | BIGINT | 19 | √ |  | null |  |  |

### 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

### Relationships