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