View ocum.jobreportview Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 64
jobType varchar 64
name varchar 280
status int 10 0
state varchar 9
submittedTimestamp timestamp 19 0000-00-00 00:00:00
completedTimestamp timestamp 19  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `ocum`.`job`.`id` AS `id`,`ocum`.`job`.`jobType` AS `jobType`,`ocum`.`job`.`name` AS `name`,(case `ocum`.`job`.`status` when 'PARTIALLY_SUCCEEDED' then 2 when 'FAILED' then 3 else 0 end) AS `status`,(case `ocum`.`job`.`status` when 'RUNNING' then 'running' when 'ABORTING' then 'aborting' when 'ABORTED' then 'aborted' else 'completed' end) AS `state`,`ocum`.`job`.`submittedTimestamp` AS `submittedTimestamp`,`ocum`.`job`.`completedTimestamp` AS `completedTimestamp` from `ocum`.`job`
 
Possibly Referenced Tables/Views:
job