Difference between revisions of "APEL/DatabaseTables"
< APEL
Jump to navigation
Jump to search
Line 115: | Line 115: | ||
| Year || int || No || MUL || || | | Year || int || No || MUL || || | ||
|} | |} | ||
== HepSpecHistory Table == | |||
{| cellspacing="1" cellpadding="1" border="1" width="500" | |||
! scope="col" | ColumnName | |||
! scope="col" | Type | |||
! scope="col" | Null | |||
! scope="col" | Key | |||
! scope="col" | Default | |||
|- | |||
| UpdateTime || TimeStamp || Auto || MUL || 'None' || | |||
|- | |||
| Site || varchar(255) || No || PRI || 'None' || | |||
|- | |||
| HepSpec06 || int || No || PRI || 'None' || | |||
|- | |||
| NumberOfJobs || int || No || || 'None' || | |||
|- | |||
| Month || int || No || PRI || 'None' || | |||
|- | |||
| Year || int || No || PRI || 'None' || | |||
|- | |||
| EarliestEndDate || date || No || || 'None' || | |||
|- | |||
| LatestEndDate || date || No || || 'None' || | |||
|- | |||
[[Category:Accounting]] | [[Category:Accounting]] |
Revision as of 16:03, 1 May 2012
- Back to APEL/Server
- See also APEL/MessageFormat - this will have more explanation of what the fields mean.
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 | ||
LocalJobId | varchar(255) | No | MUL | |||
LocalUserId | varchar(255) | |||||
GlobalUserName | varchar(255) | No | 'None' | Yes | Yes | |
GridGroup | 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 | |||||
NodeCount | int | |||||
StartTime | datetime | No | ||||
EndTime | datetime | MUL | ||||
MemoryReal | int | |||||
MemoryVirtual | int | |||||
ServiceLevelType | varchar(50) | No | ||||
ServiceLevel | double | 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 |
GridGroup | varchar(255) | No | MUL | 'None' | Yes |
VOGroup | varchar(255) | No | MUL | 'None' | Yes |
VORole | varchar(255) | No | MUL | 'None' | Yes |
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 | |
NumberOfJobs | int | No | |||
Month | int | No | MUL | ||
Year | int | No | MUL |
HepSpecHistory Table
ColumnName | Type | Null | Key | Default | |
---|---|---|---|---|---|
UpdateTime | TimeStamp | Auto | MUL | 'None' | |
Site | varchar(255) | No | PRI | 'None' | |
HepSpec06 | int | No | PRI | 'None' | |
NumberOfJobs | int | No | 'None' | ||
Month | int | No | PRI | 'None' | |
Year | int | No | PRI | 'None' | |
EarliestEndDate | date | No | 'None' | ||
LatestEndDate | date | No | 'None' |