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 10  √ 
attachment.projectId FK8AF7592362A5139B
baseline.projectId FK996EE64562A5139B
distributiongroup.projectId FK3C591A7B62A5139B
document.projectId FK335CD11B62A5139B
documentgroup.projectId FK5EF19E4462A5139B
documentkeylookup.projectId FK_dockeylookup_project
evententry.project FK3AFE2618858B68C0
glossaryitem.projectId FKEE51863162A5139B
perspectiveconfig.projectId FKAB47207E62A5139B
review.projectId FKC84EF75862A5139B
viewconfig.projectId FKAC076E2762A5139B
createdBy int 10  √  null
createdDate datetime 19  √  null
modifiedBy int 10  √  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 10  √  null
projectKey varchar 255  √  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 10  √  null
lookup.id FKED904B196AC02593
lookup2Id int 10  √  null
lookup.id FKED904B196AC02954
lookup3Id int 10  √  null
lookup.id FKED904B196AC02D15
lookup4Id int 10  √  null
lookup.id FKED904B196AC030D6
organizationId int 10
organization.id FKED904B19B2808048
Associated organization
projectGroupLookupId int 10  √  null
lookup.id FKED904B19C82FC15C
Associated project group
projectManager int 10  √  null
userbase.id FKED904B194A8942C6
User ID assigned as project manager
projectTypeId int 10  √  null
projecttype.id FKED904B19B0B57FAF
statusId int 10  √  null
lookup.id FKED904B1974C9DCCE
Status lookup
user1Id int 10  √  null
userbase.id FKED904B194267BDB3
user2Id int 10  √  null
userbase.id FKED904B194267C174

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

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
projectTypeId Performance Asc FKED904B19B0B57FAF
organizationId Performance Asc FKED904B19B2808048
projectGroupLookupId Performance Asc FKED904B19C82FC15C

Close relationships  within of separation: