Difference between revisions of "APEL/DatabaseTables"
< APEL
Jump to navigation
Jump to search
Line 48: | Line 48: | ||
| StartTime || datetime || No || || || || | | StartTime || datetime || No || || || || | ||
|- | |- | ||
| EndTime || datetime || | | EndTime || datetime || No || MUL || || || | ||
|- | |- | ||
| InfrastructureDescription || varchar(255) || || || || || | | InfrastructureDescription || varchar(255) || || || || || | ||
|- | |- | ||
| InfrastructureType || varchar( | | InfrastructureType || varchar(20) || || || || || | ||
|- | |- | ||
| MemoryReal || | | MemoryReal || bigint || || || || || | ||
|- | |- | ||
| MemoryVirtual || | | MemoryVirtual || bigint || || || || || | ||
|- | |- | ||
| ServiceLevelType || varchar(50) || No || || || || | | ServiceLevelType || varchar(50) || No || || || || | ||
|- | |- | ||
| ServiceLevel || | | ServiceLevel || decimal || No || || || || | ||
|- | |- | ||
|} | |} |
Revision as of 14:14, 20 February 2013
- 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 | ||
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' |