Mercurial > gemma
changeset 76:2a6e49a7b839
Add fairway dimensions stub.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 30 May 2018 17:23:57 +0200 |
parents | ed7a50cfbc19 |
children | e5bcd9293d3d |
files | wamos.sql |
diffstat | 1 files changed, 7 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/wamos.sql Wed May 30 17:09:47 2018 +0200 +++ b/wamos.sql Wed May 30 17:23:57 2018 +0200 @@ -212,6 +212,13 @@ measure_type varchar PRIMARY KEY ); +CREATE TABLE fairway_dimensions ( + level_of_service smallint REFERENCES levels_of_service, + dummy_attrib varchar, + "..." varchar + -- TODO: add real fairway dimension attributes (DRC 2.2.2) + ); + CREATE TABLE wamos.fairway_availability ( id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, position varchar REFERENCES spot_marks,