Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 6203:a3fb76cf79b6 double-precision
backout backout as it is now safely in a branch
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Wed, 05 Jun 2013 11:56:38 +0200 |
| parents | dc166b225775 |
| children | 7fb0e755e4fa |
comparison
equal
deleted
inserted
replaced
| 6201:dc166b225775 | 6203:a3fb76cf79b6 |
|---|---|
| 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 |