Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 8687:3912da70736b
(issue1796) We don't necessarily need the river Rhine. SedDB river names are purely optional.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 15 Apr 2015 17:30:27 +0200 |
parents | cfafe5764509 |
children |
comparison
equal
deleted
inserted
replaced
8686:9cbbaedc6cba | 8687:3912da70736b |
---|---|
254 PRIMARY KEY (id), | 254 PRIMARY KEY (id), |
255 CHECK (a < b) | 255 CHECK (a < b) |
256 ); | 256 ); |
257 | 257 |
258 -- SEDDB_NAME | 258 -- SEDDB_NAME |
259 -- Lookup table for seddb river names | 259 -- Lookup table for optional matching with differing river names in SedDB |
260 -- Add name here and set rivers.seddb_name_id to id | |
260 CREATE TABLE seddb_name ( | 261 CREATE TABLE seddb_name ( |
261 id NUMBER(38,0) NOT NULL, | 262 id NUMBER(38,0) NOT NULL, |
262 name VARCHAR2(255) NOT NULL, | 263 name VARCHAR2(255) NOT NULL, |
263 PRIMARY KEY (id) | 264 PRIMARY KEY (id) |
264 ); | 265 ); |
265 INSERT INTO seddb_name (id, name) VALUES (0, 'Rhein'); | |
266 | |
267 | 266 |
268 -- RIVERS | 267 -- RIVERS |
269 CREATE SEQUENCE RIVERS_ID_SEQ; | 268 CREATE SEQUENCE RIVERS_ID_SEQ; |
270 | 269 |
271 CREATE TABLE rivers ( | 270 CREATE TABLE rivers ( |