relationship tables were created

n:m (many to many) relationships will be modeled with a third table holding the ids of the two related tables.
Naming conventions for such tables are described here:
https://stackoverflow.com/questions/1813321/what-should-i-name-a-table-that-maps-two-tables-together
This will result in the following tables:

• stationmeta_core_stationmeta_roles
• stationmeta_core_stationmeta_annotations
• timeseries_timeseries_roles
• timeseries_timeseries_annotations
• timeseries_timeseries_programmes