Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-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 | c3b2673eafbf |
| children | fc32a4955087 |
comparison
equal
deleted
inserted
replaced
| 3792:2e993a847e31 | 3793:8f232119011e |
|---|---|
| 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 int NOT NULL, | 310 id int NOT NULL, |
| 311 waterlevel_q_range_id int NOT NULL, | 311 waterlevel_q_range_id int NOT NULL, |
| 312 station NUMERIC NOT NULL, | 312 station NUMERIC NOT NULL, |
| 313 w NUMERIC NOT NULL, | 313 w NUMERIC NOT NULL, |
| 314 PRIMARY KEY (id), | 314 PRIMARY KEY (id), |
| 349 value NUMERIC NOT NULL, | 349 value NUMERIC NOT NULL, |
| 350 PRIMARY KEY (id), | 350 PRIMARY KEY (id), |
| 351 CONSTRAINT fk_wdv_column_id FOREIGN KEY (column_id) REFERENCES waterlevel_difference_column (id) | 351 CONSTRAINT fk_wdv_column_id FOREIGN KEY (column_id) REFERENCES waterlevel_difference_column (id) |
| 352 ); | 352 ); |
| 353 | 353 |
| 354 | |
| 355 CREATE SEQUENCE SQ_RELATION_ID_SEQ; | |
| 356 | |
| 357 CREATE TABLE sq_relation ( | |
| 358 id int NOT NULL, | |
| 359 river_id int NOT NULL, | |
| 360 time_interval_id int NOT NULL, | |
| 361 description VARCHAR(256), | |
| 362 PRIMARY KEY (id), | |
| 363 CONSTRAINT fk_sqr_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), | |
| 364 CONSTRAINT fk_sqr_tinterval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) | |
| 365 ); | |
| 366 | |
| 367 | |
| 368 CREATE SEQUENCE SQ_RELATION_VALUES_ID_SEQ; | |
| 369 | |
| 370 CREATE TABLE sq_relation_value ( | |
| 371 id int NOT NULL, | |
| 372 sq_relation_id int NOT NULL, | |
| 373 parameter VARCHAR(16) NOT NULL, | |
| 374 fraction VARCHAR(32) NOT NULL, | |
| 375 function VARCHAR(32) NOT NULL, | |
| 376 km NUMERIC NOT NULL, | |
| 377 a NUMERIC NOT NULL, | |
| 378 b NUMERIC NOT NULL, | |
| 379 PRIMARY KEY (id), | |
| 380 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id) | |
| 381 ); | |
| 354 COMMIT; | 382 COMMIT; |