View ocum.grouplivelistdtoview 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
description varchar 1024  √  null
numberOfActions bigint 19  √  null
numberOfMembershipRules bigint 19  √  null
numberOfClusters bigint 19  √  null
numberOfSVMs bigint 19  √  null
numberOfVolumes bigint 19  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `ocum`.`groups`.`id` AS `id`,`ocum`.`groups`.`name` AS `name`,`ocum`.`groups`.`description` AS `description`,(select count(`ocum`.`groupaction`.`id`) from `ocum`.`groupaction` where (`ocum`.`groupaction`.`groupId` = `ocum`.`groups`.`id`)) AS `numberOfActions`,(select count(`ocum`.`groupmembershiprule`.`id`) from `ocum`.`groupmembershiprule` where (`ocum`.`groupmembershiprule`.`groupId` = `ocum`.`groups`.`id`)) AS `numberOfMembershipRules`,(select count(distinct `ocum`.`groupmembership`.`resourceId`) from `ocum`.`groupmembership` where ((`ocum`.`groupmembership`.`groupId` = `ocum`.`groups`.`id`) and (`ocum`.`groupmembership`.`storageObjectType` = 'cluster'))) AS `numberOfClusters`,(select count(distinct `ocum`.`groupmembership`.`resourceId`) from `ocum`.`groupmembership` where ((`ocum`.`groupmembership`.`groupId` = `ocum`.`groups`.`id`) and (`ocum`.`groupmembership`.`storageObjectType` = 'vserver'))) AS `numberOfSVMs`,(select count(distinct `ocum`.`groupmembership`.`resourceId`) from `ocum`.`groupmembership` where ((`ocum`.`groupmembership`.`groupId` = `ocum`.`groups`.`id`) and (`ocum`.`groupmembership`.`storageObjectType` = 'volume'))) AS `numberOfVolumes` from `ocum`.`groups`
 
Possibly Referenced Tables/Views: