changeset 69:beb1863eefaf

Add waterway area.
author Tom Gottfried <tom@intevation.de>
date Wed, 30 May 2018 15:58:02 +0200
parents 7a91106668b8
children 28108455ad35
files wamos.sql
diffstat 1 files changed, 16 insertions(+), 7 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Fri May 25 22:17:20 2018 +0200
+++ b/wamos.sql	Wed May 30 15:58:02 2018 +0200
@@ -45,6 +45,22 @@
 --        EXCLUDE USING GIST (stretch WITH &&)
 --        );
 
+CREATE TABLE wamos.countries (
+       country_code char(2) PRIMARY KEY -- ISO 3166 country code
+       -- A smallint PK would require even less disk space i.e. on the FK side.
+       -- This might be an issue in case cache space becomes a limiting
+       -- factor when there are many FKs pointing here.
+       );
+
+--
+-- General river information
+--
+CREATE TABLE wamos.waterway_area (
+       dummy_attrib varchar,
+       "..." varchar
+       -- TODO: add real waterway area attributes (DRC 2.1.3)
+       );
+
 CREATE TABLE wamos.gauges (
        location isrs PRIMARY KEY,
        dummy_attrib varchar,
@@ -52,13 +68,6 @@
        -- TODO: add real gauge attributes (DRC 2.1.4)
        );
 
-CREATE TABLE wamos.countries (
-       country_code char(2) PRIMARY KEY -- ISO 3166 country code
-       -- A smallint PK would require even less disk space i.e. on the FK side.
-       -- This might be an issue in case cache space becomes a limiting
-       -- factor when there are many FKs pointing here.
-       );
-
 --
 -- Bottlenecks
 --