Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 7352:c6825778de1f
Merged double-precision branch.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Wed, 16 Oct 2013 13:03:13 +0200 |
| parents | c14e17dabf39 |
| children | 5b5a2cc8210f |
comparison
equal
deleted
inserted
replaced
| 7350:760ea7f08455 | 7352:c6825778de1f |
|---|---|
| 83 CREATE SEQUENCE BED_SINGLE_VALUES_ID_SEQ; | 83 CREATE SEQUENCE BED_SINGLE_VALUES_ID_SEQ; |
| 84 | 84 |
| 85 CREATE TABLE bed_height_single_values ( | 85 CREATE TABLE bed_height_single_values ( |
| 86 id NUMBER(38,0) NOT NULL, | 86 id NUMBER(38,0) NOT NULL, |
| 87 bed_height_single_id NUMBER(38,0) NOT NULL, | 87 bed_height_single_id NUMBER(38,0) NOT NULL, |
| 88 station NUMBER(38,2) NOT NULL, | 88 station DOUBLE PRECISION NOT NULL, |
| 89 height NUMBER(38,2), | 89 height DOUBLE PRECISION, |
| 90 uncertainty NUMBER(38,2), | 90 uncertainty DOUBLE PRECISION, |
| 91 data_gap NUMBER(38,2), | 91 data_gap DOUBLE PRECISION, |
| 92 sounding_width NUMBER(38,2), | 92 sounding_width DOUBLE PRECISION, |
| 93 width NUMBER(38,2), | 93 width DOUBLE PRECISION, |
| 94 PRIMARY KEY(id), | 94 PRIMARY KEY(id), |
| 95 UNIQUE (station, bed_height_single_id), | 95 UNIQUE (station, bed_height_single_id), |
| 96 CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id) ON DELETE CASCADE | 96 CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id) ON DELETE CASCADE |
| 97 ); | 97 ); |
| 98 | 98 |
| 177 CREATE TABLE discharge_zone ( | 177 CREATE TABLE discharge_zone ( |
| 178 id NUMBER(38,0) NOT NULL, | 178 id NUMBER(38,0) NOT NULL, |
| 179 river_id NUMBER(38,0) NOT NULL, | 179 river_id NUMBER(38,0) NOT NULL, |
| 180 gauge_name VARCHAR(64) NOT NULL, -- this is not very proper, but there are gauges with no db instance | 180 gauge_name VARCHAR(64) NOT NULL, -- this is not very proper, but there are gauges with no db instance |
| 181 value NUMBER(38,3) NOT NULL, | 181 value NUMBER(38,3) NOT NULL, |
| 182 lower_discharge VARCHAR(16) NOT NULL, | 182 lower_discharge VARCHAR(64) NOT NULL, |
| 183 upper_discharge VARCHAR(16), | 183 upper_discharge VARCHAR(64), |
| 184 PRIMARY KEY(id), | 184 PRIMARY KEY(id), |
| 185 CONSTRAINT fk_dz_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE | 185 CONSTRAINT fk_dz_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE |
| 186 ); | 186 ); |
| 187 | 187 |
| 188 | 188 |
| 245 CREATE TABLE grain_fraction ( | 245 CREATE TABLE grain_fraction ( |
| 246 id NUMBER(38,0) NOT NULL, | 246 id NUMBER(38,0) NOT NULL, |
| 247 name VARCHAR(64) NOT NULL, | 247 name VARCHAR(64) NOT NULL, |
| 248 lower NUMBER(38,3), | 248 lower NUMBER(38,3), |
| 249 upper NUMBER(38,3), | 249 upper NUMBER(38,3), |
| 250 PRIMARY KEY (id), | 250 PRIMARY KEY (id) |
| 251 ); | 251 ); |
| 252 | 252 |
| 253 | 253 |
| 254 CREATE SEQUENCE SEDIMENT_YIELD_ID_SEQ; | 254 CREATE SEQUENCE SEDIMENT_YIELD_ID_SEQ; |
| 255 | 255 |