IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
May 30, 2008, 4:19:52 PM (18 years ago)
Author:
jhoblitt
Message:

add epoch fields to pz*, new*, & raw* tables

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/pxadmin_create_tables.sql

    r17856 r17872  
    33    telescope VARCHAR(64),
    44    uri VARCHAR(255),
     5    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    56    PRIMARY KEY(camera, telescope)
    67) ENGINE=innodb DEFAULT CHARSET=latin1;
    … …  
    1516    imfiles INT,
    1617    fault SMALLINT NOT NULL,
     18    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    1719    PRIMARY KEY(exp_name, camera, telescope),
    1820    KEY(fault))
    … …  
    2931    class_id VARCHAR(64),
    3032    uri VARCHAR(255),
     33    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    3134    PRIMARY KEY(exp_name, camera, telescope, class, class_id),
    3235    KEY(file_id),
    … …  
    4043    telescope VARCHAR(64),
    4144    state VARCHAR(64),
     45    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    4246    PRIMARY KEY(exp_name, camera, telescope),
    4347    KEY(state),
    … …  
    5458    uri VARCHAR(255),
    5559    fault SMALLINT NOT NULL,
     60    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    5661    PRIMARY KEY(exp_name, camera, telescope, class, class_id),
    5762    KEY(fault),
    … …  
    6166        REFERENCES  summitImfile(exp_name, camera, telescope, class, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    6267
    63 CREATE TABLE newExp (exp_id BIGINT AUTO_INCREMENT, tmp_exp_name VARCHAR(64), tmp_camera VARCHAR(64), tmp_telescope VARCHAR(64), state VARCHAR(64), workdir VARCHAR(255), workdir_state VARCHAR(64), reduction VARCHAR(64), dvodb VARCHAR(255), tess_id VARCHAR(64), end_stage VARCHAR(64), label VARCHAR(64), PRIMARY KEY(exp_id), KEY(exp_id), KEY(tmp_exp_name), KEY(tmp_camera), KEY(tmp_telescope), KEY(state), KEY(workdir_state), KEY(end_stage), KEY(label)) ENGINE=innodb DEFAULT CHARSET=latin1;
    64 CREATE TABLE newImfile (exp_id BIGINT, tmp_class_id VARCHAR(64), uri VARCHAR(255), PRIMARY KEY(exp_id, tmp_class_id), FOREIGN KEY (exp_id)  REFERENCES  newExp(exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    65 CREATE TABLE rawExp (exp_id BIGINT, exp_name VARCHAR(64), camera VARCHAR(64), telescope VARCHAR(64), dateobs DATETIME, exp_tag VARCHAR(255), exp_type VARCHAR(64), filelevel VARCHAR(64), workdir VARCHAR(255), reduction VARCHAR(64), dvodb VARCHAR(255), tess_id VARCHAR(64), end_stage VARCHAR(64), filter VARCHAR(64), comment VARCHAR(80), airmass FLOAT, ra DOUBLE, decl DOUBLE, exp_time FLOAT, sat_pixel_frac FLOAT, bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, alt DOUBLE, az DOUBLE, ccd_temp FLOAT, posang DOUBLE, m1_x FLOAT, m1_y FLOAT, m1_z FLOAT, m1_tip FLOAT, m1_tilt FLOAT, m2_x FLOAT, m2_y FLOAT, m2_z FLOAT, m2_tip FLOAT, m2_tilt FLOAT, env_temperature FLOAT, env_humidity FLOAT, env_wind_speed FLOAT, env_wind_dir FLOAT, teltemp_m1 FLOAT, teltemp_m1cell FLOAT, teltemp_m2 FLOAT, teltemp_spider FLOAT, teltemp_truss FLOAT, teltemp_extra FLOAT, pon_time FLOAT, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, object VARCHAR(64), solang FLOAT, hostname VARCHAR(64), fault SMALLINT NOT NULL, PRIMARY KEY(exp_id), KEY(exp_name), KEY(end_stage), KEY(fault), FOREIGN KEY (exp_id)  REFERENCES  newExp(exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    66 CREATE TABLE rawImfile (exp_id BIGINT, exp_name VARCHAR(64), camera VARCHAR(64), telescope VARCHAR(64), dateobs DATETIME, tmp_class_id VARCHAR(64), class_id VARCHAR(64), uri VARCHAR(255), exp_type VARCHAR(64), filelevel VARCHAR(64), filter VARCHAR(64), comment VARCHAR(80), airmass FLOAT, ra DOUBLE, decl DOUBLE, exp_time FLOAT, sat_pixel_frac FLOAT, bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, alt DOUBLE, az DOUBLE, ccd_temp FLOAT, posang DOUBLE, m1_x FLOAT, m1_y FLOAT, m1_z FLOAT, m1_tip FLOAT, m1_tilt FLOAT, m2_x FLOAT, m2_y FLOAT, m2_z FLOAT, m2_tip FLOAT, m2_tilt FLOAT, env_temperature FLOAT, env_humidity FLOAT, env_wind_speed FLOAT, env_wind_dir FLOAT, teltemp_m1 FLOAT, teltemp_m1cell FLOAT, teltemp_m2 FLOAT, teltemp_spider FLOAT, teltemp_truss FLOAT, teltemp_extra FLOAT, pon_time FLOAT, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, object VARCHAR(64), hostname VARCHAR(64), fault SMALLINT NOT NULL, PRIMARY KEY(exp_id, class_id), KEY(tmp_class_id), KEY(fault), UNIQUE KEY(exp_id, tmp_class_id), FOREIGN KEY (exp_id, tmp_class_id)  REFERENCES  newImfile(exp_id, tmp_class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
     68CREATE TABLE newExp (
     69    exp_id BIGINT AUTO_INCREMENT,
     70    tmp_exp_name VARCHAR(64),
     71    tmp_camera VARCHAR(64),
     72    tmp_telescope VARCHAR(64),
     73    state VARCHAR(64),
     74    workdir VARCHAR(255),
     75    workdir_state VARCHAR(64),
     76    reduction VARCHAR(64),
     77    dvodb VARCHAR(255),
     78    tess_id VARCHAR(64),
     79    end_stage VARCHAR(64),
     80    label VARCHAR(64),
     81    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     82    PRIMARY KEY(exp_id),
     83    KEY(exp_id),
     84    KEY(tmp_exp_name),
     85    KEY(tmp_camera),
     86    KEY(tmp_telescope),
     87    KEY(state),
     88    KEY(workdir_state),
     89    KEY(end_stage),
     90    KEY(label)
     91) ENGINE=innodb DEFAULT CHARSET=latin1;
     92
     93CREATE TABLE newImfile (
     94    exp_id BIGINT,
     95    tmp_class_id VARCHAR(64),
     96    uri VARCHAR(255),
     97    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     98    PRIMARY KEY(exp_id, tmp_class_id),
     99    FOREIGN KEY (exp_id)
     100        REFERENCES  newExp(exp_id))
     101ENGINE=innodb DEFAULT CHARSET=latin1;
     102
     103CREATE TABLE rawExp (
     104    exp_id BIGINT,
     105    exp_name VARCHAR(64),
     106    camera VARCHAR(64),
     107    telescope VARCHAR(64),
     108    dateobs DATETIME,
     109    exp_tag VARCHAR(255),
     110    exp_type VARCHAR(64),
     111    filelevel VARCHAR(64),
     112    workdir VARCHAR(255),
     113    reduction VARCHAR(64),
     114    dvodb VARCHAR(255),
     115    tess_id VARCHAR(64),
     116    end_stage VARCHAR(64),
     117    filter VARCHAR(64),
     118    comment VARCHAR(80),
     119    airmass FLOAT,
     120    ra DOUBLE,
     121    decl DOUBLE,
     122    exp_time FLOAT,
     123    sat_pixel_frac FLOAT,
     124    bg DOUBLE,
     125    bg_stdev DOUBLE,
     126    bg_mean_stdev DOUBLE,
     127    alt DOUBLE,
     128    az DOUBLE,
     129    ccd_temp FLOAT,
     130    posang DOUBLE,
     131    m1_x FLOAT,
     132    m1_y FLOAT,
     133    m1_z FLOAT,
     134    m1_tip FLOAT,
     135    m1_tilt FLOAT,
     136    m2_x FLOAT,
     137    m2_y FLOAT,
     138    m2_z FLOAT,
     139    m2_tip FLOAT,
     140    m2_tilt FLOAT,
     141    env_temperature FLOAT,
     142    env_humidity FLOAT,
     143    env_wind_speed FLOAT,
     144    env_wind_dir FLOAT,
     145    teltemp_m1 FLOAT,
     146    teltemp_m1cell FLOAT,
     147    teltemp_m2 FLOAT,
     148    teltemp_spider FLOAT,
     149    teltemp_truss FLOAT,
     150    teltemp_extra FLOAT,
     151    pon_time FLOAT,
     152    user_1 DOUBLE,
     153    user_2 DOUBLE,
     154    user_3 DOUBLE,
     155    user_4 DOUBLE,
     156    user_5 DOUBLE,
     157    object VARCHAR(64),
     158    solang FLOAT,
     159    hostname VARCHAR(64),
     160    fault SMALLINT NOT NULL,
     161    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     162    PRIMARY KEY(exp_id),
     163    KEY(exp_name),
     164    KEY(end_stage),
     165    KEY(fault),
     166    FOREIGN KEY (exp_id)
     167        REFERENCES  newExp(exp_id))
     168ENGINE=innodb DEFAULT CHARSET=latin1;
     169
     170CREATE TABLE rawImfile (
     171    exp_id BIGINT,
     172    exp_name VARCHAR(64),
     173    camera VARCHAR(64),
     174    telescope VARCHAR(64),
     175    dateobs DATETIME,
     176    tmp_class_id VARCHAR(64),
     177    class_id VARCHAR(64),
     178    uri VARCHAR(255),
     179    exp_type VARCHAR(64),
     180    filelevel VARCHAR(64),
     181    filter VARCHAR(64),
     182    comment VARCHAR(80),
     183    airmass FLOAT,
     184    ra DOUBLE,
     185    decl DOUBLE,
     186    exp_time FLOAT,
     187    sat_pixel_frac FLOAT,
     188    bg DOUBLE,
     189    bg_stdev DOUBLE,
     190    bg_mean_stdev DOUBLE,
     191    alt DOUBLE,
     192    az DOUBLE,
     193    ccd_temp FLOAT,
     194    posang DOUBLE,
     195    m1_x FLOAT,
     196    m1_y FLOAT,
     197    m1_z FLOAT,
     198    m1_tip FLOAT,
     199    m1_tilt FLOAT,
     200    m2_x FLOAT,
     201    m2_y FLOAT,
     202    m2_z FLOAT,
     203    m2_tip FLOAT,
     204    m2_tilt FLOAT,
     205    env_temperature FLOAT,
     206    env_humidity FLOAT,
     207    env_wind_speed FLOAT,
     208    env_wind_dir FLOAT,
     209    teltemp_m1 FLOAT,
     210    teltemp_m1cell FLOAT,
     211    teltemp_m2 FLOAT,
     212    teltemp_spider FLOAT,
     213    teltemp_truss FLOAT,
     214    teltemp_extra FLOAT,
     215    pon_time FLOAT,
     216    user_1 DOUBLE,
     217    user_2 DOUBLE,
     218    user_3 DOUBLE,
     219    user_4 DOUBLE,
     220    user_5 DOUBLE,
     221    object VARCHAR(64),
     222    hostname VARCHAR(64),
     223    fault SMALLINT NOT NULL,
     224    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     225    PRIMARY KEY(exp_id, class_id),
     226    KEY(tmp_class_id),
     227    KEY(fault),
     228    UNIQUE KEY(exp_id, tmp_class_id),
     229    FOREIGN KEY (exp_id, tmp_class_id)
     230        REFERENCES newImfile(exp_id, tmp_class_id))
     231ENGINE=innodb DEFAULT CHARSET=latin1;
     232
    67233CREATE TABLE guidePendingExp (guide_id BIGINT AUTO_INCREMENT, exp_id BIGINT, recipe VARCHAR(64), PRIMARY KEY(guide_id), KEY(guide_id), KEY(exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    68 CREATE TABLE chipRun (chip_id BIGINT AUTO_INCREMENT, exp_id BIGINT, state VARCHAR(64), workdir VARCHAR(255), workdir_state VARCHAR(64), label VARCHAR(64), reduction VARCHAR(64), expgroup VARCHAR(64), dvodb VARCHAR(255), tess_id VARCHAR(64), end_stage VARCHAR(64), PRIMARY KEY(chip_id), KEY(chip_id), KEY(exp_id), KEY(state), KEY(workdir_state), KEY(label), KEY(expgroup), KEY(end_stage), INDEX(chip_id, exp_id), FOREIGN KEY  (exp_id)  REFERENCES  rawExp(exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    69 CREATE TABLE chipProcessedImfile (chip_id BIGINT, exp_id BIGINT, class_id VARCHAR(64), uri VARCHAR(255), bg FLOAT, bg_stdev FLOAT, bg_mean_stdev FLOAT, bias FLOAT, bias_stdev FLOAT, fringe_0 FLOAT, fringe_1 FLOAT, fringe_2 FLOAT, sigma_ra FLOAT, sigma_dec FLOAT, ap_resid FLOAT, ap_resid_stdev FLOAT, zp_mean FLOAT, zp_stdev FLOAT, fwhm_major FLOAT, fwhm_minor FLOAT, dtime_detrend FLOAT, dtime_photom FLOAT, dtime_astrom FLOAT, hostname VARCHAR(64), n_stars INT, n_extended INT, n_cr INT, n_astrom INT, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(chip_id, exp_id, class_id), KEY(fault), FOREIGN KEY  (chip_id, exp_id)  REFERENCES  chipRun(chip_id, exp_id), FOREIGN KEY  (exp_id, class_id)  REFERENCES  rawImfile(exp_id, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    70 CREATE TABLE chipMask (label VARCHAR(64), PRIMARY KEY(label)) ENGINE=innodb DEFAULT CHARSET=latin1;
    71 CREATE TABLE camRun (cam_id BIGINT AUTO_INCREMENT, chip_id BIGINT, state VARCHAR(64), workdir VARCHAR(255), workdir_state VARCHAR(64), label VARCHAR(64), reduction VARCHAR(64), expgroup VARCHAR(64), dvodb VARCHAR(255), tess_id VARCHAR(64), end_stage VARCHAR(64), PRIMARY KEY(cam_id), KEY(cam_id), KEY(chip_id), KEY(state), KEY(workdir_state), KEY(label), KEY(expgroup), KEY(end_stage), INDEX(cam_id, chip_id), FOREIGN KEY (chip_id)  REFERENCES  chipRun(chip_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    72 CREATE TABLE camProcessedExp (cam_id BIGINT, chip_id BIGINT, uri VARCHAR(255), bg FLOAT, bg_stdev FLOAT, bg_mean_stdev FLOAT, bias FLOAT, bias_stdev FLOAT, fringe_0 FLOAT, fringe_1 FLOAT, fringe_2 FLOAT, sigma_ra FLOAT, sigma_dec FLOAT, ap_resid FLOAT, ap_resid_stdev FLOAT, zp_mean FLOAT, zp_stdev FLOAT, fwhm_major FLOAT, fwhm_minor FLOAT, dtime_detrend FLOAT, dtime_photom FLOAT, dtime_astrom FLOAT, hostname VARCHAR(64), n_stars INT, n_extended INT, n_cr INT, n_astrom INT, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(cam_id, chip_id), KEY(fault), FOREIGN KEY (cam_id, chip_id)  REFERENCES  camRun(cam_id, chip_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    73 CREATE TABLE camMask (label VARCHAR(64), PRIMARY KEY(label)) ENGINE=innodb DEFAULT CHARSET=latin1;
    74 CREATE TABLE detRun (det_id BIGINT AUTO_INCREMENT, iteration INT, det_type VARCHAR(64), mode VARCHAR(64), state VARCHAR(64), filelevel VARCHAR(64), workdir VARCHAR(255), camera VARCHAR(64), telescope VARCHAR(64), exp_type VARCHAR(64), reduction VARCHAR(64), filter VARCHAR(64), airmass_min FLOAT, airmass_max FLOAT, exp_time_min FLOAT, exp_time_max FLOAT, ccd_temp_min FLOAT, ccd_temp_max FLOAT, posang_min DOUBLE, posang_max DOUBLE, registered DATETIME, time_begin DATETIME, time_end DATETIME, use_begin DATETIME, use_end DATETIME, solang_min FLOAT, solang_max FLOAT, label VARCHAR(64), parent INT, PRIMARY KEY(det_id), KEY(det_id), KEY(iteration), KEY(det_type), KEY(mode), KEY(state), KEY(label), KEY(parent), INDEX(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
    75 CREATE TABLE detInputExp (det_id BIGINT, iteration INT, exp_id BIGINT, include TINYINT, PRIMARY KEY(det_id, iteration, exp_id), INDEX(det_id, exp_id), INDEX(det_id, iteration), FOREIGN KEY (det_id)  REFERENCES  detRun(det_id), FOREIGN KEY (exp_id)  REFERENCES  rawExp(exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    76 CREATE TABLE detProcessedImfile (det_id BIGINT, exp_id BIGINT, class_id VARCHAR(64), uri VARCHAR(255), recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, fringe_0 DOUBLE, fringe_1 DOUBLE, fringe_2 DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, exp_id, class_id), KEY(fault), INDEX(det_id, class_id), INDEX(det_id, exp_id), FOREIGN KEY (det_id, exp_id)  REFERENCES  detInputExp(det_id, exp_id), FOREIGN KEY (exp_id, class_id)  REFERENCES  rawImfile(exp_id, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    77 CREATE TABLE detProcessedExp (det_id BIGINT, exp_id BIGINT, recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, fringe_0 DOUBLE, fringe_1 DOUBLE, fringe_2 DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, exp_id), KEY(fault), FOREIGN KEY (det_id, exp_id)  REFERENCES  detInputExp(det_id, exp_id), FOREIGN KEY (det_id, exp_id)  REFERENCES  detProcessedImfile(det_id, exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    78 CREATE TABLE detStackedImfile (det_id BIGINT, iteration INT, class_id VARCHAR(64), uri VARCHAR(255), recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, class_id), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detInputExp(det_id, iteration), FOREIGN KEY (det_id, class_id)  REFERENCES  detProcessedImfile(det_id, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    79 CREATE TABLE detNormalizedStatImfile (det_id BIGINT, iteration INT, class_id VARCHAR(64), norm FLOAT, fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, class_id), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detInputExp(det_id, iteration), FOREIGN KEY (det_id, iteration, class_id)  REFERENCES  detStackedImfile(det_id, iteration, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    80 CREATE TABLE detNormalizedImfile (det_id BIGINT, iteration INT, class_id VARCHAR(64), uri VARCHAR(255), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, class_id), KEY(fault), INDEX(det_id, iteration), FOREIGN KEY (det_id)  REFERENCES  detInputExp(det_id), FOREIGN KEY (det_id, iteration, class_id)  REFERENCES  detNormalizedStatImfile(det_id, iteration, class_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    81 CREATE TABLE detNormalizedExp (det_id BIGINT, iteration INT, recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detInputExp(det_id, iteration), FOREIGN KEY (det_id, iteration)  REFERENCES  detNormalizedImfile(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
    82 CREATE TABLE detResidImfile (det_id BIGINT, iteration INT, exp_id BIGINT, class_id VARCHAR(64), uri VARCHAR(255), recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, bg_skewness DOUBLE, bg_kurtosis DOUBLE, bin_stdev DOUBLE, fringe_0 DOUBLE, fringe_1 DOUBLE, fringe_2 DOUBLE, fringe_resid_0 DOUBLE, fringe_resid_1 DOUBLE, fringe_resid_2 DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, exp_id, class_id), KEY(fault), INDEX(det_id, iteration, exp_id), FOREIGN KEY (det_id, iteration, exp_id)  REFERENCES  detInputExp(det_id, iteration, exp_id), FOREIGN KEY (det_id, exp_id, class_id)  REFERENCES  detProcessedImfile(det_id, exp_id, class_id), FOREIGN KEY (det_id, iteration)  REFERENCES  detNormalizedExp(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
     234
     235CREATE TABLE chipRun (
     236    chip_id BIGINT AUTO_INCREMENT,
     237    exp_id BIGINT,
     238    state VARCHAR(64),
     239    workdir VARCHAR(255),
     240    workdir_state VARCHAR(64),
     241    label VARCHAR(64),
     242    reduction VARCHAR(64),
     243     expgroup VARCHAR(64),
     244    dvodb VARCHAR(255),
     245    tess_id VARCHAR(64),
     246    end_stage VARCHAR(64),
     247    PRIMARY KEY(chip_id),
     248    KEY(chip_id), KEY(exp_id),
     249    KEY(state),
     250    KEY(workdir_state),
     251    KEY(label),
     252    KEY(expgroup),
     253    KEY(end_stage),
     254    INDEX(chip_id, exp_id),
     255    FOREIGN KEY (exp_id) 
     256        REFERENCES rawExp(exp_id))
     257ENGINE=innodb DEFAULT CHARSET=latin1;
     258
     259CREATE TABLE chipProcessedImfile (
     260    chip_id BIGINT,
     261    exp_id BIGINT,
     262    class_id VARCHAR(64),
     263    uri VARCHAR(255),
     264    bg FLOAT,
     265    bg_stdev FLOAT,
     266    bg_mean_stdev FLOAT,
     267    bias FLOAT,
     268    bias_stdev FLOAT,
     269    fringe_0 FLOAT,
     270    fringe_1 FLOAT,
     271    fringe_2 FLOAT,
     272    sigma_ra FLOAT,
     273    sigma_dec FLOAT,
     274    ap_resid FLOAT,
     275    ap_resid_stdev FLOAT,
     276    zp_mean FLOAT,
     277    zp_stdev FLOAT,
     278    fwhm_major FLOAT,
     279    fwhm_minor FLOAT,
     280    dtime_detrend FLOAT,
     281    dtime_photom FLOAT,
     282    dtime_astrom FLOAT,
     283    hostname VARCHAR(64),
     284    n_stars INT,
     285    n_extended INT,
     286    n_cr INT,
     287    n_astrom INT,
     288    path_base VARCHAR(255),
     289    fault SMALLINT NOT NULL,
     290    PRIMARY KEY(chip_id, exp_id, class_id),
     291    KEY(fault),
     292    FOREIGN KEY (chip_id, exp_id) 
     293        REFERENCES  chipRun(chip_id, exp_id),
     294    FOREIGN KEY (exp_id, class_id)
     295        REFERENCES  rawImfile(exp_id, class_id))
     296ENGINE=innodb DEFAULT CHARSET=latin1;
     297
     298CREATE TABLE chipMask (
     299    label VARCHAR(64),
     300    PRIMARY KEY(label))
     301ENGINE=innodb DEFAULT CHARSET=latin1;
     302
     303CREATE TABLE camRun (
     304    cam_id BIGINT AUTO_INCREMENT,
     305    chip_id BIGINT,
     306    state VARCHAR(64),
     307    workdir VARCHAR(255),
     308    workdir_state VARCHAR(64),
     309    label VARCHAR(64),
     310    reduction VARCHAR(64),
     311    expgroup VARCHAR(64),
     312    dvodb VARCHAR(255),
     313    tess_id VARCHAR(64),
     314    end_stage VARCHAR(64),
     315    PRIMARY KEY(cam_id),
     316    KEY(cam_id),
     317    KEY(chip_id),
     318    KEY(state),
     319    KEY(workdir_state),
     320    KEY(label),
     321    KEY(expgroup),
     322    KEY(end_stage),
     323    INDEX(cam_id, chip_id),
     324    FOREIGN KEY (chip_id) 
     325        REFERENCES chipRun(chip_id))
     326ENGINE=innodb DEFAULT CHARSET=latin1;
     327
     328CREATE TABLE camProcessedExp (
     329    cam_id BIGINT,
     330    chip_id BIGINT,
     331    uri VARCHAR(255),
     332    bg FLOAT,
     333    bg_stdev FLOAT,
     334    bg_mean_stdev FLOAT,
     335    bias FLOAT,
     336    bias_stdev FLOAT,
     337    fringe_0 FLOAT,
     338    fringe_1 FLOAT,
     339    fringe_2 FLOAT,
     340    sigma_ra FLOAT,
     341    sigma_dec FLOAT,
     342    ap_resid FLOAT,
     343    ap_resid_stdev FLOAT,
     344    zp_mean FLOAT,
     345    zp_stdev FLOAT,
     346    fwhm_major FLOAT,
     347    fwhm_minor FLOAT,
     348    dtime_detrend FLOAT,
     349    dtime_photom FLOAT,
     350    dtime_astrom FLOAT,
     351    hostname VARCHAR(64),
     352    n_stars INT,
     353    n_extended INT,
     354    n_cr INT,
     355    n_astrom INT,
     356    path_base VARCHAR(255),
     357    fault SMALLINT NOT NULL,
     358    PRIMARY KEY(cam_id, chip_id),
     359    KEY(fault),
     360    FOREIGN KEY (cam_id, chip_id) 
     361    REFERENCES camRun(cam_id, chip_id))
     362ENGINE=innodb DEFAULT CHARSET=latin1;
     363
     364CREATE TABLE camMask (
     365    label VARCHAR(64),
     366    PRIMARY KEY(label))
     367ENGINE=innodb DEFAULT CHARSET=latin1;
     368
     369CREATE TABLE detRun (
     370    det_id BIGINT AUTO_INCREMENT,
     371    iteration INT,
     372    det_type VARCHAR(64),
     373    mode VARCHAR(64),
     374    state VARCHAR(64),
     375    filelevel VARCHAR(64),
     376    workdir VARCHAR(255),
     377    camera VARCHAR(64),
     378    telescope VARCHAR(64),
     379    exp_type VARCHAR(64),
     380    reduction VARCHAR(64),
     381    filter VARCHAR(64),
     382    airmass_min FLOAT,
     383    airmass_max FLOAT,
     384    exp_time_min FLOAT,
     385    exp_time_max FLOAT,
     386    ccd_temp_min FLOAT,
     387    ccd_temp_max FLOAT,
     388    posang_min DOUBLE,
     389    posang_max DOUBLE,
     390    registered DATETIME,
     391    time_begin DATETIME,
     392    time_end DATETIME,
     393    use_begin DATETIME,
     394    use_end DATETIME,
     395    solang_min FLOAT,
     396    solang_max FLOAT,
     397    label VARCHAR(64),
     398    parent INT,
     399    PRIMARY KEY(det_id),
     400    KEY(det_id),
     401    KEY(iteration),
     402    KEY(det_type),
     403    KEY(mode),
     404    KEY(state),
     405    KEY(label),
     406    KEY(parent),
     407    INDEX(det_id, iteration))
     408ENGINE=innodb DEFAULT CHARSET=latin1;
     409
     410CREATE TABLE detInputExp (
     411det_id BIGINT,
     412iteration INT,
     413exp_id BIGINT,
     414include TINYINT,
     415PRIMARY KEY(det_id, iteration, exp_id),
     416INDEX(det_id, exp_id),
     417INDEX(det_id, iteration),
     418FOREIGN KEY (det_id) 
     419REFERENCES  detRun(det_id),
     420FOREIGN KEY (exp_id) 
     421REFERENCES  rawExp(exp_id))
     422ENGINE=innodb DEFAULT CHARSET=latin1;
     423
     424CREATE TABLE detProcessedImfile (
     425    det_id BIGINT,
     426    exp_id BIGINT,
     427    class_id VARCHAR(64),
     428    uri VARCHAR(255),
     429    recipe VARCHAR(64),
     430    bg DOUBLE,
     431    bg_stdev DOUBLE,
     432    bg_mean_stdev DOUBLE,
     433    fringe_0 DOUBLE,
     434    fringe_1 DOUBLE,
     435    fringe_2 DOUBLE,
     436    user_1 DOUBLE,
     437    user_2 DOUBLE,
     438    user_3 DOUBLE,
     439    user_4 DOUBLE,
     440    user_5 DOUBLE,
     441    path_base VARCHAR(255),
     442    fault SMALLINT NOT NULL,
     443    PRIMARY KEY(det_id, exp_id, class_id),
     444    KEY(fault),
     445    INDEX(det_id, class_id),
     446    INDEX(det_id, exp_id),
     447    FOREIGN KEY (det_id, exp_id) 
     448        REFERENCES  detInputExp(det_id, exp_id),
     449    FOREIGN KEY (exp_id, class_id) 
     450        REFERENCES  rawImfile(exp_id, class_id)
     451) ENGINE=innodb DEFAULT CHARSET=latin1;
     452
     453CREATE TABLE detProcessedExp (
     454    det_id BIGINT,
     455    exp_id BIGINT,
     456    recipe VARCHAR(64),
     457    bg DOUBLE,
     458    bg_stdev DOUBLE,
     459    bg_mean_stdev DOUBLE,
     460    fringe_0 DOUBLE,
     461    fringe_1 DOUBLE,
     462    fringe_2 DOUBLE,
     463    user_1 DOUBLE,
     464    user_2 DOUBLE,
     465    user_3 DOUBLE,
     466    user_4 DOUBLE,
     467    user_5 DOUBLE,
     468    path_base VARCHAR(255),
     469    fault SMALLINT NOT NULL,
     470    PRIMARY KEY(det_id, exp_id),
     471    KEY(fault),
     472    FOREIGN KEY (det_id, exp_id) 
     473        REFERENCES  detInputExp(det_id, exp_id),
     474    FOREIGN KEY (det_id, exp_id) 
     475        REFERENCES  detProcessedImfile(det_id, exp_id)
     476) ENGINE=innodb DEFAULT CHARSET=latin1;
     477
     478CREATE TABLE detStackedImfile (
     479    det_id BIGINT,
     480    iteration INT,
     481    class_id VARCHAR(64),
     482    uri VARCHAR(255),
     483    recipe VARCHAR(64),
     484    bg DOUBLE,
     485    bg_stdev DOUBLE,
     486    bg_mean_stdev DOUBLE,
     487    user_1 DOUBLE,
     488    user_2 DOUBLE,
     489    user_3 DOUBLE,
     490    user_4 DOUBLE,
     491    user_5 DOUBLE,
     492    fault SMALLINT NOT NULL,
     493    PRIMARY KEY(det_id, iteration, class_id),
     494    KEY(fault),
     495    FOREIGN KEY (det_id, iteration) 
     496        REFERENCES  detInputExp(det_id, iteration),
     497    FOREIGN KEY (det_id, class_id) 
     498        REFERENCES  detProcessedImfile(det_id, class_id)
     499) ENGINE=innodb DEFAULT CHARSET=latin1;
     500
     501CREATE TABLE detNormalizedStatImfile (
     502    det_id BIGINT,
     503    iteration INT,
     504    class_id VARCHAR(64),
     505    norm FLOAT,
     506    fault SMALLINT NOT NULL,
     507    PRIMARY KEY(det_id, iteration, class_id),
     508    KEY(fault),
     509    FOREIGN KEY (det_id, iteration) 
     510    REFERENCES  detInputExp(det_id, iteration),
     511    FOREIGN KEY (det_id, iteration, class_id) 
     512    REFERENCES  detStackedImfile(det_id, iteration, class_id)
     513) ENGINE=innodb DEFAULT CHARSET=latin1;
     514
     515CREATE TABLE detNormalizedImfile (
     516    det_id BIGINT,
     517    iteration INT,
     518    class_id VARCHAR(64),
     519    uri VARCHAR(255),
     520    bg DOUBLE,
     521    bg_stdev DOUBLE,
     522    bg_mean_stdev DOUBLE,
     523    user_1 DOUBLE,
     524    user_2 DOUBLE,
     525    user_3 DOUBLE,
     526    user_4 DOUBLE,
     527    user_5 DOUBLE,
     528    path_base VARCHAR(255),
     529    fault SMALLINT NOT NULL,
     530    PRIMARY KEY(det_id, iteration, class_id),
     531    KEY(fault),
     532    INDEX(det_id, iteration),
     533    FOREIGN KEY (det_id) 
     534    REFERENCES  detInputExp(det_id),
     535    FOREIGN KEY (det_id, iteration, class_id) 
     536    REFERENCES  detNormalizedStatImfile(det_id, iteration, class_id)
     537) ENGINE=innodb DEFAULT CHARSET=latin1;
     538
     539CREATE TABLE detNormalizedExp (
     540    det_id BIGINT,
     541    iteration INT,
     542    recipe VARCHAR(64),
     543    bg DOUBLE,
     544    bg_stdev DOUBLE,
     545    bg_mean_stdev DOUBLE,
     546    user_1 DOUBLE,
     547    user_2 DOUBLE,
     548    user_3 DOUBLE,
     549    user_4 DOUBLE,
     550    user_5 DOUBLE,
     551    path_base VARCHAR(255),
     552    fault SMALLINT NOT NULL,
     553    PRIMARY KEY(det_id, iteration),
     554    KEY(fault),
     555    FOREIGN KEY (det_id, iteration) 
     556    REFERENCES  detInputExp(det_id, iteration),
     557    FOREIGN KEY (det_id, iteration) 
     558    REFERENCES  detNormalizedImfile(det_id, iteration)
     559) ENGINE=innodb DEFAULT CHARSET=latin1;
     560
     561CREATE TABLE detResidImfile (
     562    det_id BIGINT,
     563    iteration INT,
     564    exp_id BIGINT,
     565    class_id VARCHAR(64),
     566    uri VARCHAR(255),
     567    recipe VARCHAR(64),
     568    bg DOUBLE,
     569    bg_stdev DOUBLE,
     570    bg_mean_stdev DOUBLE,
     571    bg_skewness DOUBLE,
     572    bg_kurtosis DOUBLE,
     573    bin_stdev DOUBLE,
     574    fringe_0 DOUBLE,
     575    fringe_1 DOUBLE,
     576    fringe_2 DOUBLE,
     577    fringe_resid_0 DOUBLE,
     578    fringe_resid_1 DOUBLE,
     579    fringe_resid_2 DOUBLE,
     580    user_1 DOUBLE,
     581    user_2 DOUBLE,
     582    user_3 DOUBLE,
     583    user_4 DOUBLE,
     584    user_5 DOUBLE,
     585    path_base VARCHAR(255),
     586    fault SMALLINT NOT NULL,
     587    PRIMARY KEY(det_id, iteration, exp_id, class_id),
     588    KEY(fault),
     589    INDEX(det_id, iteration, exp_id),
     590    FOREIGN KEY (det_id, iteration, exp_id) 
     591    REFERENCES  detInputExp(det_id, iteration, exp_id),
     592    FOREIGN KEY (det_id, exp_id, class_id) 
     593    REFERENCES  detProcessedImfile(det_id, exp_id, class_id),
     594    FOREIGN KEY (det_id, iteration) 
     595    REFERENCES  detNormalizedExp(det_id, iteration)
     596) ENGINE=innodb DEFAULT CHARSET=latin1;
     597
    83598CREATE TABLE detResidExp (det_id BIGINT, iteration INT, exp_id BIGINT, recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, bg_skewness DOUBLE, bg_kurtosis DOUBLE, bin_stdev DOUBLE, fringe_0 DOUBLE, fringe_1 DOUBLE, fringe_2 DOUBLE, fringe_resid_0 DOUBLE, fringe_resid_1 DOUBLE, fringe_resid_2 DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), accept TINYINT, fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, exp_id), KEY(fault), INDEX(det_id, iteration), FOREIGN KEY (det_id, iteration, exp_id)  REFERENCES  detInputExp(det_id, iteration, exp_id), FOREIGN KEY (det_id, iteration, exp_id)  REFERENCES  detResidImfile(det_id, iteration, exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    84599CREATE TABLE detRunSummary (det_id BIGINT, iteration INT, bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, accept TINYINT, fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detInputExp(det_id, iteration), FOREIGN KEY (det_id, iteration)  REFERENCES  detResidExp(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
    85600CREATE TABLE detRegisteredImfile (det_id BIGINT, iteration INT, class_id VARCHAR(64), uri VARCHAR(255), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, class_id), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detRun(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
     601
    86602CREATE TABLE warpRun (warp_id BIGINT AUTO_INCREMENT, cam_id BIGINT, mode VARCHAR(64), state VARCHAR(64), workdir VARCHAR(255), workdir_state VARCHAR(64), label VARCHAR(64), dvodb VARCHAR(255), tess_id VARCHAR(64), end_stage VARCHAR(64), registered DATETIME, magiced TINYINT, PRIMARY KEY(warp_id), KEY(warp_id), KEY(cam_id), KEY(mode), KEY(state), KEY(workdir_state), KEY(label), KEY(end_stage), KEY(magiced), INDEX(warp_id, cam_id), FOREIGN KEY (cam_id)  REFERENCES  camProcessedExp(cam_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    87603CREATE TABLE warpSkyCellMap (warp_id BIGINT, skycell_id VARCHAR(64), tess_id VARCHAR(64), cam_id BIGINT, class_id VARCHAR(64), fault SMALLINT, PRIMARY KEY(warp_id, skycell_id, tess_id, cam_id, class_id), KEY(fault), FOREIGN KEY (warp_id, cam_id)  REFERENCES  warpRun(warp_id, cam_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
Note: See TracChangeset for help on using the changeset viewer.