Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 8018:ad614eff7a9b
SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 09 Jul 2014 15:51:31 +0200 |
| parents | bcb05a98bb3f |
| children | aa8dcf7331a8 |
comparison
equal
deleted
inserted
replaced
| 8017:bcb05a98bb3f | 8018:ad614eff7a9b |
|---|---|
| 308 ); | 308 ); |
| 309 | 309 |
| 310 | 310 |
| 311 CREATE SEQUENCE SEDIMENT_LOAD_ID_SEQ; | 311 CREATE SEQUENCE SEDIMENT_LOAD_ID_SEQ; |
| 312 | 312 |
| 313 CREATE TABLE sediment_loads ( | 313 CREATE TABLE sediment_load ( |
| 314 id int NOT NULL, | 314 id int NOT NULL, |
| 315 grain_fraction_id int NOT NULL, | 315 grain_fraction_id int NOT NULL, |
| 316 time_interval_id int NOT NULL, | 316 time_interval_id int NOT NULL, |
| 317 sq_time_interval_id int, | 317 sq_time_interval_id int, |
| 318 description VARCHAR(256), | 318 description VARCHAR(256), |