Table contour.distributiongroup
Email distribution groups for outbound email notification

 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 11  √ 
distributiongroup_user.distributionGroupId FKC89CDF0F573B620A
System generated unique ID
createdBy int 11  √  null User ID
createdDate datetime 19  √  null
modifiedBy int 11  √  null User ID
modifiedDate datetime 19  √  null
description longtext 2147483647  √  null Text description
name varchar 255  √  null Label for the distribution group
organizationId int 11  √  null
organization.id FK3C591A7BB2808048
Associated organization ID
projectId int 11
project.id FK3C591A7B43370F26
Associated project ID

Table contained 12 rows at Mon Jun 14 17:03 PDT 2010

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
projectId Performance Asc FK3C591A7B43370F26
organizationId Performance Asc FK3C591A7BB2808048

Close relationships  within of separation: