Alert.png 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"

From EGIWiki
Jump to navigation Jump to search
Line 1: Line 1:
* Back to [[APEL/Server]]
* Back to [[APEL/Server]]
* See also [[APEL/MessageFormat]]
* 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.
These are here for reference.  Note that MUL beside multiple columns refers to a composite key.
Line 75: Line 75:
| GlobalUserName        || varchar(255) || No  || MUL || 'None' || Yes  
| GlobalUserName        || varchar(255) || No  || MUL || 'None' || Yes  
|-  
|-  
| Role                  || varchar(255) || No  || MUL || 'None' || Yes  
| GridGroup              || varchar(255) || No  || MUL || 'None' || Yes  
|-
|-
| GridGroup              || varchar(255) || No  || MUL || 'None' || Yes  
| VOGroup                || varchar(255) || No  || MUL || 'None' || Yes  
|-
|-
| VO                    || varchar(255) || No  || MUL || 'None' || Yes  
| VORole                || varchar(255) || No  || MUL || 'None' || Yes  
|-
|-
| EarliestEndTime        || datetime    ||      ||    ||        ||     
| EarliestEndTime        || datetime    ||      ||    ||        ||     

Revision as of 17:02, 21 March 2012

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
GridGroup varchar(255) No MUL 'None' Yes
VOGroup varchar(255) No MUL 'None' Yes
VORole 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