Mercurial > dive4elements > river
annotate flys-backend/doc/schema/postgresql-minfo.sql @ 4138:1d9c9a3493ea
#904 Use the correct scale to convert discharge table values into [cm].
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Mon, 15 Oct 2012 16:05:20 +0200 |
parents | fc32a4955087 |
children | f63b39799d2d |
rev | line source |
---|---|
2823
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
1 BEGIN; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
2 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
3 CREATE SEQUENCE LOCATION_SYSTEM_SEQ; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
4 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
5 CREATE TABLE location_system ( |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
6 id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
7 name VARCHAR(32) NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
8 description VARCHAR(255), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
9 PRIMARY KEY(id) |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
10 ); |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
11 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
12 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
13 CREATE SEQUENCE ELEVATION_MODEL_SEQ; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
14 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
15 CREATE TABLE elevation_model ( |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
16 id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
17 name VARCHAR(32) NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
18 unit_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
19 PRIMARY KEY(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
20 CONSTRAINT fk_unit FOREIGN KEY (unit_id) REFERENCES units(id) |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
21 ); |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
22 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
23 CREATE SEQUENCE BED_HEIGHT_TYPE_SEQ; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
24 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
25 CREATE TABLE bed_height_type ( |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
26 id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
27 name VARCHAR(16) NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
28 description VARCHAR(255), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
29 PRIMARY KEY(id) |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
30 ); |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
31 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
32 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
33 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
34 CREATE SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
35 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
36 CREATE TABLE bed_height_single ( |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
37 id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
38 river_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
39 year int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
40 sounding_width int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
41 type_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
42 location_system_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
43 cur_elevation_model_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
44 old_elevation_model_id int, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
45 range_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
46 evaluation_by VARCHAR(255), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
47 description VARCHAR(255), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
48 PRIMARY KEY(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
49 CONSTRAINT fk_bed_single_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
50 CONSTRAINT fk_type FOREIGN KEY (type_id) REFERENCES bed_height_type(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
51 CONSTRAINT fk_location_system FOREIGN KEY (location_system_id) REFERENCES location_system(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
52 CONSTRAINT fk_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) REFERENCES elevation_model(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
53 CONSTRAINT fk_old_elevation_model FOREIGN KEY (old_elevation_model_id) REFERENCES elevation_model(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
54 CONSTRAINT fk_range FOREIGN KEY (range_id) REFERENCES ranges(id) |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
55 ); |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
56 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
57 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
58 CREATE SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
59 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
60 CREATE TABLE bed_height_epoch ( |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
61 id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
62 river_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
63 time_interval_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
64 -- sounding_with int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
65 -- type_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
66 cur_elevation_model_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
67 old_elevation_model_id int, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
68 range_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
69 evaluation_by VARCHAR(255), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
70 description VARCHAR(255), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
71 PRIMARY KEY(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
72 CONSTRAINT fk_time_interval FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
73 CONSTRAINT fk_epoch_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) REFERENCES elevation_model(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
74 CONSTRAINT fk_epoch_old_elevation_model FOREIGN KEY (old_elevation_model_id) REFERENCES elevation_model(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
75 CONSTRAINT fk_epoch_range FOREIGN KEY (range_id) REFERENCES ranges(id) |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
76 ); |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
77 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
78 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
79 CREATE SEQUENCE BED_SINGLE_VALUES_ID_SEQ; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
80 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
81 CREATE TABLE bed_height_single_values ( |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
82 id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
83 bed_height_single_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
84 station NUMERIC NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
85 height NUMERIC, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
86 uncertainty NUMERIC, |
3953
fc32a4955087
Towards fix for issue863 (gaps in bedheight data).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
3793
diff
changeset
|
87 data_gap NUMERIC, |
fc32a4955087
Towards fix for issue863 (gaps in bedheight data).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
3793
diff
changeset
|
88 sounding_width NUMERIC, |
fc32a4955087
Towards fix for issue863 (gaps in bedheight data).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
3793
diff
changeset
|
89 width NUMERIC, |
2823
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
90 PRIMARY KEY(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
91 CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id) |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
92 ); |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
93 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
94 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
95 CREATE SEQUENCE BED_EPOCH_VALUES_ID_SEQ; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
96 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
97 CREATE TABLE bed_height_epoch_values ( |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
98 id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
99 bed_height_epoch_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
100 station NUMERIC NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
101 height NUMERIC, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
102 PRIMARY KEY(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
103 CONSTRAINT fk_bed_epoch_values_parent FOREIGN KEY (bed_height_epoch_id) REFERENCES bed_height_epoch(id) |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
104 ); |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
105 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
106 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
107 CREATE SEQUENCE DEPTHS_ID_SEQ; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
108 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
109 CREATE TABLE depths ( |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
110 id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
111 lower NUMERIC NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
112 upper NUMERIC NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
113 unit_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
114 PRIMARY KEY(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
115 CONSTRAINT fk_depths_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
116 ); |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
117 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
118 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
119 CREATE SEQUENCE SEDIMENT_DENSITY_ID_SEQ; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
120 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
121 CREATE TABLE sediment_density ( |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
122 id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
123 river_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
124 depth_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
125 unit_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
126 description VARCHAR(256), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
127 PRIMARY KEY(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
128 CONSTRAINT fk_sd_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
129 CONSTRAINT fk_sd_depth_id FOREIGN KEY (depth_id) REFERENCES depths(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
130 CONSTRAINT fk_sd_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
131 ); |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
132 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
133 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
134 CREATE SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
135 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
136 CREATE TABLE sediment_density_values ( |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
137 id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
138 sediment_density_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
139 station NUMERIC NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
140 density NUMERIC NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
141 description VARCHAR(256), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
142 PRIMARY KEY(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
143 CONSTRAINT fk_sdv_sediment_density_id FOREIGN KEY(sediment_density_id) REFERENCES sediment_density(id) |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
144 ); |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
145 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
146 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
147 CREATE SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
148 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
149 CREATE TABLE morphologic_width ( |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
150 id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
151 river_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
152 unit_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
153 PRIMARY KEY(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
154 CONSTRAINT fk_mw_river_id FOREIGN KEY(river_id) REFERENCES rivers(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
155 CONSTRAINT fk_mw_unit_id FOREIGN KEY(unit_id) REFERENCES units(id) |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
156 ); |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
157 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
158 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
159 CREATE SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ; |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
160 |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
161 CREATE TABLE morphologic_width_values ( |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
162 id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
163 morphologic_width_id int NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
164 station NUMERIC NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
165 width NUMERIC NOT NULL, |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
166 description VARCHAR(256), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
167 PRIMARY KEY(id), |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
168 CONSTRAINT fk_mwv_morphologic_width_id FOREIGN KEY (morphologic_width_id) REFERENCES morphologic_width(id) |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
169 ); |
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
170 |
2858
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
171 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
172 CREATE SEQUENCE DISCHARGE_ZONE_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
173 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
174 CREATE TABLE discharge_zone ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
175 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
176 river_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
177 gauge_name VARCHAR(64) NOT NULL, -- this is not very proper, but there are gauges with no db instance |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
178 value NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
179 lower_discharge VARCHAR(16) NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
180 upper_discharge VARCHAR(16), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
181 PRIMARY KEY(id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
182 CONSTRAINT fk_dz_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
183 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
184 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
185 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
186 CREATE SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
187 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
188 CREATE TABLE flow_velocity_model ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
189 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
190 river_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
191 discharge_zone_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
192 description VARCHAR(256), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
193 PRIMARY KEY (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
194 CONSTRAINT fk_fvm_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
195 CONSTRAINT fk_fvm_discharge_zone_id FOREIGN KEY (discharge_zone_id) REFERENCES discharge_zone (id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
196 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
197 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
198 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
199 CREATE SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
200 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
201 CREATE TABLE flow_velocity_model_values ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
202 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
203 flow_velocity_model_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
204 station NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
205 q NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
206 total_channel NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
207 main_channel NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
208 shear_stress NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
209 PRIMARY KEY(id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
210 CONSTRAINT fk_fvv_flow_velocity_model_id FOREIGN KEY (flow_velocity_model_id) REFERENCES flow_velocity_model(id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
211 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
212 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
213 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
214 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
215 CREATE SEQUENCE FV_MEASURE_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
216 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
217 CREATE TABLE flow_velocity_measurements ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
218 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
219 river_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
220 description VARCHAR(256), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
221 PRIMARY KEY (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
222 CONSTRAINT fk_fvm_rivers_id FOREIGN KEY (river_id) REFERENCES rivers(id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
223 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
224 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
225 CREATE SEQUENCE FV_MEASURE_VALUES_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
226 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
227 CREATE TABLE flow_velocity_measure_values ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
228 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
229 measurements_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
230 station NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
231 datetime TIMESTAMP, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
232 w NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
233 q NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
234 v NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
235 description VARCHAR(256), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
236 PRIMARY KEY (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
237 CONSTRAINT fk_fvmv_measurements_id FOREIGN KEY (measurements_id) REFERENCES flow_velocity_measurements (id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
238 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
239 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
240 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
241 CREATE SEQUENCE GRAIN_FRACTION_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
242 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
243 CREATE TABLE grain_fraction ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
244 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
245 name VARCHAR(64) NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
246 lower NUMERIC, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
247 upper NUMERIC, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
248 unit_id int, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
249 PRIMARY KEY (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
250 CONSTRAINT fk_gf_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
251 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
252 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
253 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
254 CREATE SEQUENCE SEDIMENT_YIELD_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
255 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
256 CREATE TABLE sediment_yield ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
257 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
258 river_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
259 grain_fraction_id int, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
260 unit_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
261 time_interval_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
262 description VARCHAR(256), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
263 PRIMARY KEY (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
264 CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
265 CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
266 CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
267 CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
268 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
269 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
270 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
271 CREATE SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
272 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
273 CREATE TABLE sediment_yield_values ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
274 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
275 sediment_yield_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
276 station NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
277 value NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
278 PRIMARY KEY (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
279 CONSTRAINT fk_syv_sediment_yield_id FOREIGN KEY (sediment_yield_id) REFERENCES sediment_yield(id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
280 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
281 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
282 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
283 CREATE SEQUENCE WATERLEVEL_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
284 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
285 CREATE TABLE waterlevel ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
286 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
287 river_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
288 unit_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
289 description VARCHAR(256), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
290 PRIMARY KEY (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
291 CONSTRAINT fk_w_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
292 CONSTRAINT fk_w_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
293 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
294 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
295 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
296 CREATE SEQUENCE WATERLEVEL_Q_RANGES_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
297 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
298 CREATE TABLE waterlevel_q_range ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
299 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
300 waterlevel_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
301 q NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
302 PRIMARY KEY (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
303 CONSTRAINT fk_wqr_waterlevel_id FOREIGN KEY (waterlevel_id) REFERENCES waterlevel(id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
304 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
305 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
306 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
307 CREATE SEQUENCE WATERLEVEL_VALUES_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
308 |
3793
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
309 CREATE TABLE waterlevel_values ( |
2858
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
310 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
311 waterlevel_q_range_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
312 station NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
313 w NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
314 PRIMARY KEY (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
315 CONSTRAINT fk_wv_waterlevel_q_range_id FOREIGN KEY (waterlevel_q_range_id) REFERENCES waterlevel_q_range(id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
316 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
317 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
318 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
319 CREATE SEQUENCE WATERLEVEL_DIFFERENCE_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
320 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
321 CREATE TABLE waterlevel_difference ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
322 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
323 river_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
324 unit_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
325 description VARCHAR(256), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
326 PRIMARY KEY (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
327 CONSTRAINT fk_wd_river_id FOREIGN KEY (river_id) REFERENCES rivers (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
328 CONSTRAINT fk_wd_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
329 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
330 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
331 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
332 CREATE SEQUENCE WATERLEVEL_DIFF_COLUMN_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
333 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
334 CREATE TABLE waterlevel_difference_column ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
335 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
336 difference_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
337 description VARCHAR(256), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
338 PRIMARY KEY (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
339 CONSTRAINT fk_wdc_difference_id FOREIGN KEY (difference_id) REFERENCES waterlevel_difference (id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
340 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
341 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
342 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
343 CREATE SEQUENCE WATERLEVEL_DIFF_VALUES_ID_SEQ; |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
344 |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
345 CREATE TABLE waterlevel_difference_values ( |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
346 id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
347 column_id int NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
348 station NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
349 value NUMERIC NOT NULL, |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
350 PRIMARY KEY (id), |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
351 CONSTRAINT fk_wdv_column_id FOREIGN KEY (column_id) REFERENCES waterlevel_difference_column (id) |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
352 ); |
c3b2673eafbf
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2823
diff
changeset
|
353 |
3793
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
354 |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
355 CREATE SEQUENCE SQ_RELATION_ID_SEQ; |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
356 |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
357 CREATE TABLE sq_relation ( |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
358 id int NOT NULL, |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
359 river_id int NOT NULL, |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
360 time_interval_id int NOT NULL, |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
361 description VARCHAR(256), |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
362 PRIMARY KEY (id), |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
363 CONSTRAINT fk_sqr_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
364 CONSTRAINT fk_sqr_tinterval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
365 ); |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
366 |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
367 |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
368 CREATE SEQUENCE SQ_RELATION_VALUES_ID_SEQ; |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
369 |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
370 CREATE TABLE sq_relation_value ( |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
371 id int NOT NULL, |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
372 sq_relation_id int NOT NULL, |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
373 parameter VARCHAR(16) NOT NULL, |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
374 fraction VARCHAR(32) NOT NULL, |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
375 function VARCHAR(32) NOT NULL, |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
376 km NUMERIC NOT NULL, |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
377 a NUMERIC NOT NULL, |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
378 b NUMERIC NOT NULL, |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
379 PRIMARY KEY (id), |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
380 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id) |
8f232119011e
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
2858
diff
changeset
|
381 ); |
2823
13b3fcaa1b34
Add MINFO schema for PostgreSQL
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
382 COMMIT; |