Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-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 | 5f91881124ba |
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 NUMBER(38,0) NOT NULL, | 137 id NUMBER(38,0) NOT NULL, |
| 138 sediment_density_id NUMBER(38,0) NOT NULL, | 138 sediment_density_id NUMBER(38,0) NOT NULL, |
| 139 station NUMBER(38,2) NOT NULL, | 139 station NUMBER(38,2) NOT NULL, |
| 140 shore_offset NUMBER(38,2), | |
| 140 density NUMBER(38,2) NOT NULL, | 141 density NUMBER(38,2) NOT NULL, |
| 141 description VARCHAR(256), | 142 description VARCHAR(256), |
| 142 year NUMBER(38,0), | 143 year NUMBER(38,0), |
| 143 PRIMARY KEY(id), | 144 PRIMARY KEY(id), |
| 144 CONSTRAINT fk_sdv_sediment_density_id FOREIGN KEY(sediment_density_id) REFERENCES sediment_density(id) | 145 CONSTRAINT fk_sdv_sediment_density_id FOREIGN KEY(sediment_density_id) REFERENCES sediment_density(id) |