Mercurial > gemma
changeset 89:a36bfec5edd3
Move more tables to waterway schema to tweak diagrams.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 01 Jun 2018 19:24:11 +0200 |
parents | a96fee9654db |
children | a8878834adfb |
files | wamos.sql |
diffstat | 1 files changed, 11 insertions(+), 11 deletions(-) [+] |
line wrap: on
line diff
--- a/wamos.sql Fri Jun 01 19:18:18 2018 +0200 +++ b/wamos.sql Fri Jun 01 19:24:11 2018 +0200 @@ -200,6 +200,17 @@ -- TODO: add real profile attributes (DRC 2.2.3) ); +CREATE TABLE wamos_waterway.levels_of_service ( + level_of_service smallint PRIMARY KEY + ); + +CREATE TABLE wamos_waterway.fairway_dimensions ( + level_of_service smallint REFERENCES levels_of_service, + dummy_attrib varchar, + "..." varchar + -- TODO: add real fairway dimension attributes (DRC 2.2.2) + ); + -- -- Bottlenecks -- @@ -286,21 +297,10 @@ -- -- Fairway availability -- -CREATE TABLE wamos_fairway.levels_of_service ( - level_of_service smallint PRIMARY KEY - ); - CREATE TABLE wamos_fairway.measure_types ( measure_type varchar PRIMARY KEY ); -CREATE TABLE wamos_fairway.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.fairway_availability ( id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, position_code char(2) REFERENCES position_codes,