--- 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