Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-minfo.sql @ 8691:bfca77cbf353
(issue1750) There can be only one SQ-relation of a parameter for a time range (given by sq_relation_id) per station and some other attributes might be null.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 17 Apr 2015 14:55:42 +0200 |
parents | 1a4ad0d4231a |
children | 71b17f731762 |
comparison
equal
deleted
inserted
replaced
8690:11c88a2f695a | 8691:bfca77cbf353 |
---|---|
397 ntot int, | 397 ntot int, |
398 noutl int, | 398 noutl int, |
399 cferguson NUMERIC, | 399 cferguson NUMERIC, |
400 cduan NUMERIC, | 400 cduan NUMERIC, |
401 PRIMARY KEY (id), | 401 PRIMARY KEY (id), |
402 UNIQUE(sq_relation_id, measurement_station_id, parameter), | |
402 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) | 403 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) |
403 REFERENCES sq_relation(id) ON DELETE CASCADE, | 404 REFERENCES sq_relation(id) ON DELETE CASCADE, |
404 CONSTRAINT fk_mstation_id FOREIGN KEY (measurement_station_id) | 405 CONSTRAINT fk_mstation_id FOREIGN KEY (measurement_station_id) |
405 REFERENCES measurement_station(id) ON DELETE CASCADE | 406 REFERENCES measurement_station(id) ON DELETE CASCADE |
406 ); | 407 ); |