View ocum.taskreportview 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
jobId varchar 64
name varchar 2048
status int 10  √  null
taskState varchar 32  √  null
taskType varchar 64
priority varchar 32
failureReason longtext 2147483647  √  null
description longtext 2147483647  √  null
data longtext 2147483647  √  null
startedTimestamp timestamp 19  √  null
completedTimestamp timestamp 19  √  null
dependencyOrder int 10
internalStatus varchar 32
taskGuardName varchar 255
reportable bit 1

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `ocum`.`task`.`id` AS `id`,`ocum`.`task`.`job_id` AS `jobId`,`ocum`.`task`.`name` AS `name`,`na_TaskStatus`(`ocum`.`task`.`status`) AS `status`,`na_TaskState`(`ocum`.`task`.`status`) AS `taskState`,`ocum`.`task`.`taskType` AS `taskType`,`ocum`.`task`.`priority` AS `priority`,`ocum`.`task`.`failureReason` AS `failureReason`,`ocum`.`task`.`description` AS `description`,`ocum`.`task`.`data` AS `data`,`ocum`.`task`.`startedTimestamp` AS `startedTimestamp`,`ocum`.`task`.`completedTimestamp` AS `completedTimestamp`,`ocum`.`task`.`dependencyOrder` AS `dependencyOrder`,`ocum`.`task`.`status` AS `internalStatus`,`ocum`.`task`.`taskGuardName` AS `taskGuardName`,`ocum`.`task`.`reportable` AS `reportable` from `ocum`.`task`
 
Possibly Referenced Tables/Views:
task