Message Email Messages Table Schema (message_email_messages)


Description

Keeps track of what emails to send in an email digest

message_email_messages table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
useridto BIGINT 19 null
user.id messemaimess_use2_fk R
conversationid BIGINT 19 null
message_conversations.id messemaimess_con2_fk R
messageid BIGINT 19 null
messages.id messemaimess_mes2_fk R

Table contained -1 rows

message_email_messages table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
messemaimess_con_ix Performance Asc conversationid
messemaimess_mes_ix Performance Asc messageid
messemaimess_use_ix Performance Asc useridto

message_email_messages table relationships

Close relationships within degrees of separation