Data model
Contains the information that can be fetched from the official FDSN registry at https://www.fdsn.org/networks/. We only need the code, the start and end date and the DOI referenced there. DOI and enddate can be empty.
List of datacenters referenced at FDSN in the data center registry at https://www.fdsn.org/datacenters/.
For each network with a DOI, we fetch datacite metadata and store a list of licences as an array or a plain string. We also need to store the date where data is made available. It would also make sense to store the distributor of the data and the landing page of the network.
For each network, there is a StationXML entry in the datacenter that it belongs. We want to store startdate, enddate, doi and restriction from the XML.
Contains all the routing registry of EIDA at https://www.orfeus-eu.org/eidaws/routing/1/query?format=json. For each network record, we want to store startdate, enddate and priority.
A consistency record is the result of the effort of linking records among the tables Fdsn_registry, StationXML, Eida_routing. All records of these 3 tables have to appear exactly once in the consistency table. If a linking is successful the records of these 3 tables appear in the same record in the consistency table. A consistency record is also identified by the time it was made. Each remaining attribute of a consistency record corresponds to one test we are interested to carry out for the network.