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

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

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

Close relationships  within of separation: