Mercurial > dive4elements > river
comparison flys-backend/doc/schema/sqlite.sql @ 164:324e12ab7a05
Converted schema to be PostgreSQL compatible.
flys-backend/trunk@1441 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 09 Mar 2011 14:07:15 +0000 |
| parents | 4a3b2912a0cd |
| children | 15d515fe15f5 |
comparison
equal
deleted
inserted
replaced
| 163:4a3b2912a0cd | 164:324e12ab7a05 |
|---|---|
| 13 ); | 13 ); |
| 14 | 14 |
| 15 -- segments from/to at a river | 15 -- segments from/to at a river |
| 16 CREATE TABLE ranges ( | 16 CREATE TABLE ranges ( |
| 17 id INTEGER PRIMARY KEY NOT NULL, | 17 id INTEGER PRIMARY KEY NOT NULL, |
| 18 river_id INTEGER NOT NULL REFERENCES river(id), | 18 river_id INTEGER NOT NULL REFERENCES rivers(id), |
| 19 a NUMERIC NOT NULL, | 19 a NUMERIC NOT NULL, |
| 20 b NUMERIC, | 20 b NUMERIC, |
| 21 UNIQUE (river_id, a, b) | 21 UNIQUE (river_id, a, b) |
| 22 ); | 22 ); |
| 23 | 23 |
| 38 | 38 |
| 39 -- Pegel | 39 -- Pegel |
| 40 CREATE TABLE gauges ( | 40 CREATE TABLE gauges ( |
| 41 id INTEGER PRIMARY KEY NOT NULL, | 41 id INTEGER PRIMARY KEY NOT NULL, |
| 42 name VARCHAR(256) NOT NULL, | 42 name VARCHAR(256) NOT NULL, |
| 43 river_id INTEGER NOT NULL REFERENCES river(id), | 43 river_id INTEGER NOT NULL REFERENCES rivers(id), |
| 44 station NUMERIC NOT NULL UNIQUE, | 44 station NUMERIC NOT NULL UNIQUE, |
| 45 aeo NUMERIC NOT NULL, | 45 aeo NUMERIC NOT NULL, |
| 46 | 46 |
| 47 -- Pegelnullpunkt | 47 -- Pegelnullpunkt |
| 48 datum NUMERIC NOT NULL, | 48 datum NUMERIC NOT NULL, |
| 109 ); | 109 ); |
| 110 | 110 |
| 111 -- WST files | 111 -- WST files |
| 112 CREATE TABLE wst ( | 112 CREATE TABLE wst ( |
| 113 id INTEGER PRIMARY KEY NOT NULL, | 113 id INTEGER PRIMARY KEY NOT NULL, |
| 114 river_id INTEGER NOT NULL REFERENCES river(id), | 114 river_id INTEGER NOT NULL REFERENCES rivers(id), |
| 115 description VARCHAR(256) NOT NULL, | 115 description VARCHAR(256) NOT NULL, |
| 116 -- TODO: more meta infos | 116 -- TODO: more meta infos |
| 117 UNIQUE (river_id, description) | 117 UNIQUE (river_id, description) |
| 118 ); | 118 ); |
| 119 | 119 |