Mercurial > gemma
comparison schema/gemma.sql @ 1662:d8ca44615bfc
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? |