Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 3961:f5912365619c
Adapted the spatial schema for DEMs and the DgmSqlConverter.
flys-backend/trunk@5632 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Fri, 28 Sep 2012 08:37:08 +0000 |
| parents | 89ada0b9083f |
| children | eecd1ebba128 |
comparison
equal
deleted
inserted
replaced
| 3960:9e4468d50329 | 3961:f5912365619c |
|---|---|
| 156 river_id NUMBER(38), | 156 river_id NUMBER(38), |
| 157 -- XXX Should we use the ranges table instead? | 157 -- XXX Should we use the ranges table instead? |
| 158 name VARCHAR(64), | 158 name VARCHAR(64), |
| 159 lower NUMBER(19,5), | 159 lower NUMBER(19,5), |
| 160 upper NUMBER(19,5), | 160 upper NUMBER(19,5), |
| 161 year_from NUMBER(38), | 161 year_from VARCHAR(32) NOT NULL, |
| 162 year_to NUMBER(38), | 162 year_to VARCHAR(32) NOT NULL, |
| 163 projection VARCHAR(32), | 163 projection VARCHAR(32) NOT NULL, |
| 164 elevation_state VARCHAR(32), | 164 elevation_state VARCHAR(32), |
| 165 format VARCHAR(32), | 165 format VARCHAR(32), |
| 166 border_break BOOLEAN NOT NULL DEFAULT FALSE, | 166 border_break BOOLEAN NOT NULL DEFAULT FALSE, |
| 167 resolution VARCHAR(16), | 167 resolution VARCHAR(16), |
| 168 description VARCHAR(256), | 168 description VARCHAR(256), |