Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-spatial.sql @ 7001:dcc7a6c8b92c double-precision
Minor schema change: allow to delete ranges with associated DEMs.
author | Tom Gottfried <tom.gottfried@intevation.de> |
---|---|
date | Fri, 30 Aug 2013 17:31:20 +0200 |
parents | 97145ec4e33c |
children | cc53aae06303 |
comparison
equal
deleted
inserted
replaced
6935:a442cab85198 | 7001:dcc7a6c8b92c |
---|---|
163 CREATE SEQUENCE DEM_ID_SEQ; | 163 CREATE SEQUENCE DEM_ID_SEQ; |
164 CREATE TABLE dem ( | 164 CREATE TABLE dem ( |
165 ID NUMBER PRIMARY KEY NOT NULL, | 165 ID NUMBER PRIMARY KEY NOT NULL, |
166 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, | 166 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, |
167 name VARCHAR(64), | 167 name VARCHAR(64), |
168 range_id NUMBER(38) REFERENCES ranges(id), | 168 range_id NUMBER(38) REFERENCES ranges(id) ON DELETE CASCADE, |
169 time_interval_id NUMBER(38) REFERENCES time_intervals(id), | 169 time_interval_id NUMBER(38) REFERENCES time_intervals(id), |
170 projection VARCHAR(32), | 170 projection VARCHAR(32), |
171 elevation_state VARCHAR(32), | 171 elevation_state VARCHAR(32), |
172 srid NUMBER NOT NULL, | 172 srid NUMBER NOT NULL, |
173 format VARCHAR(32), | 173 format VARCHAR(32), |