Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-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 NUMBER(38,0) NOT NULL, | 321 id NUMBER(38,0) NOT NULL, |
| 322 sq_relation_id NUMBER(38,0) NOT NULL, | 322 sq_relation_id NUMBER(38,0) NOT NULL, |
| 323 measurement_station_id NUMBER(38,0) NOT NULL, | 323 measurement_station_id NUMBER(38,0) NOT NULL, |
| 324 fraction VARCHAR(32) NOT NULL, | 324 parameter VARCHAR(1) NOT NULL, |
| 325 a NUMBER(38,20) NOT NULL, | 325 a NUMBER(38,20) NOT NULL, |
| 326 b NUMBER(38,20) NOT NULL, | 326 b NUMBER(38,20) NOT NULL, |
| 327 qmax NUMBER(38,20), | 327 qmax NUMBER(38,20), |
| 328 rsq NUMBER(38,3), | 328 rsq NUMBER(38,3), |
| 329 ntot NUMBER(38,0), | 329 ntot NUMBER(38,0), |