Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-minfo.sql @ 5777:e95427ed80e5
Merged
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Sun, 21 Apr 2013 10:46:59 +0200 |
| parents | e89d922df8ae |
| children |
comparison
equal
deleted
inserted
replaced
| 5776:1126b9e00378 | 5777:e95427ed80e5 |
|---|---|
| 205 q NUMERIC NOT NULL, | 205 q NUMERIC NOT NULL, |
| 206 total_channel NUMERIC NOT NULL, | 206 total_channel NUMERIC NOT NULL, |
| 207 main_channel NUMERIC NOT NULL, | 207 main_channel NUMERIC NOT NULL, |
| 208 shear_stress NUMERIC NOT NULL, | 208 shear_stress NUMERIC 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 |
| 329 noutl int, | 330 noutl int, |
| 330 cferguson NUMERIC, | 331 cferguson NUMERIC, |
| 331 cduan NUMERIC, | 332 cduan NUMERIC, |
| 332 PRIMARY KEY (id), | 333 PRIMARY KEY (id), |
| 333 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id) ON DELETE CASCADE, | 334 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id) ON DELETE CASCADE, |
| 334 CONSTRAINT fk_mstation_id FOREIGN KEY (measurement_station_id) REFERENCES measurement_station(id) | 335 CONSTRAINT fk_mstation_id FOREIGN KEY (measurement_station_id) REFERENCES measurement_station(id) ON DELETE CASCADE |
| 335 ); | 336 ); |
| 336 COMMIT; | 337 COMMIT; |