Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 6201:dc166b225775
Backed out changeset 53fca3392c9f
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Fri, 24 May 2013 16:26:41 +0200 |
| parents | 53fca3392c9f |
| children | a3fb76cf79b6 df402b3e0281 |
comparison
equal
deleted
inserted
replaced
| 6200:53fca3392c9f | 6201:dc166b225775 |
|---|---|
| 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 DOUBLE PRECISION NOT NULL, | 88 station NUMBER(38,2) NOT NULL, |
| 89 height DOUBLE PRECISION, | 89 height NUMBER(38,2), |
| 90 uncertainty DOUBLE PRECISION, | 90 uncertainty NUMBER(38,2), |
| 91 data_gap DOUBLE PRECISION, | 91 data_gap NUMBER(38,2), |
| 92 sounding_width DOUBLE PRECISION, | 92 sounding_width NUMBER(38,2), |
| 93 width DOUBLE PRECISION, | 93 width NUMBER(38,2), |
| 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 |