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.
Difference between revisions of "APEL/DatabaseTables"
< APEL
Jump to navigation
Jump to search
(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" ...") |
|||
| Line 1: | Line 1: | ||
* Back to [[APEL/Server]] | |||
* See also [[APEL/MessageFormat]] | |||
MUL refers to a composite key. | These are here for reference. Note that MUL beside multiple columns refers to a composite key. | ||
== JobRecords Table == | == JobRecords Table == | ||
| Line 19: | Line 20: | ||
| SubmitHost || varchar(255) || No || MUL || || Yes || | | SubmitHost || varchar(255) || No || MUL || || Yes || | ||
|- | |- | ||
| | | LocalJobId || varchar(255) || No || MUL || || || | ||
|- | |- | ||
| | | LocalUserId || varchar(255) || || || || || | ||
|- | |- | ||
| GlobalUserName || varchar(255) || No || || 'None' || Yes || Yes | | 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 || || || || || | | WallDuration || int || || || || || | ||
| Line 47: | Line 48: | ||
| MemoryVirtual || int || || || || || | | MemoryVirtual || int || || || || || | ||
|- | |- | ||
| | | ServiceLevelType || varchar(50) || No || || || || | ||
|- | |- | ||
| | | ServiceLevel || double || No || || || || | ||
|- | |- | ||
|} | |} | ||
Revision as of 18:01, 21 March 2012
- Back to APEL/Server
- See also APEL/MessageFormat
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 |
| 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 |