Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-minfo.sql @ 3329:cc8fc6b29649
Store sq relations into database after parsing.
flys-backend/trunk@4647 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 13 Jun 2012 08:12:00 +0000 |
| parents | a2a33eff93aa |
| children | 8f232119011e |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Wed Jun 13 06:22:04 2012 +0000 +++ b/flys-backend/doc/schema/oracle-minfo.sql Wed Jun 13 08:12:00 2012 +0000 @@ -356,9 +356,11 @@ CREATE TABLE sq_relation ( id NUMBER(38,0) NOT NULL, + river_id NUMBER(38,0) NOT NULL, time_interval_id NUMBER(38,0) NOT NULL, description VARCHAR(256), PRIMARY KEY (id), + CONSTRAINT fk_sqr_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), CONSTRAINT fk_sqr_tinterval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) );