View ocum_report.annotation 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
name varchar 255
type varchar 255
resourceId bigint 19
resourceType varchar 100

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `ocum`.`annotation`.`name` AS `name`,`ocum`.`annotationtype`.`name` AS `type`,`ocum`.`annotationresourceobject`.`resource_id` AS `resourceId`,`ocum`.`annotationresourceobject`.`resource_type` AS `resourceType` from ((`ocum`.`annotation` join `ocum`.`annotationtype` on((`ocum`.`annotationtype`.`id` = `ocum`.`annotation`.`type_id`))) join `ocum`.`annotationresourceobject` on(((`ocum`.`annotationresourceobject`.`annotation_id` = `ocum`.`annotation`.`id`) and (`ocum`.`annotationresourceobject`.`annotationType_id` = `ocum`.`annotationtype`.`id`))))