Changes between Initial Version and Version 1 of Model Results

Timestamp:

Dec 13, 2011 3:25:10 PM (13 years ago)

Author:

celine

Comment:

--

Model Results

@@ +1 @@
+back to first page[..][[BR]]
+back to ["RHT"][[BR]]
+{{{
+#!sql
+CREATE TABLE rht.model_mod
+(
+  mod_id serial NOT NULL,
+  mod_name character varying(30) NOT NULL,
+  mod_date date,
+  mod_description text NOT NULL,
+  mod_location character varying(25), -- Geographical area to which the model is applied, should be consistent with europe.wso
+  mod_formula text,
+  CONSTRAINT model_mod_pkey PRIMARY KEY (mod_id),
+  CONSTRAINT model_mod_mod_name_key UNIQUE (mod_name)
+);
+
+CREATE TABLE rht.resultmodel
+(
+  res_id serial NOT NULL,
+  res_wso1_id integer,
+  res_riversegmentgid integer,
+  res_value double precision,
+  res_mod_id integer,
+  CONSTRAINT resultmodel_pkey PRIMARY KEY (res_id),
+  CONSTRAINT c_fk_res_mod_id FOREIGN KEY (res_mod_id)
+      REFERENCES rht.model_mod (mod_id) MATCH SIMPLE
+      ON UPDATE NO ACTION ON DELETE NO ACTION
+);
+}}}