rel.txt

                                                                                                   +---------+
                                                                                   +------------+1 |locations| 1+----------+
                                                                                   +               +---------+             +
                                                                                   *                                       *

       +--------+        +--------------------------------------+     +-----------------------------+     +---------------------------+
       |charts  |        |indicators                            |     |indicator_data               |     |data                       |
       +--------+ 1+--+* +--------------------------------------+     +-----------------------------+     +---------------------------+
       |id (pk) |        |id (pk)                               |     |location_id (fk: locations)  |     |location_id (fk: locations)|
       |name [s]|        |chart_id (fk: charts)                 |     |indicator_id (fk: indicators)|     |highlight_outline [b]      |
       +--------+        |category_id (fk: categories)          |     |data [j]                     |     |marker_lat [n]             |
                         |indicator_type_id (fk: indicator_type)|     +-----------------------------+     |marker_lng [b]             |
+---------------+        |name [s]                              |                                         |data [j]                   |
|indicator_types|        |summary_list [b]                      |                                         +---------------------------+
+---------------+ 1+--+* |on_map [b]                            | 1+----------------+
|id (pk)        |        |omit_from_detailed_^iew [b]           |                   +
|name [s]       |        |show_in_dashboard [b]                 |                   *
+---------------+        +--------------------------------------+
                                                                      +-----------------------------+
     +----------+          *                                          |legend_items                 |
     |categories|          +                                          +-----------------------------+
     +----------+ 1+-------+                                          |id (pk)                      |
     |id (pk)   |                                                     |indicator_id (fk: indicators)|
     |name [s]  |                                                     |name [s]                     |
     +----------+                                                     |color [s]                    |
                                                                      +-----------------------------+