From Dev.to
Modelling a shared inbox: why the message is the primary key, not the conversation
Every shared-inbox implementation starts with a conversations table and ends up regretting it. Here is the model that survives contact with real support traffic. A conversation is a derived thing. It...