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 |