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; |