These are here for reference. Note that MUL beside multiple columns refers to a composite key.
JobRecords Table
ColumnName
|
Type
|
Null
|
Key
|
Default
|
Normalised
|
Indexed
|
UpdateTime |
TimeStamp |
Auto |
|
|
|
|
Site |
varchar(255) |
No |
|
|
Yes |
Yes
|
SubmitHost |
varchar(255) |
No |
MUL |
|
Yes |
|
MachineName |
varchar(255) |
No |
|
|
Yes |
|
Queue |
varchar(255) |
No |
|
|
Yes |
|
LocalJobId |
varchar(255) |
No |
MUL |
|
|
|
LocalUserId |
varchar(255) |
|
|
|
|
|
GlobalUserName |
varchar(255) |
No |
|
'None' |
Yes |
Yes
|
FQAN |
varchar(255) |
|
|
|
|
|
VO |
varchar(255) |
No |
|
'None' |
Yes |
Yes
|
VOGroup |
varchar(255) |
No |
|
'None' |
Yes |
Yes
|
VORole |
varchar(255) |
No |
|
'None' |
Yes |
Yes
|
WallDuration |
int |
|
|
|
|
|
CpuDuration |
int |
|
|
|
|
|
Processors |
int |
No |
|
0 |
|
|
NodeCount |
int |
No |
|
0 |
|
|
StartTime |
datetime |
No |
|
|
|
|
EndTime |
datetime |
No |
MUL |
|
|
|
InfrastructureDescription |
varchar(255) |
|
|
|
|
|
InfrastructureType |
varchar(20) |
|
|
|
|
|
MemoryReal |
bigint |
|
|
|
|
|
MemoryVirtual |
bigint |
|
|
|
|
|
ServiceLevelType |
varchar(50) |
No |
|
|
|
|
ServiceLevel |
decimal |
No |
|
|
|
|
Summaries Table
ColumnName
|
Type
|
Null
|
Key
|
Default
|
Normalised
|
UpdateTime |
TimeStamp |
Auto |
|
|
|
Site |
varchar(255) |
No |
MUL |
|
Yes
|
Month |
int |
No |
MUL |
|
|
Year |
int |
No |
MUL |
|
|
GlobalUserName |
varchar(255) |
No |
MUL |
'None' |
Yes
|
VO |
varchar(255) |
No |
MUL |
'None' |
Yes
|
VOGroup |
varchar(255) |
No |
MUL |
'None' |
Yes
|
VORole |
varchar(255) |
No |
MUL |
'None' |
Yes
|
SubmitHost |
varchar(255) |
Yes |
|
|
|
InfrastructureType |
varchar(255) |
Yes |
|
|
|
ServiceLevelType |
varchar(50) |
No |
MUL |
'None' |
Yes
|
ServiceLevel |
double |
No |
MUL |
'None' |
Yes
|
NodeCount |
int |
No |
|
0 |
|
Processors |
int |
No |
|
0 |
|
EarliestEndTime |
datetime |
|
|
|
|
LatestEndTime |
datetime |
|
|
|
|
WallDuration |
int |
No |
|
|
|
CpuDuration |
int |
No |
|
|
|
NormalisedWallDuration |
int |
No |
|
|
|
NormalisedCpuDuration |
int |
No |
|
|
|
NumberOfJobs |
int |
No |
|
|
|
Sync Table
ColumnName
|
Type
|
Null
|
Key
|
Default
|
Normalised
|
Site |
varchar(255) |
No |
MUL |
|
Yes
|
SubmitHost |
varchar(255) |
|
|
|
|
NumberOfJobs |
int |
No |
|
|
|
Month |
int |
No |
MUL |
|
|
Year |
int |
No |
MUL |
|
|
HepSpecHistory Table
ColumnName
|
Type
|
Null
|
Key
|
Default
|
UpdateTime |
TimeStamp |
Auto |
|
|
|
Site |
varchar(255) |
No |
PRI |
|
|
HepSpec06 |
int |
No |
PRI |
|
|
NumberOfJobs |
int |
No |
|
'None' |
|
Month |
int |
No |
PRI |
|
|
Year |
int |
No |
PRI |
|
|
EarliestEndDate |
date |
No |
|
'None' |
|
LatestEndDate |
date |
No |
|
'None' |
|