The wiki is deprecated and due to be decommissioned by the end of September 2022.
The content is being migrated to other supports, new updates will be ignored and lost.
If needed you can get in touch with EGI SDIS team using operations @ egi.eu.
APEL/DatabaseTables
< APEL
Jump to navigation
Jump to search
Revision as of 17:57, 21 March 2012 by Wrogers (talk | contribs) (Created page with "These are here for reference. See also APEL/MessageFormat. MUL refers to a composite key. == JobRecords Table == {| cellspacing="1" cellpadding="1" border="1" width="600" ...")
These are here for reference. See also APEL/MessageFormat.
MUL 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 | |
| Role | varchar(255) | No | 'None' | Yes | Yes | |
| GridGroup | varchar(255) | No | 'None' | Yes | Yes | |
| VO | varchar(255) | No | 'None' | Yes | Yes | |
| WallDuration | int | |||||
| CpuDuration | int | |||||
| Processors | int | |||||
| NodeCount | int | |||||
| StartTime | datetime | No | ||||
| EndTime | datetime | MUL | ||||
| MemoryReal | int | |||||
| MemoryVirtual | int | |||||
| ScalingFactorType | varchar(50) | No | ||||
| ScalingFactor | 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 |
| Role | varchar(255) | No | MUL | 'None' | Yes |
| GridGroup | varchar(255) | No | MUL | 'None' | Yes |
| VO | 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 |