Tables in CenterDB:

database:run

Table Name / description / Last Edit
RunParams / Run Parameters / 081105
StorageInfo / StorageInfo / 081105
OnlineLum / OnlineLum / 081105
runstatus / Run status (fill in by shift) / 081105
TrgTable / Trigger table / 081105
SC_Magnet / Superconductor magnet info / 081105
BEPCII / Parameter from BEPCII / 081105
MQT / MDC threshold / 081105
TFEE / TOF threshold / 081105
EMC_Crate_XXX / EMC PED / 081105
MDC_Crate_XXX / MDC PED / 081105

1

Table_name: RunParams

Column_name / Data type / description
run_number / int(11) / Run number
status / ‘INSTART','END' / ‘END’ shows the run end normally.
max_events / int(11) / Maximum of events can be stored in this run
rec_enable / int(11) / 1: Enable store data in file.
run_type / varchar(20) / Run type(Physics、Calibration、PED、Monitor)
startTime / datetime / Time of run start
endTime / datetime / Time of run end
totalTime / int(11) / Total time of run
numberOfEvents / int(11) / Number of events stored in local of DAQ
numberOfEvents_Castor / int unsigned / Number of events stored in castor.
MDC_PED / int unsigned / =>MDC_Crate_xxx.run_number
EMC_PED / int unsigned / =>EMC_Crate_xxx.run_number
trgtable_id / int(11) / =>TrgTable.Obj_id
MQT_fileid / Intunsigned / =>MQT.FILEID
TFEE_fileid / int unsigned / =>TFEE.FILEID
R_TM_BPR_PatNum / double / Bunch Number of Positron Beam
R_TM_BER_PatNum / double / Bunch Number of Electron Beam
S_R3O_BI_DCCT_current / double / Current of Positron Beam at begin run
E_R3O_BI_DCCT_current / double / Current of Positron Beam at end run
AV_R3O_BI_DCCT_curren / double / Average Current of Positron Beam during the run
S_R4O_BI_DCCT_current / double / Current of Electron Beam at begin run
E_R4O_BI_DCCT_current / double / Current of Electron Beam at end run
AV_R4O_BI_DCCT_current / double / Average Current of Electron Beam during the run
BPR_PRB / double / Energy of Positron Beam
BER_PRB / double / Energy of Electron Beam
S_BPR_LIFE / double / Life of Positron Beamat begin run
E_BPR_LIFE / double / Life of Positron Beamat end run
AV_BPR_LIFE / double / Average Life of Positron Beamduring the run
S_BER_LIFE / double / Life of Electron Beamat begin run
E_BER_LIFE / double / Life of Electron Beamat end run
AV_BER_LIFE / double / Average Life of Electron Beamduring the run
DATA_VERSION / float / Version number of DAQ data format

Table_name: StorageInfo

Column_name / Data type / Comment
id / int primary key / Auto increment, primary key
run_number / Int index / =>RunParams.run_number
startTime / Datetime / Time at open file
endTime / Datetime / Time at close file
host / varchar(50) / The host name used to store data file.
filename / varchar(255) / Data file name
status / varchar(50) / File status(‘opened’、‘closed’).close: file closed normally.
numberofEvents / int / Number of events in the file

Table_name: OnlineLum

Column_name / Data type / Comment
id / int primary key / Auto increment, primary key
run_number / int(11) / Run number
NumCorBEE / int(11) / The value is the corrected number of e+ e- events in this run
NumCorEEE / int(11) / The value is the corrected number of e+ e- events in this run.
NumCorUU / int(11) / The value is the corrected number of dimuon events in this run.
NumCorGG / int(11) / The value is the corrected number of diphoton events in this run.
NumCorHadron / int(11) / The value is the corrected number of hadronic events in this run.
SNR / int(11) / The value is the ratio between signal and noise.
IntLumEndcapEE / float / The integral luminosity(nb^-1) is calculated by the number of Endcap e+ e- events.
XSecbyEndcapEE / float / The cross section(nb) of hadron is calculated by LumEndcapEE.

Table_name:runstatus

Column_name / Data type / Comment
`id` / int primary key / serial number, auto increment, primary key
`run_number` / int (index) / Run number
`start_time` / datetime (index) / Time at begin run
`end_time` / datetime (index) / Time at end run
`total_event` / int(19) / Total number of events
`ini_beam_energy` / double / initialied beam energy
`magnet_current` / double / Magnet current
`run_task` / varchar(255) / Run task: (j/psi, psi, etc)
`beam_status` / varchar(255) / Beam status (collision, no beam, e+, etc)
`hit_map` / tinyint(1) / Hit_map:0 normal; 1 abnormal
`hit_map_mdc` / tinyint(1) / 0 normal; 1 abnormal
`hit_map_mdc_text` / varchar(255) / 0 normal; 1 abnormal
`hit_map_tof` / tinyint(1) / 0 normal; 1 abnormal
`hit_map_tof_text` / varchar(255) / 0 normal; 1 abnormal
`hit_map_emc` / tinyint(1) / 0 normal; 1 abnormal
`hit_map_emc_text` / varchar(255) / 0 normal; 1 abnormal
`hit_map_muon` / tinyint(1) / 0 normal; 1 abnormal
`hit_map_muon_text` / varchar(255) / 0 normal; 1 abnormal
`hit_map_trigger` / tinyint(1) / 0 normal; 1 abnormal
`hit_map_trigger_text` / varchar(255) / 0 normal; 1 abnormal
`hv` / tinyint(1) / High voltage:0 normal; 1 abnormal
`hv_mdc` / tinyint(1) / 0 normal; 1 abnormal
`hv_mdc_text` / varchar(255) / 0 normal; 1 abnormal
`hv_tof` / tinyint(1) / 0 normal; 1 abnormal
`hv_tof_text` / varchar(255) / 0 normal; 1 abnormal
`hv_muon` / tinyint(1) / 0 normal; 1 abnormal
`hv_muon_text` / varchar(255) / 0 normal; 1 abnormal
`other_problem` / tinyint(1) / 0 normal; 1 abnormal
`system_daq` / tinyint(1) / 0 normal; 1 abnormal
`system_mdc` / tinyint(1) / 0 normal; 1 abnormal
`system_emc` / tinyint(1) / 0 normal; 1 abnormal
`system_muon` / tinyint(1) / 0 normal; 1 abnormal
`system_tof` / tinyint(1) / 0 normal; 1 abnormal
`system_trigger` / tinyint(1) / 0 normal; 1 abnormal
`system_gas` / tinyint(1) / 0 normal; 1 abnormal
`system_text` / varchar(500) / 0 normal; 1 abnormal
`conclusion` / char(20) / ‘bad’, ‘good’, ‘uncertainly’
`comment_text` / varchar(10000) / comment
`shift_chief` / varchar(32) / Name of shift chief
`create_time` / datetime / Time when the record create

Table_name: TrgTable

Column_name / Data type / Comment
Obj_id / int(11) / Auto increment, primary key
FileId / int(11) / Datafile id, ->Data.DataFileId
OID / varchar(255) / Object id
EventChannelEnableRegister / int(10) / Event channel enable
TrgTable_CH01_1 / int(10) / Parameter 1 of trigger channel 1
TrgTable_CH01_2 / int(10) / Parameter 2 of trigger channel 1
TrgTable_CH01_3 / int(10) / Parameter 3 of trigger channel 1
TrgTable_CH01_4 / int(10) / Parameter 4 of trigger channel 1
TrgTable_CH02_1 / int(10) / Parameter 1 of trigger channel 2
TrgTable_CH02_2 / int(10) / Parameter 2 of trigger channel 2
TrgTable_CH02_3 / int(10) / Parameter 3 of trigger channel 2
TrgTable_CH02_4 / int(10) / Parameter 4 of trigger channel 2
TrgTable_CH03_1 / int(10) / Parameter 1 of trigger channel 3
TrgTable_CH03_2 / int(10) / Parameter 2 of trigger channel 3
TrgTable_CH03_3 / int(10) / Parameter 3 of trigger channel 3
TrgTable_CH03_4 / int(10) / Parameter 4 of trigger channel 3
TrgTable_CH04_1 / int(10) / Parameter 1 of trigger channel 4
TrgTable_CH04_2 / int(10) / Parameter 2 of trigger channel 4
TrgTable_CH04_3 / int(10) / Parameter 3 of trigger channel 4
TrgTable_CH04_4 / int(10) / Parameter 4 of trigger channel 4
TrgTable_CH05_1 / int(10) / Parameter 1 of trigger channel 5
TrgTable_CH05_2 / int(10) / Parameter 2 of trigger channel 5
TrgTable_CH05_3 / int(10) / Parameter 3 of trigger channel 5
TrgTable_CH05_4 / int(10) / Parameter 4 of trigger channel 5
TrgTable_CH06_1 / int(10) / Parameter 1 of trigger channel 6
TrgTable_CH06_2 / int(10) / Parameter 2 of trigger channel 6
TrgTable_CH06_3 / int(10) / Parameter 3 of trigger channel 6
TrgTable_CH06_4 / int(10) / Parameter 4 of trigger channel 6
TrgTable_CH07_1 / int(10) / Parameter 1 of trigger channel 7
TrgTable_CH07_2 / int(10) / Parameter 2 of trigger channel 7
TrgTable_CH07_3 / int(10) / Parameter 3 of trigger channel 7
TrgTable_CH07_4 / int(10) / Parameter 4 of trigger channel 7
TrgTable_CH08_1 / int(10) / Parameter 1 of trigger channel 8
TrgTable_CH08_2 / int(10) / Parameter 2 of trigger channel 8
TrgTable_CH08_3 / int(10) / Parameter 3 of trigger channel 8
TrgTable_CH08_4 / int(10) / Parameter 4 of trigger channel 8
TrgTable_CH09_1 / int(10) / Parameter 1 of trigger channel 9
TrgTable_CH09_2 / int(10) / Parameter 2 of trigger channel 9
TrgTable_CH09_3 / int(10) / Parameter 3 of trigger channel 9
TrgTable_CH09_4 / int(10) / Parameter 4 of trigger channel 9
TrgTable_CH10_1 / int(10) / Parameter 1 of trigger channel 10
TrgTable_CH10_2 / int(10) / Parameter 2 of trigger channel 10
TrgTable_CH10_3 / int(10) / Parameter 3 of trigger channel 10
TrgTable_CH10_4 / int(10) / Parameter 4 of trigger channel 10
TrgTable_CH11_1 / int(10) / Parameter 1 of trigger channel 11
TrgTable_CH11_2 / int(10) / Parameter 2 of trigger channel 11
TrgTable_CH11_3 / int(10) / Parameter 3 of trigger channel 11
TrgTable_CH11_4 / int(10) / Parameter 4 of trigger channel 11
TrgTable_CH12_1 / int(10) / Parameter 1 of trigger channel 12
TrgTable_CH12_2 / int(10) / Parameter 2 of trigger channel 12
TrgTable_CH12_3 / int(10) / Parameter 3 of trigger channel 12
TrgTable_CH12_4 / int(10) / Parameter 4 of trigger channel 12
TrgTable_CH13_1 / int(10) / Parameter 1 of trigger channel 13
TrgTable_CH13_2 / int(10) / Parameter 2 of trigger channel 13
TrgTable_CH13_3 / int(10) / Parameter 3 of trigger channel 13
TrgTable_CH13_4 / int(10) / Parameter 4 of trigger channel 13
TrgTable_CH14_1 / int(10) / Parameter 1 of trigger channel 14
TrgTable_CH14_2 / int(10) / Parameter 2 of trigger channel 14
TrgTable_CH14_3 / int(10) / Parameter 3 of trigger channel 14
TrgTable_CH14_4 / int(10) / Parameter 4 of trigger channel 14
TrgTable_CH15_1 / int(10) / Parameter 1 of trigger channel 15
TrgTable_CH15_2 / int(10) / Parameter 2 of trigger channel 15
TrgTable_CH15_3 / int(10) / Parameter 3 of trigger channel 15
TrgTable_CH15_4 / int(10) / Parameter 4 of trigger channel 15
TrgTable_CH16_1 / int(10) / Parameter 1 of trigger channel 16
TrgTable_CH16_2 / int(10) / Parameter 2 of trigger channel 16
TrgTable_CH16_3 / int(10) / Parameter 3 of trigger channel 16
TrgTable_CH16_4 / int(10) / Parameter 4 of trigger channel 16

The value of "EventChannelEnableRegister" is 0Xhhhhhhhh. The low 16 bits corresponding 16 trigger channel. ‘1’ means the channel is enable, ‘0’ means the channel is disable. Bit00-bit15 corresponding to 16 trigger channels.

In "TrgTable_CH##_*", ## means the trigger channel number, * means the parameters 1-4 of trigger channel. Four parameters of one trigger channel is 32*4=128bit, two bits corresponding one trigger condition. Bit00-Bit01 is the trigger condition1, Bit02-Bit03 is the trigger condition 2, and so on.

Table_name: SC_magnet

Column_name / Data type / Comment
run_number / int primary key / =>RunParams.run_number
S_SSM / double / Superconductor magnet current
ASL / double / The Sampled Current of ASL
AS2L / double / The Sampled Current of AS2L
AS3L / double / The Sampled Current of AS3L
SCQL / double / The Sampled Current of SCQL
SSKQL / double / The Sampled Current of SSKQL
HDCL / double / The Sampled Current of HDCL
VDCL / double / The Sampled Current of VDCL
ASR / double / The Sampled Current of ASR
AS2R / double / The Sampled Current of AS2R
AS3R / double / The Sampled Current of AS3R
SCQR / double / The Sampled Current of SCQR
SSKQR / double / The Sampled Current of SSKQR
HDCR / double / The Sampled Current of HDCR
VDCR / double / The Sampled Current of VDCR

Table_name: BEPCII

Column_name / Data type / Comment
run_number / int index / =>RunParams.run_number
R3I_VA_BAG1_Ai_Pr / double / Pressure Value of BAG1 at R3I
R3I_VA_CCG2_Ai_Pr / double / Pressure Value of CCG2 at R3I
R3O_VA_BAG1_Ai_Pr / double / Pressure Value of BAG1 at R3O
R3O_VA_CCG2_Ai_Pr / double / Pressure Value of CCG2 at R3O
R4I_VA_BAG1_Ai_Pr / double / Pressure Value of BAG1 at R4I
R4I_VA_CCG2_Ai_Pr / double / Pressure Value of CCG2 at R4I
P_energy_spread / double / energyspread of Positron beam
E_energy_spread / double / energyspread of Electron beam
S_P_BUNCH_SIZE_Z / double / BUNCHSIZEZ of Positron beam at begin run
S_E_BUNCH_SIZE_Z / double / BUNCHSIZE Z of Electron beam at begin run
E_P_BUNCH_SIZE_Z / double / BUNCHSIZE Z of Positron beam at end run
E_E_BUNCH_SIZE_Z / double / BUNCHSIZE Z of Electron beam at end run
AV_P_BUNCH_SIZE_Z / double / BUNCHSIZEZ of Positron beam duringthe run
AV_E_BUNCH_SIZE_Z / double / BUNCHSIZE Z of Electron beam during the run

Table_name:EMC_Crate_xx (xx:96-103,114-119)

Column_name / Data type / Comment
id / int(11) / Auto increment, primary key
run_number / int(11) / Run number
time / datetime / Time
module_no / int(11) / Module number
average_value_1 / float / Average value of channel 1
sigma_value_1 / float / Sigma value of channel 1
effective_rate_1 / int(11) / Effective rate of channel 1
average_value_2 / float / Average value of channel 2
sigma_value_2 / float / Sigma value of channel 2
effective_rate_2 / int(11) / Effective rate of channel 2
average_value_3 / float / Average value of channel 3
sigma_value_3 / float / Sigma value of channel 3
effective_rate_3 / int(11) / Effective rate of channel 3
average_value_4 / float / Average value of channel 4
sigma_value_4 / float / Sigma value of channel 4
effective_rate_4 / int(11) / Effective rate of channel 4
average_value_5 / float / Average value of channel 5
sigma_value_5 / float / Sigma value of channel 5
effective_rate_5 / int(11) / Effective rate of channel 5
average_value_6 / float / Average value of channel 6
sigma_value_6 / float / Sigma value of channel 6
effective_rate_6 / int(11) / Effective rate of channel 6
average_value_7 / float / Average value of channel 7
sigma_value_7 / float / Sigma value of channel 7
effective_rate_7 / int(11) / Effective rate of channel 7
average_value_8 / float / Average value of channel 8
sigma_value_8 / float / Sigma value of channel 8
effective_rate_8 / int(11) / Effective rate of channel 8
average_value_9 / float / Average value of channel 9
sigma_value_9 / float / Sigma value of channel 9
effective_rate_9 / int(11) / Effective rate of channel 9
average_value_10 / float / Average value of channel 10
sigma_value_10 / float / Sigma value of channel 10
effective_rate_10 / int(11) / Effective rate of channel 10
average_value_11 / float / Average value of channel 11
sigma_value_11 / float / Sigma value of channel 11
effective_rate_11 / int(11) / Effective rate of channel 11
average_value_12 / float / Average value of channel 12
sigma_value_12 / float / Sigma value of channel 12
effective_rate_12 / int(11) / Effective rate of channel 12
average_value_13 / float / Average value of channel 13
sigma_value_13 / float / Sigma value of channel 13
effective_rate_13 / int(11) / Effective rate of channel 13
average_value_14 / float / Average value of channel 14
sigma_value_14 / float / Sigma value of channel 14
effective_rate_14 / int(11) / Effective rate of channel 14
average_value_15 / float / Average value of channel 15
sigma_value_15 / float / Sigma value of channel 15
effective_rate_15 / int(11) / Effective rate of channel 15
average_value_16 / float / Average value of channel 16
sigma_value_16 / float / Sigma value of channel 16
effective_rate_16 / int(11) / Effective rate of channel 16
average_value_17 / float / Average value of channel 17
sigma_value_17 / float / Sigma value of channel 17
effective_rate_17 / int(11) / Effective rate of channel 17
average_value_18 / float / Average value of channel 18
sigma_value_18 / float / Sigma value of channel 18
effective_rate_18 / int(11) / Effective rate of channel 18
average_value_19 / float / Average value of channel 19
sigma_value_19 / float / Sigma value of channel 19
effective_rate_19 / int(11) / Effective rate of channel 19
average_value_20 / float / Average value of channel 20
sigma_value_20 / float / Sigma value of channel 20
effective_rate_20 / int(11) / Effective rate of channel 20
average_value_21 / float / Average value of channel 21
sigma_value_21 / float / Sigma value of channel 21
effective_rate_21 / int(11) / Effective rate of channel 21
average_value_22 / float / Average value of channel 22
sigma_value_22 / float / Sigma value of channel 22
effective_rate_22 / int(11) / Effective rate of channel 22
average_value_23 / float / Average value of channel 23
sigma_value_23 / float / Sigma value of channel 23
effective_rate_23 / int(11) / Effective rate of channel 23
average_value_24 / float / Average value of channel 24
sigma_value_24 / float / Sigma value of channel 24
effective_rate_24 / int(11) / Effective rate of channel 24
average_value_25 / float / Average value of channel 25
sigma_value_25 / float / Sigma value of channel 25
effective_rate_25 / int(11) / Effective rate of channel 25
average_value_26 / float / Average value of channel 26
sigma_value_26 / float / Sigma value of channel 26
effective_rate_26 / int(11) / Effective rate of channel 26
average_value_27 / float / Average value of channel 27
sigma_value_27 / float / Sigma value of channel 27
effective_rate_27 / int(11) / Effective rate of channel 27
average_value_28 / float / Average value of channel 28
sigma_value_28 / float / Sigma value of channel 28
effective_rate_28 / int(11) / Effective rate of channel 28
average_value_29 / float / Average value of channel 29
sigma_value_29 / float / Sigma value of channel 29
effective_rate_29 / int(11) / Effective rate of channel 29
average_value_30 / float / Average value of channel 30
sigma_value_30 / float / Sigma value of channel 30
effective_rate_30 / int(11) / Effective rate of channel 30
average_value_31 / float / Average value of channel 31
sigma_value_31 / float / Sigma value of channel 31
effective_rate_31 / int(11) / Effective rate of channel 31
average_value_32 / float / Average value of channel 32
sigma_value_32 / float / Sigma value of channel 32
effective_rate_32 / int(11) / Effective rate of channel 32

