=========== ExoFOP-K2C9 K2 C9 microlensing campaign March 15, 2022 K2C9 Microlensing Event summary: exofop_k2c9_events_20220315_135352.csv - microlensing event summary data (originally available here: https://exofop.ipac.caltech.edu/k2/microlensing/event_list.php) MySQL Database table exports in pipe delimted format: k2c9_changelog_2022-03-15_13:25:32.txt - record of user uploaded content k2c9_event_param_2022-03-15_13:25:32_nulls_corrected.txt - microlensing event data paramters ("NULL" values are replaced with "") k2c9_event_param_2022-03-15_13:25:32.txt - microlensing event data parameters k2c9_files_2022-03-15_13:25:32.txt - decribes microlensing event files k2c9_i_cur_2022-03-15_13:25:32.txt - most recent microlensing event parameters at the time of the K2C9 microlensing alert campaign Files directory: event - directory containting microlensing event files Table format descriptions: Description of the k2c9_changelog table - 7 columns +--------+--------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +--------+--------------+------+-----+-------------------+-----------------------------+ | id | int(5) | NO | PRI | NULL | auto_increment | | bulkid | int(5) | YES | | NULL | | | event | varchar(45) | YES | | NULL | | | user | varchar(20) | YES | | NULL | | | action | varchar(100) | YES | | NULL | | | date | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | | shown | char(1) | YES | | NULL | | +--------+--------------+------+-----+-------------------+-----------------------------+ Description of the k2c9_event_param table - 106 columns +-------------------+---------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------+------+-----+-------------------+-----------------------------+ | id | int(5) | NO | PRI | NULL | auto_increment | | eid | varchar(20) | YES | | NULL | | | first_created | varchar(22) | YES | | NULL | | | last_mod | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | | last_mod_by | varchar(20) | YES | | NULL | | | filehand | varchar(50) | YES | | NULL | | | artemis_status | varchar(20) | YES | | NULL | | | official_name | varchar(75) | YES | | NULL | | | ogle_name | varchar(25) | YES | | NULL | | | ogle_survey_id | varchar(30) | YES | | NULL | | | ogle_alert | varchar(22) | YES | | NULL | | | ogle_alert_hjd | double(13,6) | YES | | NULL | | | ogle_ra | double(13,10) | YES | | NULL | | | ogle_dec | double(13,10) | YES | | NULL | | | ogle_t0 | double(11,3) | YES | | NULL | | | ogle_sig_t0 | double(5,3) | YES | | NULL | | | ogle_a0 | double(9,3) | YES | | NULL | | | ogle_sig_a0 | double(5,3) | YES | | NULL | | | ogle_te | double(9,3) | YES | | NULL | | | ogle_sig_te | double(5,3) | YES | | NULL | | | ogle_u0 | double(6,3) | YES | | NULL | | | ogle_sig_u0 | double(5,3) | YES | | NULL | | | ogle_i0 | double(6,3) | YES | | NULL | | | ogle_sig_i0 | double(5,3) | YES | | NULL | | | ogle_ndata | int(5) | YES | | NULL | | | ogle_url | varchar(120) | YES | | NULL | | | moa_name | varchar(25) | YES | | NULL | | | moa_survey_id | varchar(30) | YES | | NULL | | | moa_alert | varchar(22) | YES | | NULL | | | moa_alert_hjd | double(13,6) | YES | | NULL | | | moa_ra | double(13,10) | YES | | NULL | | | moa_dec | double(13,10) | YES | | NULL | | | moa_t0 | double(13,5) | YES | | NULL | | | moa_sig_t0 | double(5,3) | YES | | NULL | | | moa_a0 | double(13,5) | YES | | NULL | | | moa_sig_a0 | double(5,3) | YES | | NULL | | | moa_te | double(13,5) | YES | | NULL | | | moa_sig_te | double(5,3) | YES | | NULL | | | moa_u0 | double(6,3) | YES | | NULL | | | moa_sig_u0 | double(5,3) | YES | | NULL | | | moa_i0 | double(6,3) | YES | | NULL | | | moa_sig_i0 | double(5,3) | YES | | NULL | | | moa_ndata | int(5) | YES | | NULL | | | moa_url | varchar(120) | YES | | NULL | | | kmt_name | varchar(25) | YES | | NULL | | | kmt_survey_id | varchar(30) | YES | | NULL | | | kmt_alert | varchar(22) | YES | | NULL | | | kmt_alert_hjd | double(13,6) | YES | | NULL | | | kmt_ra | double(13,10) | YES | | NULL | | | kmt_dec | double(13,10) | YES | | NULL | | | kmt_t0 | double(11,3) | YES | | NULL | | | kmt_sig_t0 | double(5,3) | YES | | NULL | | | kmt_a0 | double(9,3) | YES | | NULL | | | kmt_sig_a0 | double(5,3) | YES | | NULL | | | kmt_te | double(9,3) | YES | | NULL | | | kmt_sig_te | double(5,3) | YES | | NULL | | | kmt_u0 | double(6,3) | YES | | NULL | | | kmt_sig_u0 | double(5,3) | YES | | NULL | | | kmt_i0 | double(6,3) | YES | | NULL | | | kmt_sig_i0 | double(5,3) | YES | | NULL | | | kmt_ndata | int(5) | YES | | NULL | | | kmt_url | varchar(120) | YES | | NULL | | | signalmen_a0 | double(16,14) | YES | | NULL | | | signalmen_t0 | double(13,6) | YES | | NULL | | | signalmen_sig_t0 | double(8,6) | YES | | NULL | | | signalmen_te | double(12,6) | YES | | NULL | | | signalmen_sig_te | double(12,6) | YES | | NULL | | | signalmen_u0 | double(8,6) | YES | | NULL | | | signalmen_sig_u0 | double(8,6) | YES | | NULL | | | signalmen_anomaly | int(2) | YES | | NULL | | | pylima_a0 | double(3,1) | YES | | NULL | | | pylima_sig_a0 | double(5,3) | YES | | NULL | | | pylima_te | double(5,3) | YES | | NULL | | | pylima_sig_te | double(5,3) | YES | | NULL | | | pylima_t0 | double(11,3) | YES | | NULL | | | pylima_sig_t0 | double(5,3) | YES | | NULL | | | pylima_u0 | double(7,5) | YES | | NULL | | | pylima_sig_u0 | double(7,5) | YES | | NULL | | | pylima_rho | double(6,4) | YES | | NULL | | | pylima_sig_rho | double(5,3) | YES | | NULL | | | bozza_a0 | double(5,3) | YES | | NULL | | | bozza_sig_a0 | double(5,3) | YES | | NULL | | | bozza_te | double(5,3) | YES | | NULL | | | bozza_sig_te | double(5,3) | YES | | NULL | | | bozza_t0 | double(11,3) | YES | | NULL | | | bozza_sig_t0 | double(5,3) | YES | | NULL | | | bozza_u0 | double(7,5) | YES | | NULL | | | bozza_sig_u0 | double(7,5) | YES | | NULL | | | bozza_rho | double(6,4) | YES | | NULL | | | bozza_sig_rho | double(5,3) | YES | | NULL | | | bozza_s | double(5,3) | YES | | NULL | | | bozza_sig_s | double(7,5) | YES | | NULL | | | bozza_q | double(7,5) | YES | | NULL | | | bozza_sig_q | double(7,5) | YES | | NULL | | | bozza_theta | double(8,6) | YES | | NULL | | | bozza_sig_theta | double(7,5) | YES | | NULL | | | bozza_pi_perp | double(7,5) | YES | | NULL | | | bozza_sig_pi_perp | double(7,5) | YES | | NULL | | | bozza_pi_para | double(6,4) | YES | | NULL | | | bozza_sig_pi_para | double(8,6) | YES | | NULL | | | bozza_url | varchar(120) | YES | | NULL | | | nnewdata | int(3) | YES | | NULL | | | during_campaign | varchar(5) | YES | | NULL | | | in_footprint | varchar(5) | YES | | NULL | | | in_superstamp | varchar(5) | YES | | NULL | | | time_last_updated | varchar(22) | YES | | NULL | | +-------------------+---------------+------+-----+-------------------+-----------------------------+ Decription of the k2c9_files table - 8 columns: +---------+--------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+-------------------+-----------------------------+ | id | int(5) | NO | PRI | NULL | auto_increment | | eid | varchar(20) | YES | | NULL | | | type | varchar(30) | YES | | NULL | | | name | varchar(100) | YES | | NULL | | | descr | varchar(200) | YES | | NULL | | | date | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | | user | varchar(20) | YES | | NULL | | | deleted | char(1) | YES | | NULL | | +---------+--------------+------+-----+-------------------+-----------------------------+ Description of the k2c9_i_curtable - 8 columns: +-------------+---------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+-------------------+-----------------------------+ | id | int(5) | NO | PRI | NULL | auto_increment | | eid | varchar(20) | YES | | NULL | | | ref_jd | double(10,2) | YES | | NULL | | | hjd | double(16,8) | YES | | NULL | | | mag | double(13,10) | YES | | NULL | | | mag_err | double(5,3) | YES | | NULL | | | last_mod | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | | last_mod_by | varchar(20) | YES | | NULL | | +-------------+---------------+------+-----+-------------------+-----------------------------+