Table dvnDb.public.vdcuser 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 serial 10  √  nextval('vdcuser_id_seq'::regclass)
flagged_study_comments.user_id fk_flagged_study_comments_user_id R
guestbookresponse.vdcuser_id fk_guestbookresponse_vdcuser_id R
networkrolerequest.vdcuser_id fk_networkrolerequest_vdcuser_id R
rolerequest.vdcuser_id fk_rolerequest_vdcuser_id R
study.creator_id fk_study_creator_id R
study.lastupdater_id fk_study_lastupdater_id R
study.reviewer_id fk_study_reviewer_id R
study_vdcuser.allowedusers_id fk_study_vdcuser_allowedusers_id R
studyaccessrequest.vdcuser_id fk_studyaccessrequest_vdcuser_id R
studycomment.commentcreator_id fk_studycomment_commentcreator_id R
studyfile_vdcuser.allowedusers_id fk_studyfile_vdcuser_allowedusers_id R
studylock.user_id fk_studylock_user_id R
studyrequest.vdcuser_id fk_studyrequest_vdcuser_id R
vdc.creator_id fk_vdc_creator_id R
vdc.reviewer_id fk_vdc_reviewer_id R
vdc_fileuser.allowedfileusers_id fk_vdc_fileuser_allowedfileusers_id R
vdcnetwork.creator_id fk_vdcnetwork_creator_id R
vdcnetwork.defaultnetworkadmin_id fk_vdcnetwork_defaultnetworkadmin_id R
vdcrole.vdcuser_id fk_vdcrole_vdcuser_id R
vdcuser_studycomment.vdcuser_id fk_vdcuser_studycomment_vdcuser_id R
vdcuser_usergroup.users_id fk_vdcuser_usergroup_users_id R
versioncontributor.contributor_id fk_versioncontributor_contributor_id R
active bool 1  √  null
agreedtermsofuse bool 1  √  null
bypasstermsofuse bool 1  √  null
email varchar 255  √  null
encryptedpassword text 2147483647  √  null
firstname varchar 255  √  null
institution varchar 255  √  null
lastname varchar 255  √  null
phonenumber varchar 255  √  null
position varchar 255  √  null
test int4 10  √  null
username varchar 255  √  null
version int8 19  √  null
networkrole_id int8 19  √  null
networkrole.id fk_vdcuser_networkrole_id R

Table contained 5 rows at Fri May 30 15:33 MDT 2014

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc vdcuser_pkey

Close relationships  within of separation: