Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle.sql @ 5207:2919cdc4e858
corrected constraints on table gauges
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 08 Mar 2013 16:51:55 +0100 |
| parents | 8667f629d238 |
| children | 2594904640c3 |
comparison
equal
deleted
inserted
replaced
| 5206:8667f629d238 | 5207:2919cdc4e858 |
|---|---|
| 113 -- GAUGES | 113 -- GAUGES |
| 114 CREATE SEQUENCE GAUGES_ID_SEQ; | 114 CREATE SEQUENCE GAUGES_ID_SEQ; |
| 115 | 115 |
| 116 CREATE TABLE gauges ( | 116 CREATE TABLE gauges ( |
| 117 id NUMBER(38,0) NOT NULL, | 117 id NUMBER(38,0) NOT NULL, |
| 118 aeo NUMBER(38,2), | 118 aeo NUMBER(38,2) NOT NULL, |
| 119 datum NUMBER(38,2), | 119 datum NUMBER(38,2) NOT NULL, |
| 120 name VARCHAR2(255), | 120 name VARCHAR2(255) NOT NULL, |
| 121 station NUMBER(38,2), | 121 station NUMBER(38,2) NOT NULL, |
| 122 official_number NUMBER(38,0), | 122 official_number NUMBER(38,0) UNIQUE, |
| 123 range_id NUMBER(38,0), | 123 range_id NUMBER(38,0) NOT NULL, |
| 124 -- remove river id here because range_id references river already | |
| 124 river_id NUMBER(38,0), | 125 river_id NUMBER(38,0), |
| 125 PRIMARY KEY (id) | 126 PRIMARY KEY (id), |
| 127 UNIQUE (name, river_id), | |
| 128 UNIQUE (river_id, station) | |
| 126 ); | 129 ); |
| 127 | 130 |
| 128 | 131 |
| 129 -- HYK_ENTRIES | 132 -- HYK_ENTRIES |
| 130 CREATE SEQUENCE HYK_ENTRIES_ID_SEQ; | 133 CREATE SEQUENCE HYK_ENTRIES_ID_SEQ; |