Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-minfo.sql @ 5510:d4bee6d5c866
merged
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Thu, 28 Mar 2013 16:51:32 +0100 |
| parents | db6c7268b08e |
| children | 88cbe798cbab |
comparison
equal
deleted
inserted
replaced
| 5509:627584bc0586 | 5510:d4bee6d5c866 |
|---|---|
| 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 |