Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 2828:ac13e466a55e
Added a parser for flow velocity model data and adjusted the db relation schema (missing q column).
flys-backend/trunk@4245 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 17 Apr 2012 09:37:52 +0000 |
| parents | 85b2b5e7377f |
| children | 4074777afcfa |
comparison
equal
deleted
inserted
replaced
| 2827:85b25e74594f | 2828:ac13e466a55e |
|---|---|
| 201 | 201 |
| 202 CREATE TABLE flow_velocity_model_values ( | 202 CREATE TABLE flow_velocity_model_values ( |
| 203 id NUMBER(38,0) NOT NULL, | 203 id NUMBER(38,0) NOT NULL, |
| 204 flow_velocity_model_id NUMBER(38,0) NOT NULL, | 204 flow_velocity_model_id NUMBER(38,0) NOT NULL, |
| 205 station NUMBER(38,3) NOT NULL, | 205 station NUMBER(38,3) NOT NULL, |
| 206 q NUMBER(38,3) NOT NULL, | |
| 206 total_channel NUMBER(38,3) NOT NULL, | 207 total_channel NUMBER(38,3) NOT NULL, |
| 207 main_channel NUMBER(38,3) NOT NULL, | 208 main_channel NUMBER(38,3) NOT NULL, |
| 208 shear_stress NUMBER(38,3) NOT NULL, | 209 shear_stress NUMBER(38,3) NOT NULL, |
| 209 PRIMARY KEY(id), | 210 PRIMARY KEY(id), |
| 210 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) |