Fields in alerts are condensed, sometimes dropping information

[mattwigway]

When there is more than one TimeRange in an alert, only the first is used. When there is more than one language available, the language specified on the command line or the string with no language (i.e., the default language for the feed) is used.

This is a tradeoff between creating more tables (to hold repeated elements), placing ugly, difficult to query JSON in the database, or losing some data.

[mattwigway]

To really use third-normal form, like GTFS, additional tables for TimeRange and a message table should be created.