Remove the status column from the message table. Instead, use the status of the most recent send attempt for that message.