Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-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 |
|---|---|
| 309 ); | 309 ); |
| 310 | 310 |
| 311 | 311 |
| 312 CREATE SEQUENCE SEDIMENT_LOAD_ID_SEQ; | 312 CREATE SEQUENCE SEDIMENT_LOAD_ID_SEQ; |
| 313 | 313 |
| 314 CREATE TABLE sediment_loads ( | 314 CREATE TABLE sediment_load ( |
| 315 id int NOT NULL, | 315 id int NOT NULL, |
| 316 grain_fraction_id int NOT NULL, | 316 grain_fraction_id int NOT NULL, |
| 317 time_interval_id int NOT NULL, | 317 time_interval_id int NOT NULL, |
| 318 sq_time_interval_id int, | 318 sq_time_interval_id int, |
| 319 description VARCHAR(256), | 319 description VARCHAR(256), |