Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 2833:5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
flys-backend/trunk@4259 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 18 Apr 2012 08:54:55 +0000 |
| parents | 4074777afcfa |
| children | daba3f895eb3 |
comparison
equal
deleted
inserted
replaced
| 2832:ac5bd90697c1 | 2833:5b54a648f702 |
|---|---|
| 172 CREATE SEQUENCE DISCHARGE_ZONE_ID_SEQ; | 172 CREATE SEQUENCE DISCHARGE_ZONE_ID_SEQ; |
| 173 | 173 |
| 174 CREATE TABLE discharge_zone ( | 174 CREATE TABLE discharge_zone ( |
| 175 id NUMBER(38,0) NOT NULL, | 175 id NUMBER(38,0) NOT NULL, |
| 176 river_id NUMBER(38,0) NOT NULL, | 176 river_id NUMBER(38,0) NOT NULL, |
| 177 named_main_value_id NUMBER(38,0) NOT NULL, | |
| 178 gauge_name VARCHAR(64) NOT NULL, -- this is not very proper, but there are gauges with no db instance | 177 gauge_name VARCHAR(64) NOT NULL, -- this is not very proper, but there are gauges with no db instance |
| 179 lower_factor NUMBER(38,2) NOT NULL, | 178 value NUMBER(38,3) NOT NULL, |
| 180 upper_factor NUMBER(38,2) NOT NULL, | 179 lower_discharge VARCHAR(16) NOT NULL, |
| 181 PRIMARY KEY(id), | 180 upper_discharge VARCHAR(16), |
| 182 CONSTRAINT fk_dz_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), | 181 PRIMARY KEY(id), |
| 183 CONSTRAINT fk_dz_nmv_id FOREIGN KEY (named_main_value_id) REFERENCES named_main_values(id) | 182 CONSTRAINT fk_dz_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) |
| 184 ); | 183 ); |
| 185 | 184 |
| 186 | 185 |
| 187 CREATE SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ; | 186 CREATE SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ; |
| 188 | 187 |