View ocum.annotationrulelivelistdtoview | Generated by SchemaSpy |
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: