Mercurial > gemma
changeset 75:ed7a50cfbc19
Add sections and stretches stub and fix comment.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 30 May 2018 17:09:47 +0200 |
parents | 8c0af903a764 |
children | 2a6e49a7b839 |
files | wamos.sql |
diffstat | 1 files changed, 10 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/wamos.sql Wed May 30 16:58:30 2018 +0200 +++ b/wamos.sql Wed May 30 17:09:47 2018 +0200 @@ -101,7 +101,16 @@ -- TODO: add relations to stuff provided as enumerations dummy_attrib varchar, "..." varchar - -- TODO: add real waterway area attributes (DRC 2.1.3) + -- TODO: add real distance mark attributes (DRC 2.1.7) + ); + +CREATE TABLE sections_stretches ( + id varchar PRIMARY KEY, + is_section boolean NOT NULL, -- maps 'function' from interface + stretch isrsrange, + dummy_attrib varchar, + "..." varchar + -- TODO: add real section/stretch attributes (DRC 2.2.1) ); --