changeset 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 a137cbab32a8
children 473edafe4cb1
files flys-backend/doc/schema/oracle-minfo.sql flys-backend/doc/schema/postgresql-minfo.sql
diffstat 2 files changed, 26 insertions(+), 26 deletions(-) [+]
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)
--- a/flys-backend/doc/schema/postgresql-minfo.sql	Tue Mar 26 12:26:48 2013 +0100
+++ b/flys-backend/doc/schema/postgresql-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             int NOT NULL,
-    sq_relation_id int NOT NULL,
-    m_station_id   int NOT NULL,
-    parameter      VARCHAR(16)  NOT NULL,
-    fraction       VARCHAR(32)  NOT NULL,
-    a              NUMERIC NOT NULL,
-    b              NUMERIC NOT NULL,
-    q_max          NUMERIC,
-    r_sq           NUMERIC,
-    n_tot          int,
-    n_outl         int,
-    cferguson      NUMERIC,
-    cduan          NUMERIC,
+    id                     int NOT NULL,
+    sq_relation_id         int NOT NULL,
+    measurement_station_id int NOT NULL,
+    parameter              VARCHAR(16)  NOT NULL,
+    fraction               VARCHAR(32)  NOT NULL,
+    a                      NUMERIC NOT NULL,
+    b                      NUMERIC NOT NULL,
+    qmax                   NUMERIC,
+    rsq                    NUMERIC,
+    ntot                   int,
+    noutl                  int,
+    cferguson              NUMERIC,
+    cduan                  NUMERIC,
     PRIMARY KEY (id),
     CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id) ON DELETE CASCADE,
     CONSTRAINT fk_mstation_id FOREIGN KEY (m_station_id) REFERENCES measurement_station(id)

http://dive4elements.wald.intevation.org