Difference between revisions of "APEL/DatabaseTables"

From EGIWiki
Jump to: navigation, search
(Summaries Table)
(Summaries Table)
Line 96: Line 96:
 
| ServiceLevelType      || varchar(50)  || No  || MUL || 'None' || Yes  
 
| ServiceLevelType      || varchar(50)  || No  || MUL || 'None' || Yes  
 
|-
 
|-
| ServiceLevel          ||   || No  || MUL || 'None' || Yes  
+
| ServiceLevel          || double      || No  || MUL || 'None' || Yes  
 
|-
 
|-
 
| NodeCount              || int          ||  No  ||    ||    0  ||   
 
| NodeCount              || int          ||  No  ||    ||    0  ||   

Revision as of 18:56, 19 February 2013

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
Queue varchar(255) No
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
NodeCount int
StartTime datetime No
EndTime datetime MUL
InfrastructureDescription varchar(255)
InfrastructureType varchar(255)
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
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
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'