The database design for Foal has been partially updated from classic ponymail, but I don't think it takes full advantage of some of the new features.
Now is the time to make improvements and fix any legacy choices that have been found to be lacking. For example, email addresses should be stored as arrays, and should be stored in various formats. References should be stored as arrays. The original Date: header in emails should be shown as is in the main displays; this means storing it in the mbox index. Some properties have misleading or unclear names. For example 'dbid' could be better named. Where fields appear as both text and keyword, these could be multi-fields, and the names could be better.
