Mercurial > gemma
diff schema/gemma.sql @ 580:e78bdbb6cac8
Remove worthless attribute
According to RIS-Index Encoding Guide, section I.3.4 Waterway Gauge,
the function code of a gauge is always 'wtwgag'. There is no point in
storing the same value with every record.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 06 Sep 2018 16:27:17 +0200 |
parents | 642df1164aca |
children | 4854a1e85870 |
line wrap: on
line diff
--- a/schema/gemma.sql Thu Sep 06 16:15:38 2018 +0200 +++ b/schema/gemma.sql Thu Sep 06 16:27:17 2018 +0200 @@ -204,7 +204,6 @@ location isrs PRIMARY KEY CHECK( (location).orc SIMILAR TO 'G[[:digit:]]{4}' AND CAST(substring((location).orc from 2 for 4) AS int) < 2048), - function_code varchar(10) NOT NULL, -- XXX: What is this really for? objname varchar NOT NULL, is_left boolean, -- XXX: Or reference position_codes? geom geography(POINT, 4326) NOT NULL,