Table contour.project
Project attributes

 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  √ 
attachment.projectId FK8AF7592343370F26
baseline.projectId FK996EE64543370F26
distributiongroup.projectId FK3C591A7B43370F26
document.projectId FK335CD11B43370F26
documentgroup.projectId FK5EF19E4443370F26
evententry.project FK3AFE2618661D644B
glossaryitem.projectId FKEE51863143370F26
perspectiveconfig.projectId FKAB47207E43370F26
viewconfig.projectId FKAC076E2743370F26
createdBy int 11  √  null
createdDate datetime 19  √  null
modifiedBy int 11  √  null
modifiedDate datetime 19  √  null
active char 1  √  null
date1 datetime 19  √  null
date2 datetime 19  √  null
description longtext 2147483647  √  null
flag1 char 1  √  null
flag2 char 1  √  null
isFolder char 1  √  null
name varchar 255  √  null
parentId int 11  √  null
string1 varchar 255  √  null
string2 varchar 255  √  null
string3 varchar 255  √  null
string4 varchar 255  √  null
text1 longtext 2147483647  √  null
text2 longtext 2147483647  √  null
text3 longtext 2147483647  √  null
lookup1Id int 11  √  null
lookup.id FKED904B196AC02593
lookup2Id int 11  √  null
lookup.id FKED904B196AC02954
lookup3Id int 11  √  null
lookup.id FKED904B196AC02D15
lookup4Id int 11  √  null
lookup.id FKED904B196AC030D6
organizationId int 11
organization.id FKED904B19B2808048
Associated organization
projectGroupLookupId int 11  √  null
lookup.id FKED904B19C82FC15C
Associated project group
projectManager int 11  √  null
userbase.id FKED904B194A8942C6
User ID assigned as project manager
projectTypeId int 11  √  null
projecttype.id FKED904B19B978BDBA
statusId int 11  √  null
lookup.id FKED904B1974C9DCCE
Status lookup
user1Id int 11  √  null
userbase.id FKED904B194267BDB3
user2Id int 11  √  null
userbase.id FKED904B194267C174

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
user1Id Performance Asc FKED904B194267BDB3
user2Id Performance Asc FKED904B194267C174
projectManager Performance Asc FKED904B194A8942C6
lookup1Id Performance Asc FKED904B196AC02593
lookup2Id Performance Asc FKED904B196AC02954
lookup3Id Performance Asc FKED904B196AC02D15
lookup4Id Performance Asc FKED904B196AC030D6
statusId Performance Asc FKED904B1974C9DCCE
organizationId Performance Asc FKED904B19B2808048
projectTypeId Performance Asc FKED904B19B978BDBA
projectGroupLookupId Performance Asc FKED904B19C82FC15C

Close relationships  within of separation: