Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 2844:c4db0f75a94a
Prepared the importer to import MINFO specific waterlevel values and added a stub for a parser.
flys-backend/trunk@4287 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 24 Apr 2012 11:16:06 +0000 |
| parents | 6be2bf2492f9 |
| children | c1c6c9190636 |
comparison
equal
deleted
inserted
replaced
| 2843:6a9f45697f81 | 2844:c4db0f75a94a |
|---|---|
| 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,0) NOT NULL, | 312 station NUMBER(38,3) NOT NULL, |
| 313 w NUMBER(38,0) NOT NULL, | 313 w NUMBER(38,2) NOT NULL, |
| 314 PRIMARY KEY (id), | 314 PRIMARY KEY (id), |
| 315 CONSTRAINT fk_wv_waterlevel_q_range_id FOREIGN KEY (waterlevel_q_range_id) REFERENCES waterlevel_q_range(id) | 315 CONSTRAINT fk_wv_waterlevel_q_range_id FOREIGN KEY (waterlevel_q_range_id) REFERENCES waterlevel_q_range(id) |
| 316 ); | 316 ); |
| 317 | 317 |