Table_name: MDC_Crate_xx (xx:32-39, 48-55)

Column_name / Data type / Comment
id / int(11) / Auto increment, primary key
run_number / int(11) / Run number
time / datetime / Time
module_no / int(11) / Module number
average_value_1 / float / Average value of channel 1
sigma_value_1 / float / Sigma value of channel 1
effective_rate_1 / int(11) / Effective rate of channel 1
average_value_2 / float / Average value of channel 2
sigma_value_2 / float / Sigma value of channel 2
effective_rate_2 / int(11) / Effective rate of channel 2
average_value_3 / float / Average value of channel 3
sigma_value_3 / float / Sigma value of channel 3
effective_rate_3 / int(11) / Effective rate of channel 3
average_value_4 / float / Average value of channel 4
sigma_value_4 / float / Sigma value of channel 4
effective_rate_4 / int(11) / Effective rate of channel 4
average_value_5 / float / Average value of channel 5
sigma_value_5 / float / Sigma value of channel 5
effective_rate_5 / int(11) / Effective rate of channel 5
average_value_6 / float / Average value of channel 6
sigma_value_6 / float / Sigma value of channel 6
effective_rate_6 / int(11) / Effective rate of channel 6
average_value_7 / float / Average value of channel 7
sigma_value_7 / float / Sigma value of channel 7
effective_rate_7 / int(11) / Effective rate of channel 7
average_value_8 / float / Average value of channel 8
sigma_value_8 / float / Sigma value of channel 8
effective_rate_8 / int(11) / Effective rate of channel 8
average_value_9 / float / Average value of channel 9
sigma_value_9 / float / Sigma value of channel 9
effective_rate_9 / int(11) / Effective rate of channel 9
average_value_10 / float / Average value of channel 10
sigma_value_10 / float / Sigma value of channel 10
effective_rate_10 / int(11) / Effective rate of channel 10
average_value_11 / float / Average value of channel 11
sigma_value_11 / float / Sigma value of channel 11
effective_rate_11 / int(11) / Effective rate of channel 11
average_value_12 / float / Average value of channel 12
sigma_value_12 / float / Sigma value of channel 12
effective_rate_12 / int(11) / Effective rate of channel 12
average_value_13 / float / Average value of channel 13
sigma_value_13 / float / Sigma value of channel 13
effective_rate_13 / int(11) / Effective rate of channel 13
average_value_14 / float / Average value of channel 14
sigma_value_14 / float / Sigma value of channel 14
effective_rate_14 / int(11) / Effective rate of channel 14
average_value_15 / float / Average value of channel 15
sigma_value_15 / float / Sigma value of channel 15
effective_rate_15 / int(11) / Effective rate of channel 15
average_value_16 / float / Average value of channel 16
sigma_value_16 / float / Sigma value of channel 16
effective_rate_16 / int(11) / Effective rate of channel 16
average_value_17 / float / Average value of channel 17
sigma_value_17 / float / Sigma value of channel 17
effective_rate_17 / int(11) / Effective rate of channel 17
average_value_18 / float / Average value of channel 18
sigma_value_18 / float / Sigma value of channel 18
effective_rate_18 / int(11) / Effective rate of channel 18
average_value_19 / float / Average value of channel 19
sigma_value_19 / float / Sigma value of channel 19
effective_rate_19 / int(11) / Effective rate of channel 19
average_value_20 / float / Average value of channel 20
sigma_value_20 / float / Sigma value of channel 20
effective_rate_20 / int(11) / Effective rate of channel 20
average_value_21 / float / Average value of channel 21
sigma_value_21 / float / Sigma value of channel 21
effective_rate_21 / int(11) / Effective rate of channel 21
average_value_22 / float / Average value of channel 22
sigma_value_22 / float / Sigma value of channel 22
effective_rate_22 / int(11) / Effective rate of channel 22
average_value_23 / float / Average value of channel 23
sigma_value_23 / float / Sigma value of channel 23
effective_rate_23 / int(11) / Effective rate of channel 23
average_value_24 / float / Average value of channel 24
sigma_value_24 / float / Sigma value of channel 24
effective_rate_24 / int(11) / Effective rate of channel 24
average_value_25 / float / Average value of channel 25
sigma_value_25 / float / Sigma value of channel 25
effective_rate_25 / int(11) / Effective rate of channel 25
average_value_26 / float / Average value of channel 26
sigma_value_26 / float / Sigma value of channel 26
effective_rate_26 / int(11) / Effective rate of channel 26
average_value_27 / float / Average value of channel 27
sigma_value_27 / float / Sigma value of channel 27
effective_rate_27 / int(11) / Effective rate of channel 27
average_value_28 / float / Average value of channel 28
sigma_value_28 / float / Sigma value of channel 28
effective_rate_28 / int(11) / Effective rate of channel 28
average_value_29 / float / Average value of channel 29
sigma_value_29 / float / Sigma value of channel 29
effective_rate_29 / int(11) / Effective rate of channel 29
average_value_30 / float / Average value of channel 30
sigma_value_30 / float / Sigma value of channel 30
effective_rate_30 / int(11) / Effective rate of channel 30
average_value_31 / float / Average value of channel 31
sigma_value_31 / float / Sigma value of channel 31
effective_rate_31 / int(11) / Effective rate of channel 31
average_value_32 / float / Average value of channel 32
sigma_value_32 / float / Sigma value of channel 32
effective_rate_32 / int(11) / Effective rate of channel 32

Table_name: MQT

Column_name / Data type / Comment
Obj_id / int(11) / Auto increment, primary key
FileId / int(11) / Datafile id, ->Data.DataFileId
OID / varchar(255) / Object id
Name / text / Object name
Type / text / Module type.
Location / text / Physical location of module.
Description / text / description
HelpLink / text / URL containing description.
InstallationRef / text / Reference to object from installation DB.
State / varchar(10) / If the state is true, the hw device is On.
PhysAddress / int(10) / Physical address of module
CommAddress / int(10) / Communication address
Position / smallint(5) / Position of module
Width / smallint(5) / width
LogicalId / int(10) / Logical id
TriggerLatencyRegister / int(10) / Trigger latency register
SampleWindowRegister / int(10) / Sample window register
Channel1 / int(10) / The channel information of channel 1
Channel2 / int(10) / The channel information of channel 2
Channel3 / int(10) / The channel information of channel 3
Channel4 / int(10) / The channel information of channel 4
Channel5 / int(10) / The channel information of channel 5
Channel6 / int(10) / The channel information of channel 6
Channel7 / int(10) / The channel information of channel 7
Channel8 / int(10) / The channel information of channel 8
Channel9 / int(10) / The channel information of channel 9
Channel10 / int(10) / The channel information of channel 10
Channel11 / int(10) / The channel information of channel 11
Channel12 / int(10) / The channel information of channel 12
Channel13 / int(10) / The channel information of channel 13
Channel14 / int(10) / The channel information of channel 14
Channel15 / int(10) / The channel information of channel 15
Channel16 / int(10) / The channel information of channel 16
Channel17 / int(10) / The channel information of channel 17
Channel18 / int(10) / The channel information of channel 18
Channel19 / int(10) / The channel information of channel 19
Channel20 / int(10) / The channel information of channel 20
Channel21 / int(10) / The channel information of channel 21
Channel22 / int(10) / The channel information of channel 22
Channel23 / int(10) / The channel information of channel 23
Channel24 / int(10) / The channel information of channel 24
Channel25 / int(10) / The channel information of channel 25
Channel26 / int(10) / The channel information of channel 26
Channel27 / int(10) / The channel information of channel 27
Channel28 / int(10) / The channel information of channel 28
Channel29 / int(10) / The channel information of channel 29
Channel30 / int(10) / The channel information of channel 30
Channel31 / int(10) / The channel information of channel 31
Channel32 / int(10) / The channel information of channel 32
Enable / varchar(10) / Enable the module
DAC / int(10) / Control status register
TimeHighThreshold / int(10) / High threshold of Time
TimeLowThreshold / int(10) / Low threshold of Time
TimeTriggerLatencyRegister / int(10) / Time trigger lantency register
TimeSampleWindowRegister / int(10) / Time sample window register
TimeChannelEnable / int(10) / Whether enable the time channel
ControlRegister / int(10) / Control register
QTHitOption / int(10) / Q,T hit option
CPUs / text / ->Computer
BelongsTo / text / ->Crate
BelongsToMDC / text / ->MDCSubsystem

Table_name: TFEE

Column_name / Data type / Comment
Obj_id / int(11) / Auto increment, primary key
FileId / int(11) / Datafile id, ->Data.DataFileId
OID / varchar(255) / Object id
PhysAddress / smallint(5) / Physical address
Enable / varchar(10) / Enable the module
BarrelEnd / int(10) / The relation position is Barrel or end
ChannelEnable / int(10) / Channel enable
TriggerEnable / int(10) / Trigger enable
RejectLaten / int(10) / Reject latency
TriggerLatency / int(10) / Trigger latency
TriggerSearchWinT / int(10) / Trigger search window of T
TriggerMatchWinT / int(10) / Trigger match window of T
TriggerSearchWinQT / int(10) / Trigger search window of QT
TriggerMatchWinQT / int(10) / Trigger match window of QT
HitCountPerEventT / int(10) / Hit count per event T
HitCountPerEventQT / int(10) / Hit count per event QT
HighThreshold / int(10) / High threshold
LowThreshold / int(10) / Low threshold
HighThresholdQT / int(10) / QT high threshold
LowThresholdQT / int(10) / QT low threshold
ConstVoltage / int(10) / Const voltage
SelfTestSignalAmp / int(10) / Self test signal amplitude
SerialNum / int(10) / Serial number
Channel1 / int(10) / The channel information of channel 1
Channel2 / int(10) / The channel information of channel 2
Channel3 / int(10) / The channel information of channel 3
Channel4 / int(10) / The channel information of channel 4
Channel5 / int(10) / The channel information of channel 5
Channel6 / int(10) / The channel information of channel 6
Channel7 / int(10) / The channel information of channel 7
Channel8 / int(10) / The channel information of channel 8
Channel9 / int(10) / The channel information of channel 9
Channel10 / int(10) / The channel information of channel 10
Channel11 / int(10) / The channel information of channel 11
Channel12 / int(10) / The channel information of channel 12
Channel13 / int(10) / The channel information of channel 13
Channel14 / int(10) / The channel information of channel 14
Channel15 / int(10) / The channel information of channel 15
Channel16 / int(10) / The channel information of channel 16
BelongsTo / text / ->Crate
BelongsToTOF / text / ->TOFSubsystem

BESIII离线刻度常数数据字典v62