Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle.sql @ 3946:948c7289fc42
Backend: Added 'official_number' column to rivers table to model the 'Bundeswasserstrassen Identnummer'.
flys-backend/trunk@5571 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Sat, 22 Sep 2012 13:45:51 +0000 |
| parents | 3442304b430a |
| children | 83a42e6a562d |
comparison
equal
deleted
inserted
replaced
| 3945:26084ee6d352 | 3946:948c7289fc42 |
|---|---|
| 247 -- RIVERS | 247 -- RIVERS |
| 248 CREATE SEQUENCE RIVERS_ID_SEQ; | 248 CREATE SEQUENCE RIVERS_ID_SEQ; |
| 249 | 249 |
| 250 CREATE TABLE rivers ( | 250 CREATE TABLE rivers ( |
| 251 id NUMBER(38,0) NOT NULL, | 251 id NUMBER(38,0) NOT NULL, |
| 252 official_number NUMBER(38,0), | |
| 252 km_up NUMBER(38,0), | 253 km_up NUMBER(38,0), |
| 253 name VARCHAR2(255), | 254 name VARCHAR2(255), |
| 254 wst_unit_id NUMBER(38,0), | 255 wst_unit_id NUMBER(38,0), |
| 255 PRIMARY KEY (id) | 256 PRIMARY KEY (id) |
| 256 ); | 257 ); |