Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 758:bf16268629d9
Added 'Kanten' model
flys-backend/trunk@2106 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Tue, 14 Jun 2011 12:34:08 +0000 |
| parents | a29fd0916803 |
| children | 8076f6a689d0 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Wed Jun 08 19:03:44 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Tue Jun 14 12:34:08 2011 +0000 @@ -36,6 +36,15 @@ value VARCHAR(256) NOT NULL UNIQUE ); +-- Kante 'oben', 'unten' +CREATE SEQUENCE EDGES_ID_SEQ; + +CREATE TABLE edges ( + id int PRIMARY KEY NOT NULL, + top NUMERIC, + bottom NUMERIC +); + -- Some object (eg. Hafen) at a segment of river -- plus its position. CREATE SEQUENCE ANNOTATIONS_ID_SEQ; @@ -44,7 +53,8 @@ id int PRIMARY KEY NOT NULL, range_id int NOT NULL REFERENCES ranges(id), attribute_id int NOT NULL REFERENCES attributes(id), - position_id int REFERENCES positions(id) + position_id int REFERENCES positions(id), + edge_id int REFERENCES edges(id) ); -- Pegel