Mercurial > gemma
changeset 90:a8878834adfb
Add fairway attributes.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 01 Jun 2018 19:32:44 +0200 |
parents | a36bfec5edd3 |
children | c38edd879e2e |
files | wamos.sql |
diffstat | 1 files changed, 9 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/wamos.sql Fri Jun 01 19:24:11 2018 +0200 +++ b/wamos.sql Fri Jun 01 19:32:44 2018 +0200 @@ -205,11 +205,16 @@ ); 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) + area geometry(POLYGON, 4326) PRIMARY KEY, + level_of_service smallint NOT NULL REFERENCES levels_of_service, + min_width smallint NOT NULL, + max_width smallint NOT NULL, + min_depth smallint NOT NULL, + date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, + source_organization varchar NOT NULL ); +CREATE TRIGGER fairway_dimensions_date_info BEFORE UPDATE ON fairway_dimensions + FOR EACH ROW EXECUTE PROCEDURE update_date_info(); -- -- Bottlenecks