View ocum.taskstatuschangeview 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
taskId varchar 64
timestamp timestamp 19 0000-00-00 00:00:00
changeSequence int 10
status int 10  √  null
taskState varchar 32  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `ocum`.`taskstatuschange`.`id` AS `id`,`ocum`.`taskstatuschange`.`task_id` AS `taskId`,`ocum`.`taskstatuschange`.`timestamp` AS `timestamp`,`ocum`.`taskstatuschange`.`changeSequence` AS `changeSequence`,`na_TaskStatus`(`ocum`.`taskstatuschange`.`status`) AS `status`,`na_TaskState`(`ocum`.`taskstatuschange`.`status`) AS `taskState` from `ocum`.`taskstatuschange`
 
Possibly Referenced Tables/Views: