Changeset 36409 for branches/bills_branches/bills_201312/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Dec 23, 2013, 2:32:53 PM (13 years ago)

Author:

bills

Message:

refinements to fullForce tables. Full force run is now for a
a collection of warps with the same skycell and filter.
warp_id is removed from fullForceRun and is now contained in table
fullForceInput. The final results of the run will be stored in the
new table fullForceSummary which is also added. Run will transition
from new to full when all inputs have been processed and the summary
object is inserted.

File:

• branches/bills_branches/bills_201312/ippTools/share/pxadmin_create_tables.sql (modified) (2 diffs)

branches/bills_branches/bills_201312/ippTools/share/pxadmin_create_tables.sql

@@ -2309 +2309 @@
 CREATE TABLE fullForceRun (
     ff_id           BIGINT NOT NULL AUTO_INCREMENT,
-    warp_id         BIGINT,
+#    warp_id         BIGINT,
     skycal_id       BIGINT,
     sources_path_base VARCHAR(255),
@@ -2324 +2324 @@
     KEY(label),
     KEY(data_group),
-    KEY(warp_id),
+#    KEY(warp_id),
     KEY(skycal_id),
-    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id),
+#    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id),
     FOREIGN KEY(skycal_id) REFERENCES skycalRun(skycal_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE fullForceInput (
+    ff_id           BIGINT,
+    warp_id         BIGINT,
+    PRIMARY KEY(ff_id, warp_id),
+    FOREIGN KEY(ff_id) REFERENCES fullForceRun(ff_id),
+    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 CREATE TABLE fullForceResult (
+    ff_id           BIGINT,
+    warp_id         BIGINT,
+    path_base       VARCHAR(255) NOT NULL,
+    dtime_script    FLOAT,
+    quality         SMALLINT NOT NULL,
+    hostname        VARCHAR(64) NOT NULL,
+    software_ver    VARCHAR(16),
+    fault           SMALLINT NOT NULL,
+    PRIMARY KEY(ff_id, warp_id),
+    KEY(fault),
+    KEY(quality),
+    FOREIGN KEY(ff_id) REFERENCES fullForceRun(ff_id),
+    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE fullForceSummary (
     ff_id           BIGINT,
     path_base       VARCHAR(255) NOT NULL,