AAR


Columns

Column Type Size Nulls Auto Default Children Parents Comments
RecordID INTEGER 2000000000,10 √ √ null
AuthTokenAttributes.RecordID R
DataTransfers.RecordID R
JobEvents.RecordID R
JobExtraInfo.RecordID R
RunTimeEnvironments.RecordID R
JobID TEXT 2000000000,10 null
LocalJobID TEXT 2000000000,10 √ null
EndpointID INTEGER 2000000000,10 null
Endpoints.EndpointID R
QueueID INTEGER 2000000000,10 null
Queues.QueueID R
UserID INTEGER 2000000000,10 null
Users.UserID R
VOID INTEGER 2000000000,10 null
WLCGVOs.VOID R
StatusID INTEGER 2000000000,10 null
Status.StatusID R
ExitCode INTEGER 2000000000,10 null
SubmitTime INTEGER 2000000000,10 null
EndTime INTEGER 2000000000,10 null
NodeCount INTEGER 2000000000,10 null
CPUCount INTEGER 2000000000,10 null
UsedMemory INTEGER 2000000000,10 null
UsedVirtMem INTEGER 2000000000,10 null
UsedWalltime INTEGER 2000000000,10 null
UsedCPUUserTime INTEGER 2000000000,10 null
UsedCPUKernelTime INTEGER 2000000000,10 null
UsedScratch INTEGER 2000000000,10 null
StageInVolume INTEGER 2000000000,10 null
StageOutVolume INTEGER 2000000000,10 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
AAR_EndpointID_IDX Performance Asc EndpointID
AAR_EndTime_IDX Performance Asc EndTime
AAR_JobID_IDX Must be unique Asc JobID
AAR_LocalJobID_IDX Performance Asc LocalJobID
AAR_QueueID_IDX Performance Asc QueueID
AAR_StatusID_IDX Performance Asc StatusID
AAR_SubmitTime_IDX Performance Asc SubmitTime
AAR_UserID_IDX Performance Asc UserID
sqlite_autoindex_AAR_1 Must be unique Asc JobID

Relationships

Close relationships within degrees of separation