View ocum.groupmembershiprulelivelistdtoview 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
storageObjectType varchar 255
numberOfMatchingObjects bigint 19  √  null
groupId bigint 19
groupName varchar 255  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `rule`.`id` AS `id`,`rule`.`name` AS `name`,`rule`.`storageObjectType` AS `storageObjectType`,(select count(0) from `ocum`.`groupmembership` where (`ocum`.`groupmembership`.`groupMembershipRuleId` = `rule`.`id`)) AS `numberOfMatchingObjects`,`rule`.`groupId` AS `groupId`,`ocum`.`groups`.`name` AS `groupName` from (`ocum`.`groupmembershiprule` `rule` left join `ocum`.`groups` on((`rule`.`groupId` = `ocum`.`groups`.`id`)))
 
Possibly Referenced Tables/Views: