Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 3793:8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
flys-backend/trunk@5433 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Tue, 11 Sep 2012 13:55:08 +0000 |
| parents | cc8fc6b29649 |
| children | fc32a4955087 |
comparison
equal
deleted
inserted
replaced
| 3792:2e993a847e31 | 3793:8f232119011e |
|---|---|
| 243 CREATE TABLE grain_fraction ( | 243 CREATE TABLE grain_fraction ( |
| 244 id NUMBER(38,0) NOT NULL, | 244 id NUMBER(38,0) NOT NULL, |
| 245 name VARCHAR(64) NOT NULL, | 245 name VARCHAR(64) NOT NULL, |
| 246 lower NUMBER(38,3), | 246 lower NUMBER(38,3), |
| 247 upper NUMBER(38,3), | 247 upper NUMBER(38,3), |
| 248 unit_id NUMBER (38,0), | 248 unit_id NUMBER(38,0), |
| 249 PRIMARY KEY (id), | 249 PRIMARY KEY (id), |
| 250 CONSTRAINT fk_gf_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) | 250 CONSTRAINT fk_gf_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) |
| 251 ); | 251 ); |
| 252 | 252 |
| 253 | 253 |
| 304 ); | 304 ); |
| 305 | 305 |
| 306 | 306 |
| 307 CREATE SEQUENCE WATERLEVEL_VALUES_ID_SEQ; | 307 CREATE SEQUENCE WATERLEVEL_VALUES_ID_SEQ; |
| 308 | 308 |
| 309 CREATE TABLE waterlevel_values( | 309 CREATE TABLE waterlevel_values ( |
| 310 id NUMBER(38,0) NOT NULL, | 310 id NUMBER(38,0) NOT NULL, |
| 311 waterlevel_q_range_id NUMBER(38,0) NOT NULL, | 311 waterlevel_q_range_id NUMBER(38,0) NOT NULL, |
| 312 station NUMBER(38,3) NOT NULL, | 312 station NUMBER(38,3) NOT NULL, |
| 313 w NUMBER(38,2) NOT NULL, | 313 w NUMBER(38,2) NOT NULL, |
| 314 PRIMARY KEY (id), | 314 PRIMARY KEY (id), |
| 372 sq_relation_id NUMBER(38,0) NOT NULL, | 372 sq_relation_id NUMBER(38,0) NOT NULL, |
| 373 parameter VARCHAR(16) NOT NULL, | 373 parameter VARCHAR(16) NOT NULL, |
| 374 fraction VARCHAR(32) NOT NULL, | 374 fraction VARCHAR(32) NOT NULL, |
| 375 function VARCHAR(32) NOT NULL, | 375 function VARCHAR(32) NOT NULL, |
| 376 km NUMBER(38,3) NOT NULL, | 376 km NUMBER(38,3) NOT NULL, |
| 377 a NUMBER NOT NULL, | 377 a NUMBER(38, 3) NOT NULL, |
| 378 b NUMBER(38,3) NOT NULL, | 378 b NUMBER(38,3) NOT NULL, |
| 379 PRIMARY KEY (id), | 379 PRIMARY KEY (id), |
| 380 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id) | 380 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id) |
| 381 ); | 381 ); |