Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 5709:e89d922df8ae
Schema change: add constraint to have unique stations per flow velocity model
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 15 Apr 2013 16:04:22 +0200 |
parents | 88cbe798cbab |
children |
comparison
equal
deleted
inserted
replaced
5708:e8469247dc6b | 5709:e89d922df8ae |
---|---|
205 q NUMBER(38,3) NOT NULL, | 205 q NUMBER(38,3) NOT NULL, |
206 total_channel NUMBER(38,3) NOT NULL, | 206 total_channel NUMBER(38,3) NOT NULL, |
207 main_channel NUMBER(38,3) NOT NULL, | 207 main_channel NUMBER(38,3) NOT NULL, |
208 shear_stress NUMBER(38,3) NOT NULL, | 208 shear_stress NUMBER(38,3) NOT NULL, |
209 PRIMARY KEY(id), | 209 PRIMARY KEY(id), |
210 UNIQUE (station, flow_velocity_model_id), | |
210 CONSTRAINT fk_fvv_flow_velocity_model_id FOREIGN KEY (flow_velocity_model_id) REFERENCES flow_velocity_model(id) ON DELETE CASCADE | 211 CONSTRAINT fk_fvv_flow_velocity_model_id FOREIGN KEY (flow_velocity_model_id) REFERENCES flow_velocity_model(id) ON DELETE CASCADE |
211 ); | 212 ); |
212 | 213 |
213 | 214 |
214 | 215 |