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 10  √ 
aclpermission.userId FKAF999D91958AE78
distributiongroup_user.userId FKC89CDF0F1958AE78
document.assignedToId FK_TESTRUN_USER
document.lockedBy FK335CD11BBD032133
document.user1Id FK335CD11B4267BDB3
document.user2Id FK335CD11B4267C174
email.userId FK5C24B9C1958AE78
evententry.eventUser FK3AFE26184D1BFDB7
integrationconnection.defaultContourUserId FKB2C6BBB2845B1931
jamacomment.userId FKECA112F41958AE78
jamacomment_userlikes.userId FK121CEB461958AE78
mutedsubscription.subscriberId FK_MUTEDSUB_USER
project.projectManager FKED904B194A8942C6
project.user1Id FKED904B194267BDB3
project.user2Id FKED904B194267C174
review_author.authorUserId FK2941B452966B3BC3
revision_user.userId FKFA0C9DAF1958AE78
signature.userId FK3FFD98B81958AE78
subscription.subscribedBy FK_SUBSCRIPTION_SUBSCRIBEDBY
subscription.userId FK_SUBSCRIPTION_USER
testrunset.assignedToId FK_TESTRUNSET_USER
testset.assignedToId FK_TESTSET_ASSIGNEDTO
user_job.userId FKF022D9491958AE78
user_organization.userId FK3622D271958AE78
user_role.userId FK143BF46A1958AE78
userfavorite.userId FKD01BA671958AE78
useritemviewhistory.userId FKF9A8E6311958AE78
userlogentry.userId FK46B8C0791958AE78
System generated unique ID
createdBy int 10  √  null
createdDate datetime 19  √  null
modifiedBy int 10  √  null
modifiedDate datetime 19  √  null
autoFollowCommentedItems char 1  √  null
disabled char 1  √  null
email varchar 255 User email
emailUpdatesToFollowedItems char 1  √  null
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 10  √  null
phone varchar 64  √  null
salt varchar 255  √  null
systemUser char 1  √  null
theme varchar 64  √  null
title varchar 64  √  null
unregistered char 1  √  null
userName varchar 255
visibleUser char 1  √  null Internal flag to indicate if the user account is visible
avatarId int 10  √  null
attachment.id FK_USER_AVATAR
organization int 10  √  null
organization.id FKF024151C3006F3ED

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

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: