Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 6200:53fca3392c9f
Schema change and Importer: use double to prevent rounding at import time
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Fri, 24 May 2013 16:03:52 +0200 |
| parents | 2d16f4a0bdcc |
| children | dc166b225775 |
comparison
equal
deleted
inserted
replaced
| 6091:75a38bc6baf2 | 6200:53fca3392c9f |
|---|---|
| 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 |