diff flys-backend/doc/schema/postgresql-spatial.sql @ 4953:a72e90fc45ed dami

SCHEMA CHANGE: extended hydr_boundaries tables
author Andre Heinecke <aheinecke@intevation.de>
date Fri, 01 Feb 2013 10:41:12 +0100
parents f5c55d7ea07e
children b79eb203032d
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql	Fri Feb 01 10:38:26 2013 +0100
+++ b/flys-backend/doc/schema/postgresql-spatial.sql	Fri Feb 01 10:41:12 2013 +0100
@@ -241,13 +241,14 @@
 ALTER TABLE floodmaps ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) = 'POLYGON'::text OR geometrytype(geom) = 'MULTIPOLYGON'::text);
 ALTER TABLE floodmaps ALTER COLUMN id SET DEFAULT NEXTVAL('FLOODMAPS_ID_SEQ');
 
-
 CREATE SEQUENCE HYDR_BOUNDARIES_ID_SEQ;
 CREATE TABLE hydr_boundaries (
     id         int PRIMARY KEY NOT NULL,
     river_id   int REFERENCES rivers(id),
     name       VARCHAR(255),
-    kind       int,
+    kind       int, -- 1 BfG / 2 Land / 3 Sonstige
+    sectie     int, -- 1 stromführend / 2 stromspeichernd
+    sobek      int, -- 1 Flussschlauch / 2 Uferbank / 3 Überflutungsbereich
     path       VARCHAR(256)
 );
 SELECT AddGeometryColumn('hydr_boundaries','geom',31467,'LINESTRING',3);
@@ -259,7 +260,9 @@
     id         int PRIMARY KEY NOT NULL,
     river_id   int REFERENCES rivers(id),
     name       VARCHAR(255),
-    kind       int,
+    kind       int, -- 1 BfG / 2 Land / 3 Sonstige
+    sectie     int, -- 1 Flussschlauch / 2 Uferbank / 3 Überflutungsbereich
+    sobek      int, -- 1 stromführend / 2 stromspeichernd
     path       VARCHAR(256)
 );
 SELECT AddGeometryColumn('hydr_boundaries_poly','geom',31467,'POLYGON',3);

http://dive4elements.wald.intevation.org