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