diff 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
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql	Tue Mar 26 12:26:48 2013 +0100
+++ b/flys-backend/doc/schema/oracle-minfo.sql	Tue Mar 26 13:56:08 2013 +0100
@@ -319,19 +319,19 @@
 CREATE SEQUENCE SQ_RELATION_VALUES_ID_SEQ;
 
 CREATE TABLE sq_relation_value (
-    id             NUMBER(38,0) NOT NULL,
-    sq_relation_id NUMBER(38,0) NOT NULL,
-    m_station_id   NUMBER(38,0) NOT NULL,
-    parameter      VARCHAR(16)  NOT NULL,
-    fraction       VARCHAR(32)  NOT NULL,
-    a              NUMBER(38,20) NOT NULL,
-    b              NUMBER(38,20) NOT NULL,
-    q_max          NUMBER(38,20),
-    r_sq           NUMBER(38,3),
-    n_tot          NUMBER(38,0),
-    n_outl         NUMBER(38,0),
-    cferguson      NUMBER(38,20),
-    cduan          NUMBER(38,20),
+    id                       NUMBER(38,0) NOT NULL,
+    sq_relation_id           NUMBER(38,0) NOT NULL,
+    measurement_station_id   NUMBER(38,0) NOT NULL,
+    parameter                VARCHAR(16)  NOT NULL,
+    fraction                 VARCHAR(32)  NOT NULL,
+    a                        NUMBER(38,20) NOT NULL,
+    b                        NUMBER(38,20) NOT NULL,
+    qmax                     NUMBER(38,20),
+    rsq                      NUMBER(38,3),
+    ntot                     NUMBER(38,0),
+    noutl                    NUMBER(38,0),
+    cferguson                NUMBER(38,20),
+    cduan                    NUMBER(38,20),
     PRIMARY KEY (id),
     CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id),
     CONSTRAINT fk_mstation_id FOREIGN KEY (m_station_id) REFERENCES measurement_station(id)

http://dive4elements.wald.intevation.org