Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 8560:6fcf4717605f
Meta-data on sounding width associated to bed heights is redundant to real data associated to values.
| author | "Tom Gottfried <tom@intevation.de>" |
|---|---|
| date | Mon, 16 Feb 2015 11:48:05 +0100 |
| parents | 6d8d7425a6b5 |
| children | 3531f0cee5e1 |
comparison
equal
deleted
inserted
replaced
| 8559:6d8d7425a6b5 | 8560:6fcf4717605f |
|---|---|
| 39 | 39 |
| 40 CREATE TABLE bed_height ( | 40 CREATE TABLE bed_height ( |
| 41 id NUMBER(38,0) NOT NULL, | 41 id NUMBER(38,0) NOT NULL, |
| 42 river_id NUMBER(38,0) NOT NULL, | 42 river_id NUMBER(38,0) NOT NULL, |
| 43 year NUMBER(38,0), | 43 year NUMBER(38,0), |
| 44 sounding_width NUMBER(38,0), | |
| 45 type_id NUMBER(38,0) NOT NULL, | 44 type_id NUMBER(38,0) NOT NULL, |
| 46 location_system_id NUMBER(38,0) NOT NULL, | 45 location_system_id NUMBER(38,0) NOT NULL, |
| 47 cur_elevation_model_id NUMBER(38,0) NOT NULL, | 46 cur_elevation_model_id NUMBER(38,0) NOT NULL, |
| 48 old_elevation_model_id NUMBER(38,0), | 47 old_elevation_model_id NUMBER(38,0), |
| 49 range_id NUMBER(38,0), | 48 range_id NUMBER(38,0), |