Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-spatial.sql @ 1237:774dff3ee546
Added relation and hibernate classes for floodplains (german 'Talaue').
flys-backend/trunk@2615 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 31 Aug 2011 08:50:20 +0000 |
| parents | 324cb486db9f |
| children | 35740d675866 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql Wed Aug 31 07:46:59 2011 +0000 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Wed Aug 31 08:50:20 2011 +0000 @@ -48,6 +48,14 @@ SELECT AddGeometryColumn('fixpoints', 'geom', 31466, 'POINT', 2); +-- Talaue +CREATE TABLE floodplain ( + id SERIAL PRIMARY KEY NOT NULL, + river_id int REFERENCES rivers(id) +); +SELECT AddGeometryColumn('floodplain', 'geom', 31466, 'MULTIPOLYGON', 2); + + CREATE TABLE dgm ( id SERIAL PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id),