Changeset 42545

Timestamp:

Nov 15, 2023, 11:33:13 AM (3 years ago)

Author:

eugene

Message:

add xcstack tables

Location:

branches/eam_branches/ipp-20230313/dbconfig

Files:

• changes.txt (modified) (1 diff)
• ff.md (modified) (1 diff)
• ipp.m4 (modified) (1 diff)
• xcstack.md (added)

branches/eam_branches/ipp-20230313/dbconfig/changes.txt

@@ -2632 +2632 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+-- EAM 2023.11.04 : adding xcstackRun, xcstackInputSkyfile, xcstackSumSkyfile
+
+
+CREATE TABLE xcstackRun (
+        xcstack_id BIGINT AUTO_INCREMENT,
+        state VARCHAR(64),
+        workdir VARCHAR(255),
+        label VARCHAR(64),
+        data_group VARCHAR(64),
+        dist_group VARCHAR(64),
+        reduction VARCHAR(64),
+        registered DATETIME,
+        skycell_id VARCHAR(64),
+        tess_id VARCHAR(64),
+        filter VARCHAR(64),
+        software_ver VARCHAR(16),
+        note VARCHAR(255),
+        PRIMARY KEY(xcstack_id),
+        KEY(xcstack_id),
+        KEY(state),
+        KEY(skycell_id),
+        KEY(tess_id),
+        KEY(label),
+        KEY(data_group),
+        KEY(dist_group)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE xcstackInputSkyfile (
+        xcstack_id BIGINT,
+        camera_id BIGINT,
+        stack_id BIGINT,
+        PRIMARY KEY(xcstack_id, stack_id),
+        FOREIGN KEY(xcstack_id) REFERENCES xcstackRun(xcstack_id),
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE xcstackSumSkyfile (
+        xcstack_id BIGINT,
+        path_base VARCHAR(255),
+        bg DOUBLE,
+        bg_stdev DOUBLE,
+        dtime_stack FLOAT,
+        dtime_script FLOAT,
+        hostname VARCHAR(64),
+        good_frac FLOAT,
+        fault SMALLINT,
+        software_ver VARCHAR(16),
+        quality SMALLINT NOT NULL DEFAULT 0,
+        PRIMARY KEY(xcstack_id),
+        KEY(dtime_stack),
+        KEY(good_frac),
+        KEY(fault),
+        KEY(quality),
+        FOREIGN KEY(xcstack_id) REFERENCES xcstackRun(xcstack_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+

branches/eam_branches/ipp-20230313/dbconfig/ff.md

@@ -1 +1 @@
 
+## why is ff_id not marked here for AUTO_INCREMENT?
 fullForceRun METADATA
     ff_id           S64         0

branches/eam_branches/ipp-20230313/dbconfig/ipp.m4

@@ -43 +43 @@
 include(remote.md)
 include(fpcam.md)
+include(xcstack.md)