Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial.sql @ 5078:0fd7720e5c7f dami
Oracle Schema, add overlooked sectie and sobek fields
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Thu, 21 Feb 2013 12:36:30 +0100 |
| parents | 57a845da72bd |
| children | c4b28de753de |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Thu Feb 21 09:46:40 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial.sql Thu Feb 21 12:36:30 2013 +0100 @@ -294,7 +294,9 @@ GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, name VARCHAR(255), - kind NUMBER(38), + kind NUMBER(38) REFERENCES boundary_kinds(id), + sectie NUMBER(38) REFERENCES sectie_kinds(id), + sobek NUMBER(38) REFERENCES sobek_kinds(id), path VARCHAR(256), id NUMBER PRIMARY KEY NOT NULL ); @@ -311,7 +313,9 @@ GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, name VARCHAR(255), - kind NUMBER(38), + kind NUMBER(38) REFERENCES boundary_kinds(id), + sectie NUMBER(38) REFERENCES sectie_kinds(id), + sobek NUMBER(38) REFERENCES sobek_kinds(id), path VARCHAR(256), id NUMBER PRIMARY KEY NOT NULL );