Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 3328:a41f279a66e2 | 3329:cc8fc6b29649 |
|---|---|
| 354 | 354 |
| 355 CREATE SEQUENCE SQ_RELATION_ID_SEQ; | 355 CREATE SEQUENCE SQ_RELATION_ID_SEQ; |
| 356 | 356 |
| 357 CREATE TABLE sq_relation ( | 357 CREATE TABLE sq_relation ( |
| 358 id NUMBER(38,0) NOT NULL, | 358 id NUMBER(38,0) NOT NULL, |
| 359 river_id NUMBER(38,0) NOT NULL, | |
| 359 time_interval_id NUMBER(38,0) NOT NULL, | 360 time_interval_id NUMBER(38,0) NOT NULL, |
| 360 description VARCHAR(256), | 361 description VARCHAR(256), |
| 361 PRIMARY KEY (id), | 362 PRIMARY KEY (id), |
| 363 CONSTRAINT fk_sqr_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), | |
| 362 CONSTRAINT fk_sqr_tinterval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) | 364 CONSTRAINT fk_sqr_tinterval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) |
| 363 ); | 365 ); |
| 364 | 366 |
| 365 | 367 |
| 366 CREATE SEQUENCE SQ_RELATION_VALUES_ID_SEQ; | 368 CREATE SEQUENCE SQ_RELATION_VALUES_ID_SEQ; |