messages

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

message_email_messages.messageid	messemaimess_mes2_fkR
message_user_actions.messageid	messuseracti_mes2_fkR

useridfrom

BIGINT

19

null

user.id

mess_use2_fkR

conversationid

BIGINT

19

null

message_conversations.id

mess_con2_fkR

subject

LONGTEXT

2147483647

√

null

fullmessage

LONGTEXT

2147483647

√

null

fullmessageformat

BIT

1

0

fullmessagehtml

LONGTEXT

2147483647

√

null

smallmessage

LONGTEXT

2147483647

√

null

timecreated

BIGINT

19

null

fullmessagetrust

TINYINT

3

0

Showing 1 to 10 of 11 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
mess_con2_ix	Performance	Asc	conversationid
mess_contim2_ix	Performance	Asc/Asc	conversationid + timecreated
mess_use2_ix	Performance	Asc	useridfrom

Showing 1 to 4 of 4 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation