Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 5426:6875a9f02097
SCHEMA CHANGE! Renamed columns in sq_relation and sq_relation_value.
| author | Raimund Renkert <rrenkert@intevation.de> |
|---|---|
| date | Tue, 26 Mar 2013 13:56:08 +0100 |
| parents | e88d55d01cf5 |
| children | 7c1dd9c3f6bd |
comparison
equal
deleted
inserted
replaced
| 5425:a137cbab32a8 | 5426:6875a9f02097 |
|---|---|
| 317 | 317 |
| 318 | 318 |
| 319 CREATE SEQUENCE SQ_RELATION_VALUES_ID_SEQ; | 319 CREATE SEQUENCE SQ_RELATION_VALUES_ID_SEQ; |
| 320 | 320 |
| 321 CREATE TABLE sq_relation_value ( | 321 CREATE TABLE sq_relation_value ( |
| 322 id NUMBER(38,0) NOT NULL, | 322 id NUMBER(38,0) NOT NULL, |
| 323 sq_relation_id NUMBER(38,0) NOT NULL, | 323 sq_relation_id NUMBER(38,0) NOT NULL, |
| 324 m_station_id NUMBER(38,0) NOT NULL, | 324 measurement_station_id NUMBER(38,0) NOT NULL, |
| 325 parameter VARCHAR(16) NOT NULL, | 325 parameter VARCHAR(16) NOT NULL, |
| 326 fraction VARCHAR(32) NOT NULL, | 326 fraction VARCHAR(32) NOT NULL, |
| 327 a NUMBER(38,20) NOT NULL, | 327 a NUMBER(38,20) NOT NULL, |
| 328 b NUMBER(38,20) NOT NULL, | 328 b NUMBER(38,20) NOT NULL, |
| 329 q_max NUMBER(38,20), | 329 qmax NUMBER(38,20), |
| 330 r_sq NUMBER(38,3), | 330 rsq NUMBER(38,3), |
| 331 n_tot NUMBER(38,0), | 331 ntot NUMBER(38,0), |
| 332 n_outl NUMBER(38,0), | 332 noutl NUMBER(38,0), |
| 333 cferguson NUMBER(38,20), | 333 cferguson NUMBER(38,20), |
| 334 cduan NUMBER(38,20), | 334 cduan NUMBER(38,20), |
| 335 PRIMARY KEY (id), | 335 PRIMARY KEY (id), |
| 336 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id), | 336 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id), |
| 337 CONSTRAINT fk_mstation_id FOREIGN KEY (m_station_id) REFERENCES measurement_station(id) | 337 CONSTRAINT fk_mstation_id FOREIGN KEY (m_station_id) REFERENCES measurement_station(id) |
| 338 ); | 338 ); |