Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-minfo.sql @ 5455:45c5b8b08ffd
Schema Change: use parameter instead of fraction in sq_relation_value
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Wed, 27 Mar 2013 12:45:52 +0100 |
| parents | 303701ab73c6 |
| children | e47c4e9b050e |
comparison
equal
deleted
inserted
replaced
| 5454:662bcb3bdfd7 | 5455:45c5b8b08ffd |
|---|---|
| 319 | 319 |
| 320 CREATE TABLE sq_relation_value ( | 320 CREATE TABLE sq_relation_value ( |
| 321 id int NOT NULL, | 321 id int NOT NULL, |
| 322 sq_relation_id int NOT NULL, | 322 sq_relation_id int NOT NULL, |
| 323 measurement_station_id int NOT NULL, | 323 measurement_station_id int NOT NULL, |
| 324 fraction VARCHAR(32) NOT NULL, | 324 parameter VARCHAR(1) NOT NULL, |
| 325 a NUMERIC NOT NULL, | 325 a NUMERIC NOT NULL, |
| 326 b NUMERIC NOT NULL, | 326 b NUMERIC NOT NULL, |
| 327 qmax NUMERIC, | 327 qmax NUMERIC, |
| 328 rsq NUMERIC, | 328 rsq NUMERIC, |
| 329 ntot int, | 329 ntot int, |