Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 2849:c36106f15ac9
Added missing constraint to relation 'waterlevel_difference'.
flys-backend/trunk@4303 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 26 Apr 2012 09:44:39 +0000 |
| parents | c1c6c9190636 |
| children | a2a33eff93aa |
comparison
equal
deleted
inserted
replaced
| 2848:e7a1d78b66d8 | 2849:c36106f15ac9 |
|---|---|
| 319 CREATE SEQUENCE WATERLEVEL_DIFFERENCE_ID_SEQ; | 319 CREATE SEQUENCE WATERLEVEL_DIFFERENCE_ID_SEQ; |
| 320 | 320 |
| 321 CREATE TABLE waterlevel_difference ( | 321 CREATE TABLE waterlevel_difference ( |
| 322 id NUMBER(38,0) NOT NULL, | 322 id NUMBER(38,0) NOT NULL, |
| 323 river_id NUMBER(38,0) NOT NULL, | 323 river_id NUMBER(38,0) NOT NULL, |
| 324 unit NUMBER(38,0) NOT NULL, | 324 unit_id NUMBER(38,0) NOT NULL, |
| 325 description VARCHAR(256), | 325 description VARCHAR(256), |
| 326 PRIMARY KEY (id), | 326 PRIMARY KEY (id), |
| 327 CONSTRAINT fk_wd_river_id FOREIGN KEY (river_id) REFERENCES rivers (id) | 327 CONSTRAINT fk_wd_river_id FOREIGN KEY (river_id) REFERENCES rivers (id), |
| 328 CONSTRAINT fk_wd_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) | |
| 328 ); | 329 ); |
| 329 | 330 |
| 330 | 331 |
| 331 CREATE SEQUENCE WATERLEVEL_DIFF_COLUMN_ID_SEQ; | 332 CREATE SEQUENCE WATERLEVEL_DIFF_COLUMN_ID_SEQ; |
| 332 | 333 |