Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-spatial.sql @ 1236:324cb486db9f
Added relation and hibernate classes for DGMs.
flys-backend/trunk@2613 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 31 Aug 2011 07:46:59 +0000 |
| parents | e2deda3b77a7 |
| children | 774dff3ee546 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql Tue Aug 30 15:14:59 2011 +0000 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Wed Aug 31 07:46:59 2011 +0000 @@ -47,4 +47,15 @@ ); SELECT AddGeometryColumn('fixpoints', 'geom', 31466, 'POINT', 2); + +CREATE TABLE dgm ( + id SERIAL PRIMARY KEY NOT NULL, + river_id int REFERENCES rivers(id), + -- XXX Should we use the ranges table instead? + lower NUMERIC, + upper NUMERIC, + path VARCHAR(256), + UNIQUE (river_id, lower, upper) +); + END;