Mercurial > gemma

comparison schema/gemma.sql @ 1662:d8ca44615bfc

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Implemented first version of fairway availability import.
author Raimund Renkert <raimund.renkert@intevation.de>
date Fri, 21 Dec 2018 15:56:28 +0100
parents 49c04bb64e0a
children b20b68adfe80
comparison
equal deleted inserted replaced
1661:51a0ba4ede41 1662:d8ca44615bfc
137 -- Clarify! 137 -- Clarify!
138 -- TODO: Do we need an attribute "meaning" or so? 138 -- TODO: Do we need an attribute "meaning" or so?
139 ); 139 );
140 140
141 CREATE TABLE levels_of_service ( 141 CREATE TABLE levels_of_service (
142 level_of_service smallint PRIMARY KEY 142 level_of_service smallint PRIMARY KEY,
143 ); 143 name varchar(4)
144 INSERT INTO levels_of_service VALUES (1), (2), (3); 144 );
145 INSERT INTO levels_of_service (
146 level_of_service,
147 name
148 ) VALUES (1, 'LOS1'), (2, 'LOS2'), (3, 'LOS3');
145 149
146 CREATE TABLE riverbed_materials ( 150 CREATE TABLE riverbed_materials (
147 material varchar PRIMARY KEY 151 material varchar PRIMARY KEY
148 -- XXX: Should this table contain choices from DRC 2.2.3 or 152 -- XXX: Should this table contain choices from DRC 2.2.3 or
149 -- from IENC Encoding Guide M.4.3, attribute NATSUR? 153 -- from IENC Encoding Guide M.4.3, attribute NATSUR?