Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 1235:47ce1fab8464 | 1236:324cb486db9f |
|---|---|
| 45 km NUMERIC NOT NULL, | 45 km NUMERIC NOT NULL, |
| 46 HPGP VARCHAR(2) | 46 HPGP VARCHAR(2) |
| 47 ); | 47 ); |
| 48 SELECT AddGeometryColumn('fixpoints', 'geom', 31466, 'POINT', 2); | 48 SELECT AddGeometryColumn('fixpoints', 'geom', 31466, 'POINT', 2); |
| 49 | 49 |
| 50 | |
| 51 CREATE TABLE dgm ( | |
| 52 id SERIAL PRIMARY KEY NOT NULL, | |
| 53 river_id int REFERENCES rivers(id), | |
| 54 -- XXX Should we use the ranges table instead? | |
| 55 lower NUMERIC, | |
| 56 upper NUMERIC, | |
| 57 path VARCHAR(256), | |
| 58 UNIQUE (river_id, lower, upper) | |
| 59 ); | |
| 60 | |
| 50 END; | 61 END; |