mlandauer/cuttlefish

Simplify database schema by getting rid of emails table

Opened this issue · 0 comments

Cuttlefish is focused on transactional email which almost always has a single recipient. So, in most cases we have a single email record which one delivery record attached. We could simplify things, only incurring a little extra overhead if we move all the data from the email table to the delivery table and get rid of the emails table.

So, when a user sends an email to multiple recipients it will get turned into two deliveries with duplicated data. This doesn't seem so bad.