Table contour.documentgroup
Primary groups table

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  √ 
document.documentGroup FK335CD11B884663C1
evententry.documentGroup FK3AFE2618884663C1
filter.documentGroup FKB408CB78884663C1
System generated unique ID
createdBy int 10  √  null User ID
createdDate datetime 19  √  null
modifiedBy int 10  √  null User ID
modifiedDate datetime 19  √  null
active char 1  √  null Active flag
description longtext 2147483647  √  null User entered description of group
display varchar 255  √  null Singular label to display
displayInReleaseTree char 1  √  null Flag that determines if the items should be included in the default display of the milestones tree
displayPlural varchar 255  √  null Plural label to display
image varchar 255  √  null Path to icon
keySeperator varchar 255  √  null
organizationId int 10  √  null
prefix varchar 255  √  null Prefix for item Key such as 'REQ'
sequenceNumber int 10  √  null Numerical value to start with when generating unique item keys
sortOrder int 10  √  null Order relative to peers
documentTypeId int 10  √  null
documenttype.id FK5EF19E44E181EF2C
projectId int 10  √  null
project.id FK5EF19E4462A5139B

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
projectId Performance Asc FK5EF19E4462A5139B
documentTypeId Performance Asc FK5EF19E44E181EF2C

Close relationships  within of separation: