Table contour.subscription 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 int 10  √ 
mutedsubscription.subscriptionId FK_MUTEDSUB_SUBSCRIPTION
createdBy int 10  √  null
createdDate datetime 19  √  null
modifiedBy int 10  √  null
modifiedDate datetime 19  √  null
contextId int 10  √  null
contextScope int 10  √  null
organizationId int 10  √  null
refId int 10  √  null
scope int 10  √  null
groupId int 10  √  null
role.id FK_SUBSCRIPTION_ROLE
subscribedBy int 10  √  null
userbase.id FK_SUBSCRIPTION_SUBSCRIBEDBY
userId int 10  √  null
userbase.id FK_SUBSCRIPTION_USER

Table contained 0 rows at Wed Jan 18 17:22 PST 2012

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
groupId Performance Asc FK_SUBSCRIPTION_ROLE
subscribedBy Performance Asc FK_SUBSCRIPTION_SUBSCRIBEDBY
userId Performance Asc FK_SUBSCRIPTION_USER
scope + refId Performance Asc/Asc subscription_scope_ref_idx

Close relationships  within of separation: