Table ocum.groupmembership 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
groupId bigint 19
groups.id GroupMembership_groupId_FK C
groupMembershipRuleId bigint 19
groupmembershiprule.id GroupMembership_groupMembershipRuleId_FK C
resourceId bigint 19
storageObjectType varchar 100

Table contained 0 rows at Tue Apr 23 05:29 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
groupId + groupMembershipRuleId + resourceId + storageObjectType Primary key Asc/Asc/Asc/Asc PRIMARY
groupId Performance Asc GroupMembership_I
groupMembershipRuleId Performance Asc GroupMembership_II
resourceId + storageObjectType Performance Asc/Asc GroupMembership_resource_IX

Close relationships  within of separation: