| Field | Type | Null | Default |
|---|---|---|---|
| collisionTypeID | smallint(6) | No | |
| firstParticle | varchar(10) | No | |
| secondParticle | varchar(10) | No | |
| collisionEnergy | float | No | 0 |
| Field | Type | Null | Default |
|---|---|---|---|
| detectorConfigurationID | int(11) | No | |
| detectorConfigurationName | varchar(50) | Yes | NULL |
| dTPC | tinyint(4) | Yes | NULL |
| dSVT | tinyint(4) | Yes | NULL |
| dTOF | tinyint(4) | Yes | NULL |
| dEMC | tinyint(4) | Yes | NULL |
| dEEMC | tinyint(4) | Yes | NULL |
| dFPD | tinyint(4) | Yes | NULL |
| dFTPC | tinyint(4) | Yes | NULL |
| dPMD | tinyint(4) | Yes | NULL |
| dRICH | tinyint(4) | Yes | NULL |
| dSSD | tinyint(4) | Yes | NULL |
| dBBC | tinyint(4) | Yes | NULL |
| dBSMD | tinyint(4) | Yes | NULL |
| dESMD | tinyint(4) | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| eventGeneratorID | smallint(6) | No | |
| eventGeneratorName | varchar(30) | No | |
| eventGeneratorVersion | varchar(10) | Yes | 0 |
| eventGeneratorParams | varchar(200) | Yes | NULL |
| eventGeneratorIDate | timestamp(14) | Yes | NULL |
| eventGeneratorCreator | varchar(15) | No | unknown |
| eventGeneratorCount | int(11) | Yes | NULL |
| eventGeneratorComment | text | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| fileDataID | bigint(20) | No | |
| runParamID | int(11) | No | 0 |
| fileName | varchar(255) | No | |
| productionConditionID | int(11) | Yes | NULL |
| numEntries | mediumint(9) | Yes | 0 |
| md5sum | varchar(32) | Yes | 0 |
| fileTypeID | smallint(6) | No | 0 |
| fileSeq | smallint(6) | Yes | NULL |
| fileStream | smallint(6) | Yes | 0 |
| fileDataComments | text | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| fileLocationID | bigint(20) | No | |
| fileDataID | bigint(20) | No | 0 |
| filePathID | bigint(20) | No | 0 |
| storageTypeID | mediumint(9) | No | 0 |
| createTime | timestamp(14) | Yes | NULL |
| insertTime | timestamp(14) | Yes | NULL |
| owner | varchar(30) | Yes | NULL |
| fsize | bigint(20) | Yes | NULL |
| storageSiteID | smallint(6) | No | 0 |
| protection | varchar(15) | Yes | NULL |
| hostID | bigint(20) | No | 1 |
| availability | tinyint(4) | No | 1 |
| persistent | tinyint(4) | No | 0 |
| sanity | tinyint(4) | No | 1 |
| Field | Type | Null | Default |
|---|---|---|---|
| parentFileID | bigint(20) | No | 0 |
| childFileID | bigint(20) | No | 0 |
| Field | Type | Null | Default |
|---|---|---|---|
| filePathID | bigint(6) | No | |
| filePathName | varchar(255) | No | |
| filePathIDate | timestamp(14) | Yes | NULL |
| filePathCreator | varchar(15) | No | unknown |
| filePathCount | int(11) | Yes | NULL |
| filePathComment | text | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| fileTypeID | smallint(6) | No | |
| fileTypeName | varchar(30) | No | |
| fileTypeExtension | varchar(15) | No | |
| fileTypeIDate | timestamp(14) | Yes | NULL |
| fileTypeCreator | varchar(15) | No | unknown |
| fileTypeCount | int(11) | Yes | NULL |
| fileTypeComment | text | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| hostID | smallint(6) | No | |
| hostName | varchar(30) | No | localhost |
| hostIDate | timestamp(14) | Yes | NULL |
| hostCreator | varchar(15) | No | unknown |
| hostCount | int(11) | Yes | NULL |
| hostComment | text | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| productionConditionID | smallint(6) | No | |
| productionTag | varchar(10) | No | |
| libraryVersion | varchar(10) | No | |
| productionConditionIDate | timestamp(14) | Yes | NULL |
| productionConditionCreator | varchar(15) | No | unknown |
| productionConditionCount | int(11) | Yes | NULL |
| productionConditionComment | text | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| runParamID | int(11) | No | |
| runNumber | bigint(20) | No | 0 |
| dataTakingStart | timestamp(14) | Yes | NULL |
| dataTakingEnd | timestamp(14) | Yes | NULL |
| simulationParamsID | int(11) | Yes | NULL |
| runTypeID | smallint(6) | No | 0 |
| triggerSetupID | smallint(6) | No | 0 |
| detectorConfigurationID | int(11) | No | 0 |
| collisionTypeID | smallint(6) | No | 0 |
| magFieldScale | varchar(50) | No | |
| magFieldValue | float | Yes | NULL |
| runComments | text | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| runTypeID | smallint(6) | No | |
| runTypeName | varchar(255) | No | |
| runTypeIDate | timestamp(14) | Yes | NULL |
| runTypeCreator | varchar(15) | No | unknown |
| runTypeCount | int(11) | Yes | NULL |
| runTypeComment | text | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| simulationParamsID | int(11) | No | |
| eventGeneratorID | smallint(6) | No | 0 |
| detectorConfigurationID | int(11) | No | 0 |
| simulationParamComments | text | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| storageSiteID | smallint(6) | No | |
| storageSiteName | varchar(30) | No | |
| storageSiteLocation | varchar(50) | Yes | NULL |
| storageSiteIDate | timestamp(14) | Yes | NULL |
| storageSiteCreator | varchar(15) | No | unknown |
| storageSiteCount | int(11) | Yes | NULL |
| storageSiteComment | text | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| storageTypeID | mediumint(9) | No | |
| storageTypeName | varchar(6) | No | |
| storageTypeIDate | timestamp(14) | Yes | NULL |
| storageTypeCreator | varchar(15) | No | unknown |
| storageTypeCount | int(11) | Yes | NULL |
| storageTypeComment | text | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| fileDataID | bigint(20) | No | 0 |
| triggerWordID | int(11) | No | 0 |
| triggerCount | mediumint(9) | Yes | 0 |
| Field | Type | Null | Default |
|---|---|---|---|
| triggerSetupID | smallint(6) | No | |
| triggerSetupName | varchar(50) | No | |
| triggerSetupComposition | varchar(255) | No | |
| triggerSetupIDate | timestamp(14) | Yes | NULL |
| triggerSetupCreator | varchar(15) | No | unknown |
| triggerSetupCount | int(11) | Yes | NULL |
| triggerSetupComment | text | Yes | NULL |
| Field | Type | Null | Default |
|---|---|---|---|
| triggerWordID | mediumint(9) | No | |
| triggerWordName | varchar(50) | No | |
| triggerWordVersion | varchar(6) | No | V0.0 |
| triggerWordBits | varchar(6) | No | |
| triggerWordIDate | timestamp(14) | Yes | NULL |
| triggerWordCreator | varchar(15) | No | unknown |
| triggerWordCount | int(11) | Yes | NULL |
| triggerWordComment | text | Yes | NULL |