EventStore Table Definitions
From GlueXWiki
Revision as of 17:52, 3 February 2015 by Sdobbs (Talk | contribs) (Created page with "__TOC__ ==Tables== Here we describe the tables defined by EventStore. Note that the bold names are primary keys in those tables and italic names represents the group index (fo...")
Contents
Tables
Here we describe the tables defined by EventStore. Note that the bold names are primary keys in those tables and italic names represents the group index (for faster lookup).
FileID
| fileId | fileName | typeID |
One entry per data and key file.
- fileId is a unique identifier associated with every stored file
- typeID is an index into the FileType table
KeyFile
| graphId | view | run | uid | keyFileId |
One entry per key file. Associates key files with particular skims.
- graphId is an index into the GraphPath table (which defines the graphs)
- view is a the name of a skim (e.g. "2track")
- keyFileId is an index into the FileID table
RunUID
| run | uid |
A list of the run/uid pairs stored in the DB.
FileType
| id | type | description |
- type is the internal description of the type of data (e.g. "evio", "rest", "mc", etc.)
- description is a long description of the data type
OrphanFile
| id | dateTime | user |
When files are deleted dateTime and user register who deleted the files and when.
MaxMasterID
| masterMaxId | comment |
MySQL only. Used for merging? Still investigating...
Grades
Injection
A more detailed discussion of what happens during injection can be found here
