Table contour.userbase
Users

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  √ 
aclpermission.userId FKAF999D91958AE78
distributiongroup_user.userId FKC89CDF0F1958AE78
document.assignedToId FK335CD11BDDE05BF6
document.lockedBy FK335CD11BBD032133
document.user1Id FK335CD11B4267BDB3
document.user2Id FK335CD11B4267C174
email.userId FK5C24B9C1958AE78
evententry.eventUser FK3AFE26184D1BFDB7
integrationconnection.defaultContourUserId FKB2C6BBB2845B1931
jamacomment.userId FKECA112F41958AE78
project.projectManager FKED904B194A8942C6
project.user1Id FKED904B194267BDB3
project.user2Id FKED904B194267C174
signature.userId FK3FFD98B81958AE78
subscription.userId FK1456591D1958AE78
user_job.userId FKF022D9491958AE78
user_organization.userId FK3622D271958AE78
user_role.userId FK143BF46A1958AE78
System generated unique ID
createdBy int 11  √  null
createdDate datetime 19  √  null
modifiedBy int 11  √  null
modifiedDate datetime 19  √  null
disabled char 1  √  null
email varchar 255 User email
firstName varchar 255  √  null User first name
lastName varchar 255  √  null User last name
licenseType varchar 255  √  null
locale varchar 32  √  null
location varchar 64  √  null
locked char 1  √  null
notes longtext 2147483647  √  null
password varchar 50 Hashed password
passwordAttempts int 11  √  null
phone varchar 64  √  null
systemUser char 1  √  null
theme varchar 64  √  null
title varchar 64  √  null
userName varchar 255
visibleUser char 1  √  null Internal flag to indicate if the user account is visible
avatarId int 11  √  null
attachment.id FK_USER_AVATAR
organization int 11  √  null
organization.id FKF024151C3006F3ED

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
avatarId Performance Asc FK_USER_AVATAR
organization Performance Asc FKF024151C3006F3ED

Close relationships  within of separation: