Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 5510:d4bee6d5c866
merged
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Thu, 28 Mar 2013 16:51:32 +0100 |
| parents | db6c7268b08e |
| children | 5f91881124ba |
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 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) |