View ocum_report.annotation | Generated by SchemaSpy |
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`))))