Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle.sql @ 3470:3442304b430a
Adjusted official lines views schemata to include wst column pos.
flys-backend/trunk@5031 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Wed, 18 Jul 2012 09:24:51 +0000 |
| parents | 790c12c55abb |
| children | 948c7289fc42 |
comparison
equal
deleted
inserted
replaced
| 3469:09e906487024 | 3470:3442304b430a |
|---|---|
| 423 CREATE VIEW official_lines | 423 CREATE VIEW official_lines |
| 424 AS | 424 AS |
| 425 SELECT w.river_id AS river_id, | 425 SELECT w.river_id AS river_id, |
| 426 w.id AS wst_id, | 426 w.id AS wst_id, |
| 427 wc.id AS wst_column_id, | 427 wc.id AS wst_column_id, |
| 428 wc.name AS name | 428 wc.name AS name, |
| 429 wc.position AS wst_column_pos | |
| 429 FROM wsts w | 430 FROM wsts w |
| 430 JOIN wst_columns wc | 431 JOIN wst_columns wc |
| 431 ON wc.wst_id = w.id | 432 ON wc.wst_id = w.id |
| 432 WHERE w.kind = 3; | 433 WHERE w.kind = 3; |
| 433 | 434 |
| 463 gauge_id, | 464 gauge_id, |
| 464 gauge_name, | 465 gauge_name, |
| 465 a, | 466 a, |
| 466 b, | 467 b, |
| 467 ol.name, | 468 ol.name, |
| 468 value | 469 value, |
| 470 wst_column_pos | |
| 469 FROM official_lines ol | 471 FROM official_lines ol |
| 470 JOIN q_main_values qmv | 472 JOIN q_main_values qmv |
| 471 ON ol.river_id = qmv.river_id | 473 ON ol.river_id = qmv.river_id |
| 472 AND ol.name = qmv.name; | 474 AND ol.name = qmv.name; |