Wrong usage of DB array in mentat_main/settings_reporting/emails
As was discussed in VC, the
emails column of table
settings_reporting in the database
mentat_main is declared as a
character varying array, however the upper layer implementation based on Python/SQLAlchemy stores a single string value inside the array, containing comma separated emails. This was identified as a result of an oversight and should be fixed.
In addition, there are both NULL values and empty arrays present in this column, while logically equivalent, they are still distinct values; and although this might be abstracted in the upper layer, it could be improved for consistency in the DB.