Table JiveCore800.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
jivebadgerolerel.userid jbdgrlrel_user_fk 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
jivecarouselcontainer.userid jivecarcntnr_user_fk 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
jivecontentplacerel.userid Implied Constraint R
jivecredential.userid Implied Constraint R
jivedashboard.userid jivedash_user_fk R
jivedemoreco.userid Implied Constraint 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
jiveeaeuserprop.userid Implied Constraint R
jiveemailtoken.userid Implied Constraint R
jiveentitlement.userid Implied Constraint R
jiveexpertisetag.originuserid jetag_fk_ouserid R
jiveexpertisetag.targetuserid jetag_fk_tuserid R
jiveexportrequest.requestuserid jiveexpreq_requserid_fk R
jiveexportrequest.targetuserid jiveexpreq_taruserid_fk R
jiveextension.deployerid jvext_impexpid_fk R
jiveexternalidentity.userid Implied Constraint R
jivefollow.userid jivefollow_uid_fk R
jivegroupuser.userid juser_userid_fk R
jivegroupuserhist.userid Implied Constraint R
jiveidmembership.userid Implied Constraint R
jiveinboxentry.userid Implied Constraint R
jiveinstanceapp.userid Implied Constraint R
jiveinvite.inviterid jvinvt_fk_invtrid R
jiveinvite.userid jvinvt_fk_usrid R
jivelabel.ownerid jvlbl_fk_userid R
jivemessage.userid Implied Constraint R
jivemobilepushregistration.userid push_user_fk_id R
jiveoauth2client.userid Implied Constraint R
jiveoauth2code.userid jvoauth2codeusr_fk R
jiveoauthpairing.userid Implied Constraint R
jiveoauthstore.userid jiveoauth_user_fk R
jiveoauthtoken.userid Implied Constraint R
jiveofficecoauthors.userid Implied Constraint R
jiveosappdata.userid Implied Constraint R
jiveosfileitem.userid jvusrosfi_fk_usid R
jiveoutcome.userid Implied Constraint R
jivepoll.userid Implied Constraint R
jivepollvote.userid Implied Constraint R
jiveprivateprops.userid Implied Constraint R
jiveproject.userid Implied Constraint R
jiveprojectstatus.userid Implied Constraint R
jiveptask.userid Implied Constraint R
jivepublication.userid Implied Constraint R
jiveqcompletion.userid Implied Constraint R
jiveqstepprog.userid Implied Constraint R
jivequestion.userid Implied Constraint R
jiverating.userid Implied Constraint R
jivereadtracker.userid Implied Constraint R
jivertccollabinteraction.userid Implied Constraint R
jivertccollaboration.userid jivertccollab_user_fk R
jivertccollaborationuser.userid jivertcclbuser_user_fk R
jivesgroup.userid Implied Constraint R
jivesgroupmember.userid jsgmem_uid_fk R
jiveslide.userid jiveslide_user_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
jivetileinstance.userid Implied Constraint R
jivetilestreamentry.userid Implied Constraint R
jivetiletemplate.userid Implied Constraint R
jiveuseraltemail.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
jiveusersecretkey.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
jivewebhook.userid Implied Constraint R
username varchar 254
passwordhash varchar 64
name varchar 100  √  null
firstname varchar 100  √  null
lastname varchar 100  √  null
namevisible int4 10
email varchar 254
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
initiallogindate int8 19 0

Analyzed at Mon Apr 27 15:32 PDT 2015

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: