Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 2829:4074777afcfa
Added MINFO specific relations for flow velocity measurements.
flys-backend/trunk@4246 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 17 Apr 2012 10:16:21 +0000 |
| parents | ac13e466a55e |
| children | 5b54a648f702 |
comparison
equal
deleted
inserted
replaced
| 2828:ac13e466a55e | 2829:4074777afcfa |
|---|---|
| 211 CONSTRAINT fk_fvv_flow_velocity_model_id FOREIGN KEY (flow_velocity_model_id) REFERENCES flow_velocity_model(id) | 211 CONSTRAINT fk_fvv_flow_velocity_model_id FOREIGN KEY (flow_velocity_model_id) REFERENCES flow_velocity_model(id) |
| 212 ); | 212 ); |
| 213 | 213 |
| 214 | 214 |
| 215 | 215 |
| 216 --CREATE SEQUENCE | 216 CREATE SEQUENCE FV_MEASURE_ID_SEQ; |
| 217 -- | 217 |
| 218 --CREATE TABLE flow_velocity_measurements ( | 218 CREATE TABLE flow_velocity_measurements ( |
| 219 -- | 219 id NUMBER(38,0) NOT NULL, |
| 220 --); | 220 river_id NUMBER(38,0) NOT NULL, |
| 221 -- | 221 description VARCHAR(256), |
| 222 --CREATE SEQUENCE | 222 PRIMARY KEY (id), |
| 223 -- | 223 CONSTRAINT fk_fvm_rivers_id FOREIGN KEY (river_id) REFERENCES rivers(id) |
| 224 --CREATE TABLE flow_velocity_measurements_values ( | 224 ); |
| 225 -- | 225 |
| 226 --); | 226 CREATE SEQUENCE FV_MEASURE_VALUES_ID_SEQ; |
| 227 | |
| 228 CREATE TABLE flow_velocity_measure_values ( | |
| 229 id NUMBER(38,0) NOT NULL, | |
| 230 measurements_id NUMBER(38,0) NOT NULL, | |
| 231 station NUMBER(38,3) NOT NULL, | |
| 232 datetime TIMESTAMP, | |
| 233 w NUMBER(38,3) NOT NULL, | |
| 234 q NUMBER(38,3) NOT NULL, | |
| 235 v NUMBER(38,3) NOT NULL, | |
| 236 description VARCHAR(256), | |
| 237 PRIMARY KEY (id), | |
| 238 CONSTRAINT fk_fvmv_measurements_id FOREIGN KEY (measurements_id) REFERENCES flow_velocity_measurements (id) | |
| 239 ); |