View ocum.annotationtypevalueview 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
annotationTypeId bigint 19  √  0
annotationTypeName varchar 255  √  null
healthStatus int 10 0
annotationValueId bigint 19 0
annotationValueName varchar 255
annotationValueHealthStatus int 10 0

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `ocum`.`annotationtype`.`id` AS `annotationTypeId`,`ocum`.`annotationtype`.`name` AS `annotationTypeName`,0 AS `healthStatus`,`ocum`.`annotation`.`id` AS `annotationValueId`,`ocum`.`annotation`.`name` AS `annotationValueName`,0 AS `annotationValueHealthStatus` from (`ocum`.`annotation` left join `ocum`.`annotationtype` on((`ocum`.`annotationtype`.`id` = `ocum`.`annotation`.`type_id`)))
 
Possibly Referenced Tables/Views: