Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-minfo.sql @ 5507:db6c7268b08e
Schema change: add shore offset to sediment density values and be more rigid with input files in parser
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Thu, 28 Mar 2013 16:41:30 +0100 |
| parents | d459a885c51f |
| children | 88cbe798cbab |
comparison
equal
deleted
inserted
replaced
| 5506:57f802db5c5a | 5507:db6c7268b08e |
|---|---|
| 135 | 135 |
| 136 CREATE TABLE sediment_density_values ( | 136 CREATE TABLE sediment_density_values ( |
| 137 id int NOT NULL, | 137 id int NOT NULL, |
| 138 sediment_density_id int NOT NULL, | 138 sediment_density_id int NOT NULL, |
| 139 station NUMERIC NOT NULL, | 139 station NUMERIC NOT NULL, |
| 140 shore_offset NUMERIC, | |
| 140 density NUMERIC NOT NULL, | 141 density NUMERIC NOT NULL, |
| 141 description VARCHAR(256), | 142 description VARCHAR(256), |
| 142 year int, | 143 year int, |
| 143 PRIMARY KEY(id), | 144 PRIMARY KEY(id), |
| 144 CONSTRAINT fk_sdv_sediment_density_id FOREIGN KEY(sediment_density_id) REFERENCES sediment_density(id) ON DELETE CASCADE | 145 CONSTRAINT fk_sdv_sediment_density_id FOREIGN KEY(sediment_density_id) REFERENCES sediment_density(id) ON DELETE CASCADE |