Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 8554:3a0522f1a532
Morphological width imported and stored with heights is redundant to table morphologic_width.
| author | "Tom Gottfried <tom@intevation.de>" |
|---|---|
| date | Mon, 16 Feb 2015 09:00:08 +0100 |
| parents | ffbeffe2d266 |
| children | 6d8d7425a6b5 |
comparison
equal
deleted
inserted
replaced
| 8553:17c476e90c07 | 8554:3a0522f1a532 |
|---|---|
| 67 station DOUBLE PRECISION NOT NULL, | 67 station DOUBLE PRECISION NOT NULL, |
| 68 height DOUBLE PRECISION, | 68 height DOUBLE PRECISION, |
| 69 uncertainty DOUBLE PRECISION, | 69 uncertainty DOUBLE PRECISION, |
| 70 data_gap DOUBLE PRECISION, | 70 data_gap DOUBLE PRECISION, |
| 71 sounding_width DOUBLE PRECISION, | 71 sounding_width DOUBLE PRECISION, |
| 72 width DOUBLE PRECISION, | |
| 73 PRIMARY KEY(id), | 72 PRIMARY KEY(id), |
| 74 UNIQUE (station, bed_height_single_id), | 73 UNIQUE (station, bed_height_single_id), |
| 75 CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id) ON DELETE CASCADE | 74 CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id) ON DELETE CASCADE |
| 76 ); | 75 ); |
| 77 | 76 |