View ocum.annotationrulelivelistdtoview 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 bigint 19 0
name varchar 255
rank int 10
resourceType varchar 255
annotationTypeId bigint 19 0
annotationTypeName varchar 255
annotationValueId bigint 19 0
annotationValueName varchar 255
annotationValueFullName varchar 511  √  null
numberOfAnnotatedObjects bigint 19  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `ocum`.`annotationrule`.`id` AS `id`,`ocum`.`annotationrule`.`name` AS `name`,`ocum`.`annotationrule`.`rank` AS `rank`,`ocum`.`annotationrule`.`resourceType` AS `resourceType`,`ocum`.`annotationtype`.`id` AS `annotationTypeId`,`ocum`.`annotationtype`.`name` AS `annotationTypeName`,`ocum`.`annotation`.`id` AS `annotationValueId`,`ocum`.`annotation`.`name` AS `annotationValueName`,concat(`ocum`.`annotationtype`.`name`,'=',`ocum`.`annotation`.`name`) AS `annotationValueFullName`,(select count(0) from `ocum`.`annotationresourceobject` where (`ocum`.`annotationresourceobject`.`annotationRule_id` = `ocum`.`annotationrule`.`id`)) AS `numberOfAnnotatedObjects` from ((`ocum`.`annotationrule` straight_join `ocum`.`annotationtype` on((`ocum`.`annotationtype`.`id` = `ocum`.`annotationrule`.`annotationTypeId`))) straight_join `ocum`.`annotation` on((`ocum`.`annotation`.`id` = `ocum`.`annotationrule`.`annotationValueId`)))
 
Possibly Referenced Tables/Views: