Table sbs6a.public.jiveuser 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
userid int8 19
jiveabuse.userid Implied Constraint R
jiveactivity.userid Implied Constraint R
jiveactivityhistry.userid Implied Constraint R
jiveannounce.userid Implied Constraint R
jiveanswer.userid Implied Constraint R
jiveapientitlement.userid Implied Constraint R
jiveappalertack.userid Implied Constraint R
jiveapprovalwrkflw.userid Implied Constraint R
jivearchivepolicy.userid Implied Constraint R
jiveauditlog.userid Implied Constraint R
jiveavataruser.userid Implied Constraint R
jivebinmetadata.userid Implied Constraint R
jiveblogpost.userid Implied Constraint R
jivebridge.userid Implied Constraint R
jivebridgedcontmsg.userid Implied Constraint R
jivebridgeuser.userid Implied Constraint R
jivebrowsefol.userid Implied Constraint R
jivebrowseprtd.userid Implied Constraint R
jivecnxtconnection.userid Implied Constraint R
jivecnxtsvcowner.userid Implied Constraint R
jivecomment.userid Implied Constraint R
jivecontaineraprvr.userid Implied Constraint R
jivecontent.userid Implied Constraint R
jivecredential.userid Implied Constraint R
jivedashboard.userid jivedash_user_fk R
jivedevsettings.userid Implied Constraint R
jivedoccollab.userid Implied Constraint R
jivedocument.userid Implied Constraint R
jivedocumentaudit.userid Implied Constraint R
jivedocversion.userid Implied Constraint R
jivedocversioncmmt.userid Implied Constraint R
jivedraft.userid Implied Constraint R
jivedvrevision.userid Implied Constraint R
jiveeaeuserprop.userid Implied Constraint R
jiveemailtoken.userid Implied Constraint R
jiveentitlement.userid Implied Constraint R
jiveexternalidentity.userid Implied Constraint R
jivefollow.userid jivefollow_uid_fk R
jivegroupuser.userid juser_userid_fk R
jivegroupuserhist.userid Implied Constraint R
jiveinboxentry.userid Implied Constraint R
jiveinstanceapp.userid Implied Constraint R
jiveinvite.userid Implied Constraint R
jivelabel.ownerid jvlbl_fk_userid R
jivemessage.userid Implied Constraint R
jiveoauthpairing.userid Implied Constraint R
jiveoauthstore.userid jiveoauth_user_fk R
jiveoauthtoken.userid Implied Constraint R
jiveocbmetadata.userid jvusrocbm_fk_usid R
jiveofficecoauthors.userid Implied Constraint R
jiveosappdata.userid Implied Constraint R
jiveosfileitem.userid jvusrosfi_fk_usid R
jivepoll.userid Implied Constraint R
jivepollvote.userid Implied Constraint R
jiveproject.userid Implied Constraint R
jiveprojectstatus.userid Implied Constraint R
jiveptask.userid Implied Constraint R
jivequestion.userid Implied Constraint R
jivequestprogress.userid Implied Constraint R
jiverating.userid Implied Constraint R
jivereadtracker.userid Implied Constraint R
jivesgroup.userid Implied Constraint R
jivesgroupmember.userid jsgmem_uid_fk R
jivestatics.userid Implied Constraint R
jivestatuslevelpnt.userid Implied Constraint R
jivestatuslevelpntsum.userid Implied Constraint R
jivestreamapprover.userid Implied Constraint R
jivestreamentry.userid jivestrm_user_fk R
jivesystemjob.userid Implied Constraint R
jiveuserannprop.userid Implied Constraint R
jiveusercontainer.userid jiveucont_uid_fk R
jiveuserimhandle.userid juid_uid_fk R
jiveusermesgcount.userid Implied Constraint R
jiveuserperm.userid Implied Constraint R
jiveuserprofile.userid Implied Constraint R
jiveuserprop.userid Implied Constraint R
jiveuserrel.relateduserid jvusrrel_fk_rlusid R
jiveuserrel.userid jvusrrel_fk_usrid R
jiveuserroster.userid Implied Constraint R
jiveuserstatus.userid Implied Constraint R
jiveusrrelgrapr.userid jvusrrelga_fk_usid R
jiveusrrelgrntf.userid jvusrrelnt_fk_usid R
jiveusrrellist.userid jvurlst_fk_userid R
jivewatch.userid Implied Constraint R
jivewatchsettings.userid Implied Constraint R
username varchar 100
passwordhash varchar 64
name varchar 100  √  null
firstname varchar 100  √  null
lastname varchar 100  √  null
namevisible int4 10
email varchar 100
emailvisible int4 10
userenabled int4 10
creationdate int8 19
modificationdate int8 19
lastloggedin int8 19 0
lastprofileupdate int8 19 0
usertype int4 10 0
federated int4 10 0
visible int4 10 1
status int4 10 6

Table contained 2 rows at Fri Aug 24 10:15 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
userid Primary key Asc jiveuser_pk
creationdate Performance Asc jiveuser_cdate_idx
visible + userenabled + usertype Performance Asc/Asc/Asc jiveuser_eex_idx
email Performance Asc jiveuser_em_idx
Performance jiveuser_lcun
username Must be unique Asc jiveuser_username_key
modificationdate Performance Asc jvusr_mdfctndt_idx

Close relationships  within of separation: