View ocum.annotationresourceobjectlivelistdtoview 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
annotationName varchar 255
annotationTypeName varchar 255
resourceId bigint 19
resourceType varchar 100
resourceName varchar 255  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `ocum`.`annotation`.`name` AS `annotationName`,`ocum`.`annotationtype`.`name` AS `annotationTypeName`,`ocum`.`annotationresourceobject`.`resource_id` AS `resourceId`,`ocum`.`annotationresourceobject`.`resource_type` AS `resourceType`,coalesce(`cluster`.`name`,`volume`.`name`,`vserver`.`name`) AS `resourceName` from (((((`ocum`.`annotationresourceobject` left join `netapp_model_view`.`cluster` on(((`ocum`.`annotationresourceobject`.`resource_id` = `cluster`.`objid`) and (`ocum`.`annotationresourceobject`.`resource_type` = 'cluster')))) left join `netapp_model_view`.`volume` on(((`ocum`.`annotationresourceobject`.`resource_id` = `volume`.`objid`) and (`ocum`.`annotationresourceobject`.`resource_type` = 'volume')))) left join `netapp_model_view`.`vserver` on(((`ocum`.`annotationresourceobject`.`resource_id` = `vserver`.`objid`) and (`ocum`.`annotationresourceobject`.`resource_type` = 'vserver')))) straight_join `ocum`.`annotationtype` on((`ocum`.`annotationtype`.`id` = `ocum`.`annotationresourceobject`.`annotationType_id`))) straight_join `ocum`.`annotation` on((`ocum`.`annotation`.`id` = `ocum`.`annotationresourceobject`.`annotation_id`)))
 
Possibly Referenced Tables/Views: