Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 5783:153456f84602
add missing constraints to Oracle Schema (issue426) and some cosmetics
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 22 Apr 2013 13:00:13 +0200 |
| parents | b5553164fabf |
| children |
comparison
equal
deleted
inserted
replaced
| 5782:5ad389bc20f0 | 5783:153456f84602 |
|---|---|
| 32 CREATE SEQUENCE RIVER_AXES_KM_ID_SEQ; | 32 CREATE SEQUENCE RIVER_AXES_KM_ID_SEQ; |
| 33 CREATE TABLE river_axes_km( | 33 CREATE TABLE river_axes_km( |
| 34 OGR_FID NUMBER(38), | 34 OGR_FID NUMBER(38), |
| 35 GEOM MDSYS.SDO_GEOMETRY, | 35 GEOM MDSYS.SDO_GEOMETRY, |
| 36 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, | 36 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, |
| 37 km NUMBER(7,3), | 37 km NUMBER(7,3) NOT NULL, |
| 38 name VARCHAR(64), | 38 name VARCHAR(64), |
| 39 path VARCHAR(256), | 39 path VARCHAR(256), |
| 40 ID NUMBER PRIMARY KEY NOT NULL | 40 ID NUMBER PRIMARY KEY NOT NULL |
| 41 ); | 41 ); |
| 42 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('river_axes_km', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3282450,3912240,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5248260,6100130,0.001)), 31467); | 42 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('river_axes_km', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3282450,3912240,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5248260,6100130,0.001)), 31467); |
| 311 CREATE SEQUENCE FLOODMAPS_ID_SEQ; | 311 CREATE SEQUENCE FLOODMAPS_ID_SEQ; |
| 312 CREATE TABLE floodmaps ( | 312 CREATE TABLE floodmaps ( |
| 313 OGR_FID NUMBER(38), | 313 OGR_FID NUMBER(38), |
| 314 GEOM MDSYS.SDO_GEOMETRY, | 314 GEOM MDSYS.SDO_GEOMETRY, |
| 315 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, | 315 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, |
| 316 name VARCHAR(255), | 316 name VARCHAR(255) NOT NULL, |
| 317 kind NUMBER NOT NULL REFERENCES floodmap_kinds(id), | 317 kind NUMBER NOT NULL REFERENCES floodmap_kinds(id), |
| 318 diff NUMBER(19,5), | 318 diff NUMBER(19,5), |
| 319 count NUMBER(38), | 319 count NUMBER(38), |
| 320 area NUMBER(19,5), | 320 area NUMBER(19,5), |
| 321 perimeter NUMBER(19,5), | 321 perimeter NUMBER(19,5), |