Mercurial > gemma

comparison wamos.sql @ 69:beb1863eefaf

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add waterway area.
author Tom Gottfried <tom@intevation.de>
date Wed, 30 May 2018 15:58:02 +0200
parents d218aa96170f
children 28108455ad35
comparison
equal deleted inserted replaced
68:7a91106668b8 69:beb1863eefaf
43 -- -- factor, this might be an issue. 43 -- -- factor, this might be an issue.
44 -- rwdr double precision NOT NULL, 44 -- rwdr double precision NOT NULL,
45 -- EXCLUDE USING GIST (stretch WITH &&) 45 -- EXCLUDE USING GIST (stretch WITH &&)
46 -- ); 46 -- );
47 47
48 CREATE TABLE wamos.countries (
49 country_code char(2) PRIMARY KEY -- ISO 3166 country code
50 -- A smallint PK would require even less disk space i.e. on the FK side.
51 -- This might be an issue in case cache space becomes a limiting
52 -- factor when there are many FKs pointing here.
53 );
54
55 --
56 -- General river information
57 --
58 CREATE TABLE wamos.waterway_area (
59 dummy_attrib varchar,
60 "..." varchar
61 -- TODO: add real waterway area attributes (DRC 2.1.3)
62 );
63
48 CREATE TABLE wamos.gauges ( 64 CREATE TABLE wamos.gauges (
49 location isrs PRIMARY KEY, 65 location isrs PRIMARY KEY,
50 dummy_attrib varchar, 66 dummy_attrib varchar,
51 "..." varchar 67 "..." varchar
52 -- TODO: add real gauge attributes (DRC 2.1.4) 68 -- TODO: add real gauge attributes (DRC 2.1.4)
53 );
54
55 CREATE TABLE wamos.countries (
56 country_code char(2) PRIMARY KEY -- ISO 3166 country code
57 -- A smallint PK would require even less disk space i.e. on the FK side.
58 -- This might be an issue in case cache space becomes a limiting
59 -- factor when there are many FKs pointing here.
60 ); 69 );
61 70
62 -- 71 --
63 -- Bottlenecks 72 -- Bottlenecks
64 -- 73 --