Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 6045:2d16f4a0bdcc
Schema change: there is only one bed height per station at a given point in time
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 16 May 2013 18:03:39 +0200 |
| parents | 5aa05a7a34b7 |
| children | 53fca3392c9f |
comparison
equal
deleted
inserted
replaced
| 6030:d12f920bbf00 | 6045:2d16f4a0bdcc |
|---|---|
| 90 uncertainty NUMBER(38,2), | 90 uncertainty NUMBER(38,2), |
| 91 data_gap NUMBER(38,2), | 91 data_gap NUMBER(38,2), |
| 92 sounding_width NUMBER(38,2), | 92 sounding_width NUMBER(38,2), |
| 93 width NUMBER(38,2), | 93 width NUMBER(38,2), |
| 94 PRIMARY KEY(id), | 94 PRIMARY KEY(id), |
| 95 UNIQUE (station, bed_height_single_id), | |
| 95 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 |
| 96 ); | 97 ); |
| 97 | 98 |
| 98 | 99 |
| 99 CREATE SEQUENCE BED_EPOCH_VALUES_ID_SEQ; | 100 CREATE SEQUENCE BED_EPOCH_VALUES_ID_SEQ; |