Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | auto_increment | |
run_number | int(19) | NO | MUL | 0 | |
start_time | datetime | YES | MUL | ||
end_time | datetime | YES | |||
total_event | int(19) | YES | |||
ini_beam_energy | double | YES | |||
magnet_current | double | YES | |||
run_task | varchar(255) | YES | |||
beam_status | varchar(255) | YES | |||
Lum_begin | double | YES | |||
Lum_end | double | YES | |||
hit_map | tinyint(1) | YES | |||
hit_map_mdc | tinyint(1) | YES | |||
hit_map_mdc_text | varchar(255) | YES | |||
hit_map_tof | tinyint(1) | YES | |||
hit_map_tof_text | varchar(255) | YES | |||
hit_map_emc | tinyint(1) | YES | |||
hit_map_emc_text | varchar(255) | YES | |||
hit_map_muon | tinyint(1) | YES | |||
hit_map_muon_text | varchar(255) | YES | |||
hit_map_trigger | tinyint(1) | YES | |||
hit_map_trigger_text | varchar(255) | YES | |||
hv | tinyint(1) | YES | |||
hv_mdc | tinyint(1) | YES | |||
hv_mdc_text | varchar(255) | YES | |||
hv_tof | tinyint(1) | YES | |||
hv_tof_text | varchar(255) | YES | |||
hv_muon | tinyint(1) | YES | |||
hv_muon_text | varchar(255) | YES | |||
other_problem | tinyint(1) | YES | |||
system_daq | tinyint(1) | YES | |||
system_mdc | tinyint(1) | YES | |||
system_emc | tinyint(1) | YES | |||
system_muon | tinyint(1) | YES | |||
system_tof | tinyint(1) | YES | |||
system_trigger | tinyint(1) | YES | |||
system_gas | tinyint(1) | YES | |||
system_text | varchar(500) | YES | |||
conclusion | varchar(20) | YES | |||
comment_text | varchar(10000) | YES | |||
shift_chief | varchar(32) | YES | |||
create_time | datetime | YES | |||
coordinator_confirm | varchar(20) | YES | |||
confirm_time | datetime | YES | MUL | ||
cgem_status | enum('NoData','NoMergerged','OK') | YES |
Know more about the database in Database dictionary!