===========
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 | |
+-------------+---------------+------+-----+-------------------+-----------------------------+