Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-minfo.sql @ 7352:c6825778de1f
Merged double-precision branch.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Wed, 16 Oct 2013 13:03:13 +0200 |
| parents | 63a24b4fbebf |
| children | 5b5a2cc8210f |
comparison
equal
deleted
inserted
replaced
| 7350:760ea7f08455 | 7352:c6825778de1f |
|---|---|
| 177 CREATE TABLE discharge_zone ( | 177 CREATE TABLE discharge_zone ( |
| 178 id int NOT NULL, | 178 id int NOT NULL, |
| 179 river_id int NOT NULL, | 179 river_id int NOT NULL, |
| 180 gauge_name VARCHAR(64) NOT NULL, -- this is not very proper, but there are gauges with no db instance | 180 gauge_name VARCHAR(64) NOT NULL, -- this is not very proper, but there are gauges with no db instance |
| 181 value NUMERIC NOT NULL, | 181 value NUMERIC NOT NULL, |
| 182 lower_discharge VARCHAR(16) NOT NULL, | 182 lower_discharge VARCHAR(64) NOT NULL, |
| 183 upper_discharge VARCHAR(16), | 183 upper_discharge VARCHAR(64), |
| 184 PRIMARY KEY(id), | 184 PRIMARY KEY(id), |
| 185 CONSTRAINT fk_dz_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE | 185 CONSTRAINT fk_dz_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE |
| 186 ); | 186 ); |
| 187 | 187 |
| 188 | 188 |
| 245 CREATE TABLE grain_fraction ( | 245 CREATE TABLE grain_fraction ( |
| 246 id int NOT NULL, | 246 id int NOT NULL, |
| 247 name VARCHAR(64) NOT NULL, | 247 name VARCHAR(64) NOT NULL, |
| 248 lower NUMERIC, | 248 lower NUMERIC, |
| 249 upper NUMERIC, | 249 upper NUMERIC, |
| 250 PRIMARY KEY (id), | 250 PRIMARY KEY (id) |
| 251 ); | 251 ); |
| 252 | 252 |
| 253 | 253 |
| 254 CREATE SEQUENCE SEDIMENT_YIELD_ID_SEQ; | 254 CREATE SEQUENCE SEDIMENT_YIELD_ID_SEQ; |
| 255 | 255 |