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; |