Please note that this forum is no longer in use and has been replaced by an online contact us form.

Be assured that the information service rendered by the EEA remains similar. Note that the content of this forum will remain publicly available until the end of 2020. After that we will archive it for internal use for a max retention period of 3 years. Any personal data will be deleted after this retention period.

With kind regards,
EEA Enquiry Service

Please login to participate.
Discussion
.
klo Jan 16, 2015 08:33 PM
Hi,

I'm referencing file "airbase_v8_products.pdf" available at http://www.eea.europa.eu/[…]/airbase-the-european-air-quality-database-8

Quote:
"A 1-to-many relationship between statistics and measurement_configuration tables can be established by
using the fields station_european_code, component_code and measurement_european_group_code."

1. Looking at the tables it seems that 1-to-many relation should be between "measurement_configuration" and "statistics" instead other way around, which is easily noticed as those three fields are not unique in "statistics" table, and by common sense it looks like relation should be opposite from suggested.

2. If above is true, then we can't use "measurement_european_group_code" as key as it is not present in composite PRIMARY KEY in "measurement_configuration" table where we have only "measurement_european_code" which is different from "measurement_european_group_code".

Any suggestions?

Thanks
Replies (1)
EEA Jan 21, 2015 12:00 PM
Hello, I believe you have already received a direct reply to your question. Kind regards.
 
Loading