Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5377:a5f5599f6fd5 2.9.14
merge
| author | Bettina Gruenbauer <bettina@intevation.de> |
|---|---|
| date | Fri, 22 Mar 2013 11:02:08 +0100 |
| parents | 7b35f2c070c3 |
| children | 2da74705c29d |
comparison
equal
deleted
inserted
replaced
| 5376:9b2482a3b9fe | 5377:a5f5599f6fd5 |
|---|---|
| 108 -- Geodaesie/Hoehenmodelle/* | 108 -- Geodaesie/Hoehenmodelle/* |
| 109 CREATE SEQUENCE DEM_ID_SEQ; | 109 CREATE SEQUENCE DEM_ID_SEQ; |
| 110 CREATE TABLE dem ( | 110 CREATE TABLE dem ( |
| 111 id int PRIMARY KEY NOT NULL, | 111 id int PRIMARY KEY NOT NULL, |
| 112 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 112 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
| 113 -- XXX Should we use the ranges table instead? | |
| 114 name VARCHAR(64), | 113 name VARCHAR(64), |
| 115 range_id INT REFERENCES ranges(id), | 114 range_id INT REFERENCES ranges(id), |
| 116 time_interval_id INT REFERENCES time_intervals(id), | 115 time_interval_id INT REFERENCES time_intervals(id), |
| 117 projection VARCHAR(32), | 116 projection VARCHAR(32), |
| 118 srid int NOT NULL, | 117 srid int NOT NULL, |