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