- General information
- Data readiness
- Grid and Cloud
- Infrastructure
- Online Computing
- Software Infrastructure
- Batch system, resource management system
- CVS->Git
- Computing Environment
- Facility Access
- FileCatalog
- HPSS services
- Home directories and other areas backups
- Hypernews
- Installing the STAR software stack
- Provision CVMFS and mount BNL/STAR repo
- RCF Contributions
- Security
- Software and Libraries
- Storage
- Tools
- Tutorials
- Video Conferencing
- Web Access
- Machine Learning
- Offline Software
- Production
- S&C internal group meetings
- Test tree
Data dictionary
Updated on Mon, 2012-03-12 14:28 by testadmin. Originally created by jeromel on 2012-03-12 14:27.
Under:
This dictionary was created on 2012/03/12.
CollisionTypes
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| collisionTypeID | smallint(6) | No | ||
| firstParticle | varchar(10) | No | ||
| secondParticle | varchar(10) | No | ||
| collisionEnergy | float | No | 0 | |
| collisionTypeIDate | timestamp | No | CURRENT_TIMESTAMP | |
| collisionTypeCreator | smallint(6) | No | 1 | |
| collisionTypeCount | int(11) | Yes | NULL | |
| collisionTypeComment | text | Yes | NULL |
Creators
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| creatorID | bigint(20) | No | ||
| creatorName | varchar(15) | Yes | unknown | |
| creatorIDate | timestamp | No | CURRENT_TIMESTAMP | |
| creatorCount | int(11) | Yes | NULL | |
| creatorComment | varchar(512) | Yes | NULL |
DetectorConfigurations
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| 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 | |
| dZDC | tinyint(4) | Yes | NULL | |
| dCTB | tinyint(4) | Yes | NULL | |
| dTPX | tinyint(4) | Yes | NULL | |
| dFGT | tinyint(4) | Yes | NULL |
DetectorStates
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| detectorStateID | int(11) | No | ||
| sTPC | tinyint(4) | Yes | NULL | |
| sSVT | tinyint(4) | Yes | NULL | |
| sTOF | tinyint(4) | Yes | NULL | |
| sEMC | tinyint(4) | Yes | NULL | |
| sEEMC | tinyint(4) | Yes | NULL | |
| sFPD | tinyint(4) | Yes | NULL | |
| sFTPC | tinyint(4) | Yes | NULL | |
| sPMD | tinyint(4) | Yes | NULL | |
| sRICH | tinyint(4) | Yes | NULL | |
| sSSD | tinyint(4) | Yes | NULL | |
| sBBC | tinyint(4) | Yes | NULL | |
| sBSMD | tinyint(4) | Yes | NULL | |
| sESMD | tinyint(4) | Yes | NULL | |
| sZDC | tinyint(4) | Yes | NULL | |
| sCTB | tinyint(4) | Yes | NULL | |
| sTPX | tinyint(4) | Yes | NULL | |
| sFGT | tinyint(4) | Yes | NULL |
EventGenerators
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| eventGeneratorID | smallint(6) | No | ||
| eventGeneratorName | varchar(30) | No | ||
| eventGeneratorVersion | varchar(10) | Yes | 0 | |
| eventGeneratorParams | varchar(200) | Yes | NULL | |
| eventGeneratorIDate | timestamp | No | CURRENT_TIMESTAMP | |
| eventGeneratorCreator | smallint(6) | No | 1 | |
| eventGeneratorCount | int(11) | Yes | NULL | |
| eventGeneratorComment | varchar(512) | Yes | NULL |
FileData
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| fileDataID | bigint(20) | No | ||
| runParamID | int(11) | No | 0 | |
| fileName | varchar(255) | No | ||
| baseName | varchar(255) | No | Name without extension | |
| sName1 | varchar(255) | No | Will be used for name+runNumber | |
| sName2 | varchar(255) | No | Will be used for name before runNumber | |
| productionConditionID | mediumint(9) | 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 | |
| fileDataIDate | timestamp | No | CURRENT_TIMESTAMP | |
| fileDataCreator | smallint(6) | No | 1 | |
| fileDataCount | int(11) | Yes | NULL | |
| fileDataComment | text | Yes | NULL |
FileLocations
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| fileLocationID | bigint(20) | No | ||
| fileDataID | bigint(20) | No | 0 | |
| filePathID | bigint(20) | No | 0 | |
| storageTypeID | mediumint(9) | No | 0 | |
| createTime | timestamp | No | CURRENT_TIMESTAMP | |
| insertTime | timestamp | No | 0000-00-00 00:00:00 | |
| owner | varchar(15) | Yes | NULL | |
| fsize | bigint(20) | Yes | NULL | |
| storageSiteID | smallint(6) | No | 0 | |
| protection | varchar(15) | Yes | NULL | |
| hostID | mediumint(9) | No | 1 | |
| availability | tinyint(4) | No | 1 | |
| persistent | tinyint(4) | No | 0 | |
| sanity | tinyint(4) | No | 1 |
FileLocationsID
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| fileLocationID | bigint(20) | No |
FileLocations_0
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| fileLocationID | bigint(20) | No | ||
| fileDataID | bigint(20) | No | 0 | |
| filePathID | bigint(20) | No | 0 | |
| storageTypeID | mediumint(9) | No | 0 | |
| createTime | timestamp | No | CURRENT_TIMESTAMP | |
| insertTime | timestamp | No | 0000-00-00 00:00:00 | |
| owner | varchar(15) | Yes | NULL | |
| fsize | bigint(20) | Yes | NULL | |
| storageSiteID | smallint(6) | No | 0 | |
| protection | varchar(15) | Yes | NULL | |
| hostID | mediumint(9) | No | 1 | |
| availability | tinyint(4) | No | 1 | |
| persistent | tinyint(4) | No | 0 | |
| sanity | tinyint(4) | No | 1 |
FileLocations_1
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| fileLocationID | bigint(20) | No | ||
| fileDataID | bigint(20) | No | 0 | |
| filePathID | bigint(20) | No | 0 | |
| storageTypeID | mediumint(9) | No | 0 | |
| createTime | timestamp | No | CURRENT_TIMESTAMP | |
| insertTime | timestamp | No | 0000-00-00 00:00:00 | |
| owner | varchar(15) | Yes | NULL | |
| fsize | bigint(20) | Yes | NULL | |
| storageSiteID | smallint(6) | No | 0 | |
| protection | varchar(15) | Yes | NULL | |
| hostID | mediumint(9) | No | 1 | |
| availability | tinyint(4) | No | 1 | |
| persistent | tinyint(4) | No | 0 | |
| sanity | tinyint(4) | No | 1 |
FileLocations_2
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| fileLocationID | bigint(20) | No | ||
| fileDataID | bigint(20) | No | 0 | |
| filePathID | bigint(20) | No | 0 | |
| storageTypeID | mediumint(9) | No | 0 | |
| createTime | timestamp | No | CURRENT_TIMESTAMP | |
| insertTime | timestamp | No | 0000-00-00 00:00:00 | |
| owner | varchar(15) | Yes | NULL | |
| fsize | bigint(20) | Yes | NULL | |
| storageSiteID | smallint(6) | No | 0 | |
| protection | varchar(15) | Yes | NULL | |
| hostID | mediumint(9) | No | 1 | |
| availability | tinyint(4) | No | 1 | |
| persistent | tinyint(4) | No | 0 | |
| sanity | tinyint(4) | No | 1 |
FileLocations_3
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| fileLocationID | bigint(20) | No | ||
| fileDataID | bigint(20) | No | 0 | |
| filePathID | bigint(20) | No | 0 | |
| storageTypeID | mediumint(9) | No | 0 | |
| createTime | timestamp | No | CURRENT_TIMESTAMP | |
| insertTime | timestamp | No | 0000-00-00 00:00:00 | |
| owner | varchar(15) | Yes | NULL | |
| fsize | bigint(20) | Yes | NULL | |
| storageSiteID | smallint(6) | No | 0 | |
| protection | varchar(15) | Yes | NULL | |
| hostID | mediumint(9) | No | 1 | |
| availability | tinyint(4) | No | 1 | |
| persistent | tinyint(4) | No | 0 | |
| sanity | tinyint(4) | No | 1 |
FileParents
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| parentFileID | bigint(20) | No | 0 | |
| childFileID | bigint(20) | No | 0 |
FilePaths
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| filePathID | bigint(6) | No | ||
| filePathName | varchar(255) | No | ||
| filePathIDate | timestamp | No | CURRENT_TIMESTAMP | |
| filePathCreator | smallint(6) | No | 1 | |
| filePathCount | int(11) | Yes | NULL | |
| filePathComment | varchar(512) | Yes | NULL |
FileTypes
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| fileTypeID | smallint(6) | No | ||
| fileTypeName | varchar(30) | No | ||
| fileTypeExtension | varchar(15) | No | ||
| fileTypeIDate | timestamp | No | CURRENT_TIMESTAMP | |
| fileTypeCreator | smallint(6) | No | 1 | |
| fileTypeCount | int(11) | Yes | NULL | |
| fileTypeComment | varchar(512) | Yes | NULL |
Hosts
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| hostID | smallint(6) | No | ||
| hostName | varchar(30) | No | localhost | |
| hostIDate | timestamp | No | CURRENT_TIMESTAMP | |
| hostCreator | smallint(6) | No | 1 | |
| hostCount | int(11) | Yes | NULL | |
| hostComment | varchar(512) | Yes | NULL |
ProductionConditions
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| productionConditionID | smallint(6) | No | ||
| productionTag | varchar(10) | No | ||
| libraryVersion | varchar(10) | No | ||
| productionConditionIDate | timestamp | No | CURRENT_TIMESTAMP | |
| productionConditionCreator | smallint(6) | No | 1 | |
| productionConditionCount | int(11) | Yes | NULL | |
| productionConditionComment | varchar(512) | Yes | NULL |
RunParams
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| runParamID | int(11) | No | ||
| runNumber | bigint(20) | No | 0 | |
| dataTakingStart | timestamp | No | 0000-00-00 00:00:00 | |
| dataTakingEnd | timestamp | No | 0000-00-00 00:00:00 | |
| dataTakingDay | smallint(6) | Yes | 0 | |
| dataTakingYear | smallint(6) | Yes | 0 | |
| simulationParamsID | int(11) | Yes | NULL | |
| runTypeID | smallint(6) | No | 0 | |
| triggerSetupID | smallint(6) | No | 0 | |
| detectorConfigurationID | mediumint(9) | No | 0 | |
| detectorStateID | mediumint(9) | No | 0 | |
| collisionTypeID | smallint(6) | No | 0 | |
| magFieldScale | varchar(50) | No | ||
| magFieldValue | float | Yes | NULL | |
| runParamIDate | timestamp | No | CURRENT_TIMESTAMP | |
| runParamCreator | smallint(6) | No | 1 | |
| runParamCount | int(11) | Yes | NULL | |
| runParamComment | varchar(512) | Yes | NULL |
RunTypes
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| runTypeID | smallint(6) | No | ||
| runTypeName | varchar(255) | No | ||
| runTypeIDate | timestamp | No | CURRENT_TIMESTAMP | |
| runTypeCreator | smallint(6) | No | 1 | |
| runTypeCount | int(11) | Yes | NULL | |
| runTypeComment | varchar(512) | Yes | NULL |
SimulationParams
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| simulationParamsID | int(11) | No | ||
| eventGeneratorID | smallint(6) | No | 0 | |
| simulationParamIDate | timestamp | No | CURRENT_TIMESTAMP | |
| simulationParamCreator | smallint(6) | No | 1 | |
| simulationParamCount | int(11) | Yes | NULL | |
| simulationParamComment | varchar(512) | Yes | NULL |
StorageSites
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| storageSiteID | smallint(6) | No | ||
| storageSiteName | varchar(30) | No | ||
| storageSiteLocation | varchar(50) | Yes | NULL | |
| storageSiteIDate | timestamp | No | CURRENT_TIMESTAMP | |
| storageSiteCreator | smallint(6) | No | 1 | |
| storageSiteCount | int(11) | Yes | NULL | |
| storageSiteComment | varchar(512) | Yes | NULL |
StorageTypes
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| storageTypeID | mediumint(9) | No | ||
| storageTypeName | varchar(6) | No | ||
| storageTypeIDate | timestamp | No | CURRENT_TIMESTAMP | |
| storageTypeCreator | smallint(6) | No | 1 | |
| storageTypeCount | int(11) | Yes | NULL | |
| storageTypeComment | varchar(512) | Yes | NULL |
TriggerCompositions
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| fileDataID | bigint(20) | No | 0 | |
| triggerWordID | mediumint(9) | No | 0 | |
| triggerCount | mediumint(9) | Yes | 0 |
TriggerSetups
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| triggerSetupID | smallint(6) | No | ||
| triggerSetupName | varchar(50) | No | ||
| triggerSetupComposition | varchar(255) | No | ||
| triggerSetupIDate | timestamp | No | CURRENT_TIMESTAMP | |
| triggerSetupCreator | smallint(6) | No | 1 | |
| triggerSetupCount | int(11) | Yes | NULL | |
| triggerSetupComment | varchar(512) | Yes | NULL |
TriggerWords
| Field | Type | Null | Default | Comments |
|---|---|---|---|---|
| triggerWordID | mediumint(9) | No | ||
| triggerWordName | varchar(50) | No | ||
| triggerWordVersion | varchar(6) | No | V0.0 | |
| triggerWordBits | varchar(6) | No | ||
| triggerWordIDate | timestamp | No | CURRENT_TIMESTAMP | |
| triggerWordCreator | smallint(6) | No | 1 | |
| triggerWordCount | int(11) | Yes | NULL | |
| triggerWordComment | varchar(512) | Yes | NULL |
»
- Printer-friendly version
- Login or register to post comments