Table ocum.task 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
taskmessage.task_id TaskMessage_task_id_FK C
taskobjectinteraction.task_id TaskObjectInteraction_task_id_FK C
taskpredecessor.task_id TaskPredecessor_task_id_FK C
taskpredecessor.taskPredecessor_id TaskPredecessor_taskPredecessor_id_FK C
taskretry.task_id TaskRetry_task_id_FK C
taskstatuschange.task_id TaskStatusChange_task_id_FK C
job_id varchar 64
job.id Task_job_id_FK C
name varchar 2048
description longtext 2147483647  √  null
status varchar 32
priority varchar 32
taskType varchar 64
failureReason longtext 2147483647  √  null
data longtext 2147483647  √  null
task longblob 2147483647  √  null
startedTimestamp timestamp 19  √  null
completedTimestamp timestamp 19  √  null
dependencyOrder int 10
taskGuardName varchar 255
reportable bit 1

Table contained 0 rows at Tue Apr 23 05:29 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
job_id Performance Asc Task_job_IX

Close relationships: