diff flys-backend/doc/schema/postgresql-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/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