Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-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 | 28f992c0f937 |
comparison
equal
deleted
inserted
replaced
| 3960:9e4468d50329 | 3961:f5912365619c |
|---|---|
| 105 river_id int REFERENCES rivers(id), | 105 river_id int REFERENCES rivers(id), |
| 106 -- XXX Should we use the ranges table instead? | 106 -- XXX Should we use the ranges table instead? |
| 107 name VARCHAR(64), | 107 name VARCHAR(64), |
| 108 lower NUMERIC, | 108 lower NUMERIC, |
| 109 upper NUMERIC, | 109 upper NUMERIC, |
| 110 year_from int, | 110 year_from VARCHAR(32) NOT NULL, |
| 111 year_to int, | 111 year_to VARCHAR(32) NOT NULL, |
| 112 projection VARCHAR(32), | 112 projection VARCHAR(32) NOT NULL, |
| 113 elevation_state VARCHAR(32), | 113 elevation_state VARCHAR(32), |
| 114 format VARCHAR(32), | 114 format VARCHAR(32), |
| 115 border_break BOOLEAN NOT NULL DEFAULT FALSE, | 115 border_break BOOLEAN NOT NULL DEFAULT FALSE, |
| 116 resolution VARCHAR(16), | 116 resolution VARCHAR(16), |
| 117 description VARCHAR(256), | 117 description VARCHAR(256), |