Message Conversations Table Schema (message_conversations)


Description

Stores all message conversations

message_conversations table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
message_conversation_members.conversationid messconvmemb_con2_fk R
messages.conversationid mess_con2_fk R
convhash VARCHAR 40
timecreated BIGINT 19 null

Table contained -1 rows

message_conversations table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
messconv_con_uix Must be unique Asc convhash

message_conversations table relationships