Changeset 42188 for branches/eam_branches/ipp-20220316

Timestamp:

May 10, 2022, 6:26:25 AM (4 years ago)

Author:

eugene

Message:

adding fpcam db tables

Location:

branches/eam_branches/ipp-20220316/dbconfig

Files:

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

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

@@ -2575 +2575 @@
       REFERENCES stackExternalCamera(ext_camera_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- EAM 2022.05.09 : adding fpcamRun, fpcamProcessedExp
+
+CREATE TABLE fpcamRun (
+    fpcam_id      BIGINT AUTO_INCREMENT,
+    cam_id        BIGINT,
+    chip_id       BIGINT,
+    state         VARCHAR(64),
+    workdir       VARCHAR(255),
+    workdir_state VARCHAR(64),
+    label         VARCHAR(64),
+    data_group    VARCHAR(64),
+    dist_group    VARCHAR(64),
+    reduction     VARCHAR(64),
+    dvodb         VARCHAR(255),
+    software_ver  VARCHAR(16),
+    note          VARCHAR(255),
+    PRIMARY KEY(fpcam_id),
+    KEY(cam_id),
+    KEY(chip_id),
+    KEY(state),
+    KEY(label),
+    INDEX(chip_id, cam_id),
+    FOREIGN KEY (cam_id) REFERENCES camRun(cam_id),
+    FOREIGN KEY (chip_id) REFERENCES chipRun(chip_id))
+ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE fpcamProcessedExp (
+    fpcam_id     BIGINT,
+    path_base    VARCHAR(255),
+
+    zpt_obs      FLOAT,
+    zpt_stdev    FLOAT,
+    zpt_lq       FLOAT,
+    zpt_uq       FLOAT,
+
+    dtime_script FLOAT,
+
+    hostname     VARCHAR(64),
+    n_stars      INT,
+    fault        SMALLINT NOT NULL,
+    epoch        TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+
+    software_ver VARCHAR(16),
+
+    deteff_obs   FLOAT,
+    deteff_err   FLOAT,
+    deteff_lq    FLOAT,
+    deteff_uq    FLOAT,
+
+    quality      SMALLINT
+
+    PRIMARY KEY(fpcam_id),
+    KEY(fault),
+    FOREIGN KEY (fpcam_id) REFERENCES fpcamRun(fpcam_id),
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+

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

@@ -42 +42 @@
 include(ff.md)
 include(remote.md)
+include(fpcam.md)