JiveCore700.public - Constraints Generated by
SchemaSpy
188 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
acc_acclaimid_fk jiveacccontainer.acclaimid jiveacclaim.acclaimid Restrict delete 
ap_acclaimid_fk jiveacclaimprop.acclaimid jiveacclaim.acclaimid Restrict delete 
av_acclaimid_fk jiveacclaimvote.acclaimid jiveacclaim.acclaimid Restrict delete 
avp_voteid_fk jiveaccvoteprop.voteid jiveacclaimvote.voteid Restrict delete 
ja_exfileid_fk jiveattachment.exstoragefileid jivestorageattachment.exstorageattid Restrict delete 
jap_aid_fk jiveannounceprop.announcementid jiveannounce.announcementid Restrict delete 
jatrprp_aid_fk jiveavatarprop.avatarid jiveavatar.avatarid Restrict delete 
jatrusr_aid_fk jiveavataruser.avatarid jiveavatar.avatarid Restrict delete 
jattprp_aid_fk jiveattachmentprop.attachmentid jiveattachment.attachmentid Restrict delete 
jatts_typeid_fk jiveattachsettings.typeid jivedoctype.typeid Restrict delete 
jattt_typeid_fk jiveattachtypes.typeid jivedoctype.typeid Restrict delete 
jattv_aid_fk jiveattachversion.attachmentid jiveattachment.attachmentid Restrict delete 
jattv_idocid_fk jiveattachversion.internaldocid jivedocument.internaldocid Restrict delete 
jbridgecontmsg_bdid_fk jivebridgedcontmsg.bridgedcontid jivebridgedcont.bridgedcontid Restrict delete 
jbridgeopt_bid_fk jivebridgeoption.bridgeid jivebridge.bridgeid Restrict delete 
jbtoken_fk_meta jivebintoken.binarymetadataid jivebinmetadata.binarymetadataid Restrict delete 
jcmmprp_cmtid_fk jivecommentprop.commentid jivecomment.commentid Restrict delete 
jcntntmtaprp_id_fk jivecontentmtprop.id jivecontentmeta.id Restrict delete 
jcp_cid_fk jivecommunityprop.communityid jivecommunity.communityid Restrict delete 
jd_exfileid_fk jivedocument.exstoragefileid jivestoragefile.exstoragefileid Restrict delete 
jd_typeid_fk jivedocument.typeid jivedoctype.typeid Restrict delete 
jdbc_typeid_fk jivedocbodyconfig.typeid jivedoctype.typeid Restrict delete 
jdbt_typeid_fk jivedocbodytypes.typeid jivedoctype.typeid Restrict delete 
jdbv_bid_fk jivedocbodyversion.bodyid jivedocumentbody.bodyid Restrict delete 
jdbv_idocid_fk jivedocbodyversion.internaldocid jivedocument.internaldocid Restrict delete 
jdc_idocid_fk jivedoccollab.internaldocid jivedocument.internaldocid Restrict delete 
jdprp_ildocid_fk jivedocumentprop.internaldocid jivedocument.internaldocid Restrict delete 
jdte_dtid_fk jivedoctypeelement.documenttypeid jivedoctype.typeid Restrict delete 
jdte_etid_fk jivedoctypeelement.elementtypeid jivedocelementtype.elementtypeid Restrict delete 
jdtprp_tid_fk jivedoctypeprop.typeid jivedoctype.typeid Restrict delete 
jdv_exfileversionid_fk jivedocversion.exstoragefileversionid jivestoragefileversion.exstoragefileversionid Restrict delete 
jdv_ildocid_fk jivedocversion.internaldocid jivedocument.internaldocid Restrict delete 
jdvcmmt_idocid_fk jivedocversioncmmt.internaldocid jivedocument.internaldocid Restrict delete 
jetag_fk_ouserid jiveexpertisetag.originuserid jiveuser.userid Restrict delete 
jetag_fk_tagid jiveexpertisetag.tagid jivetag.tagid Restrict delete 
jetag_fk_tuserid jiveexpertisetag.targetuserid jiveuser.userid Restrict delete 
jffprp_ftid_fk jivefieldfrmtprop.fieldtypeid jivefieldtype.fieldtypeid Restrict delete 
jfo_fid_fk jivefieldoption.fieldid jivefield.fieldid Restrict delete 
jft_dtid_fk jivefieldtype.datatypeid jivedatatype.datatypeid Restrict delete 
jfvprp_frid_fk jivefieldvldtrprop.fieldtypeid jivefieldtype.fieldtypeid Restrict delete 
jgrntprmlvl_prmid_fk jivegrantedpermlvl.permlevelid jivepermlevel.permlevelid Restrict delete 
jiv_idocid_fk jiveimageversion.internaldocid jivedocument.internaldocid Restrict delete 
jiv_iid_fk jiveimageversion.imageid jiveimage.imageid Restrict delete 
jive_tsid_fk jiveobjecttagset.tagsetid jivetagset.tagsetid Restrict delete 
jiveanswer_mid_fk jiveanswer.messageid jivemessage.messageid Restrict delete 
jiveanswer_tid_fk jiveanswer.threadid jivethread.threadid Restrict delete 
jiveappact_appid_fk jiveappaction.appid jiveapp.appid Restrict delete 
jiveappatxt_aid_fk jiveappactiontext.actionid jiveappaction.actionid Restrict delete 
jivebpp_bpid_fk jiveblogpostprop.blogpostid jiveblogpost.blogpostid Restrict delete 
jivebprp_bid_fk jiveblogprop.blogid jiveblog.blogid Restrict delete 
jivebpst_bid_fk jiveblogpost.blogid jiveblog.blogid Restrict delete 
jivecarcntnr_user_fk jivecarouselcontainer.userid jiveuser.userid Restrict delete 
jivedash_user_fk jivedashboard.userid jiveuser.userid Restrict delete 
jivedi_did_fk jivedraftimage.draftid jivedraft.draftid Restrict delete 
jivedi_iid_fk jivedraftimage.imageid jiveimage.imageid Restrict delete 
jivedp_did_fk jivedraftprop.draftid jivedraft.draftid Restrict delete 
jivedvrevst_fk jivedvrevstatus.revisionid jivedvrevision.revisionid Restrict delete 
jivedvrvar_fk jivedvrevartifact.revisionid jivedvrevision.revisionid Restrict delete 
jiveexpreq_requserid_fk jiveexportrequest.requestuserid jiveuser.userid Restrict delete 
jiveexpreq_taruserid_fk jiveexportrequest.targetuserid jiveuser.userid Restrict delete 
jivefield_ftype_fk jivefield.fieldtypeid jivefieldtype.fieldtypeid Restrict delete 
jivefollow_uid_fk jivefollow.userid jiveuser.userid Restrict delete 
jivegp_gid_fk jivegatewayprop.gatewayid jivegateway.gatewayid Restrict delete 
jiveinstapp_app_fk jiveinstanceapp.appid jiveapp.appid Restrict delete 
jiveoauth_appid_fk jiveoauthstore.instanceappid jiveinstanceapp.instanceappid Restrict delete 
jiveoauth_user_fk jiveoauthstore.userid jiveuser.userid Restrict delete 
jiveoauthacc_fk jiveoauthaccesslog.oauthtokenid jiveoauthtoken.oauthtokenid Restrict delete 
jiveoauthpass_fk jiveoauthpasscode.oauthtokenid jiveoauthtoken.oauthtokenid Restrict delete 
jiveobjapi_acc_fk jiveobjapiaccessor.accessorid jiveapiaccessor.accessorid Restrict delete 
jiveout_oid_fk jiveoutcomeprop.outcomeid jiveoutcome.outcomeid Restrict delete 
jivepaletteprop_fk jivepaletteprop.paletteid jivepalette.paletteid Restrict delete 
jivepcp_fk jivepcheckpoint.projectid jiveproject.projectid Restrict delete 
jivepfield_lid_fk jiveprofilefield.defaultseclvlid jiveprofileseclvl.levelid Restrict delete 
jivepfo_fid_fk jiveprofilefldopt.fieldid jiveprofilefield.fieldid Restrict delete 
jivepfsl_fid_fk jiveprofilefldsec.fieldid jiveprofilefield.fieldid Restrict delete 
jivepfsl_lid_fk jiveprofilefldsec.levelid jiveprofileseclvl.levelid Restrict delete 
jivepllop_pid_fk jivepolloption.pollid jivepoll.pollid Restrict delete 
jivepllvt_pid_fk jivepollvote.optionid jivepolloption.optionid Restrict delete 
jivepref_app_fk jiveinstapppref.instanceappid jiveinstanceapp.instanceappid Restrict delete 
jivequest_tid_fk jivequestion.threadid jivethread.threadid Restrict delete 
jivequestp_tid_fk jivequestionprop.threadid jivethread.threadid Restrict delete 
jivertcclbuser_collab_fk jivertccollaborationuser.collaborationid jivertccollaboration.collaborationid Restrict delete 
jivertcclbuser_user_fk jivertccollaborationuser.userid jiveuser.userid Restrict delete 
jivertccollab_user_fk jivertccollaboration.userid jiveuser.userid Restrict delete 
jivertcintperiod_collab_fk jivertcinteractionperiod.collaborationid jivertccollaboration.collaborationid Restrict delete 
jivertcintperiod_period_fk jivertccollabinteraction.periodid jivertcinteractionperiod.periodid Restrict delete 
jivertg_score_fk jiverating.score jiveratingtype.score Restrict delete 
jiveslide_user_fk jiveslide.userid jiveuser.userid Restrict delete 
jivestorageatt_container_fk jivestorageattachment.exstoragecontainerid jivestoragecontainer.exstoragecontainerid Restrict delete 
jivestoragecomment_comment_fk jivestoragecomment.jivecommentid jivecomment.commentid Restrict delete 
jivestoragecomment_file_fk jivestoragecomment.exstoragefileid jivestoragefile.exstoragefileid Restrict delete 
jivestoragecon_insid_fk jivestoragecontainer.exstorageinstanceid jivestorageinstance.instanceid Restrict delete 
jivestoragedefres_defid_fk jivestoragedefresource.definitionid jivestoragedefinition.definitionid Restrict delete 
jivestoragefile_container_fk jivestoragefile.exstoragecontainerid jivestoragecontainer.exstoragecontainerid Restrict delete 
jivestoragefileversion_file_fk jivestoragefileversion.exstoragefileid jivestoragefile.exstoragefileid Restrict delete 
jivestorageins_defid_fk jivestorageinstance.definitionid jivestoragedefinition.definitionid Restrict delete 
jivestorageinsconf_insid_fk jivestorageinsconfig.instanceid jivestorageinstance.instanceid Restrict delete 
jivestoragemem_container_fk jivestoragemember.exstoragecontainerid jivestoragecontainer.exstoragecontainerid Restrict delete 
jivestoragepre_container_fk jivestoragepreview.exstoragecontainerid jivestoragecontainer.exstoragecontainerid Restrict delete 
jivestrm_action_fk jivestreamaction.streamentryid jivestreamentry.streamentryid Restrict delete 
jivestrm_apprv_fk jivestreamapprover.streamentryid jivestreamentry.streamentryid Restrict delete 
jivestrm_prnt_fk jivestreamentry.streamchannelid jivestreamchannel.streamchannelid Restrict delete 
jivestrm_user_fk jivestreamentry.userid jiveuser.userid Restrict delete 
jivestrmprp_sid_fk jivestreamentprop.streamentryid jivestreamentry.streamentryid Restrict delete 
jivestrmtxt_sid_fk jivestreamenttext.streamentryid jivestreamentry.streamentryid Restrict delete 
jivetileinst_tile_fk jivetileinstance.tileid jivetile.tileid Restrict delete 
jivetiletp_tile_fk jivetiletmplassoc.tileid jivetile.tileid Restrict delete 
jivetiletp_tmpl_fk jivetiletmplassoc.templateid jivetiletemplate.templateid Restrict delete 
jivetsm_tsid_fk jivetagsetmap.tagsetid jivetagset.tagsetid Restrict delete 
jiveucntprp_uid_fk jiveusercontnrprop.usercontainerid jiveusercontainer.usercontainerid Restrict delete 
jiveucont_uid_fk jiveusercontainer.userid jiveuser.userid Restrict delete 
jiveup_fid_fk jiveuserprofile.fieldid jiveprofilefield.fieldid Restrict delete 
jiveup_lid_fk jiveuserprofile.levelid jiveprofileseclvl.levelid Restrict delete 
jivewebhookoauth2_fk jivewebhook.oauthcodeid jiveoauth2code.oauthcodeid Restrict delete 
jivewebhookqueue_fk jivewebhookqueue.hookid jivewebhook.hookid Restrict delete 
jivewlaytf_lid_fk jivewlayoutframe.layoutid jivewlayout.layoutid Restrict delete 
jm_threadid_fk jivemessage.threadid jivethread.threadid Restrict delete 
jmp_msgid_fk jivemessageprop.messageid jivemessage.messageid Restrict delete 
jpjtp_wsid_fk jiveprojectprop.projectid jiveproject.projectid Restrict delete 
jptaskp_tid_fk jiveptaskprop.taskid jiveptask.taskid Restrict delete 
jse_pid_dtid_fk jivesectionelement.parentid
jivesectionelement.documenttypeid
jivedoctypeelement.elementid
jivedoctypeelement.documenttypeid
Restrict delete 
jsgmem_gid_fk jivesgroupmember.groupid jivesgroup.groupid Restrict delete 
jsgmem_uid_fk jivesgroupmember.userid jiveuser.userid Restrict delete 
jsgroupp_gid_fk jivesgroupprop.groupid jivesgroup.groupid Restrict delete 
jtp_threadid_fk jivethreadprop.threadid jivethread.threadid Restrict delete 
jtvprp_tid_fk jivetypevldtrprop.typeid jivedoctype.typeid Restrict delete 
juid_uid_fk jiveuserimhandle.userid jiveuser.userid Restrict delete 
juser_userid_fk jivegroupuser.userid jiveuser.userid Restrict delete 
jvappalert_fk jiveappalert.appid jiveapp.appid Restrict delete 
jvappalert_inst_fk jiveappinstalert.instanceappid jiveinstanceapp.instanceappid Restrict delete 
jvappalertack_fk jiveappalertack.appalertid jiveappalert.appalertid Restrict delete 
jvappview_dash_fk jiveappview.dashboardid jivedashboard.dashboardid Restrict delete 
jvappview_inst_fk jiveappview.instanceappid jiveinstanceapp.instanceappid Restrict delete 
jvcstprmlvl_prmlvlid_fk jivecustompermlvl.permlevelid jivepermlevel.permlevelid Restrict delete 
jvcx_fk_endpoint jivecnxtconnection.serviceid jivecnxtendpoint.endpointid Restrict delete 
jvdfobjprmlvl_objprmlvlid_fk jivedefobjpermlvl.objpermlevelid jiveobjpermlvl.objpermlevelid Restrict delete 
jvep_fk_authstyle jivecnxtendpoint.authstyleid jivecnxtauthstyle.authstyleid Restrict delete 
jveptagjoin_fk_ep jiveeptagjoin.endpointid jivecnxtendpoint.endpointid Restrict delete 
jveptagjoin_fk_tag jiveeptagjoin.tagid jivecnxttag.tagid Restrict delete 
jvext_impexpid_fk jiveextension.deployerid jiveuser.userid Restrict delete 
jvextalt_impextid_fk jiveextensionalert.extensionid jiveextension.extensionid Restrict delete 
jvexti18n_impextid_fk jiveextensioni18n.extensionid jiveextension.extensionid Restrict delete 
jvexttag_impextid_fk jiveextensiontag.extensionid jiveextension.extensionid Restrict delete 
jvhdr_fk_endpoint jivecnxtsvcheader.serviceid jivecnxtendpoint.endpointid Restrict delete 
jvinvprop_invid_fk jiveinviteprop.invitationid jiveinvite.invitationid Restrict delete 
jvinvt_fk_usrid jiveinvite.userid jiveuser.userid Restrict delete 
jvlbl_fk_userid jivelabel.ownerid jiveuser.userid Restrict delete 
jvlblmap_fk_lstid jivelabelmap.labelid jivelabel.labelid Restrict delete 
jvlbltype_fk_lstid jivelabeltype.labelid jivelabel.labelid Restrict delete 
jvmetaocat_fk_metaid jiveocbtoken.binarymetadataid jiveocbmetadata.binarymetadataid Restrict delete 
jvoauth2codeclnt_fk jiveoauth2code.oauthclientid jiveoauth2client.oauthclientid Restrict delete 
jvoauth2codeusr_fk jiveoauth2code.userid jiveuser.userid Restrict delete 
jvobjprmlvlmp_ext_fk jiveobjpermlvlmap.extender jiveextcontext.contextid Restrict delete 
jvobjprmlvlmp_objprmlvlid_fk jiveobjpermlvlmap.objpermlevelid jiveobjpermlvl.objpermlevelid Restrict delete 
jvobjprmlvlmp_prmlvlid_fk jiveobjpermlvlmap.permlevelid jivepermlevel.permlevelid Restrict delete 
jvobjprmlvlmsk_ext_fk jiveobjpermlvlmsk.extender jiveextcontext.contextid Restrict delete 
jvobjprmlvlmsk_msk_fk jiveobjpermlvlmsk.mask jiveentitlementmsk.mask Restrict delete 
jvobjprmlvlmsk_objprmlvlid_fk jiveobjpermlvlmsk.objpermlevelid jiveobjpermlvl.objpermlevelid Restrict delete 
jvobjprmlvlxt_ext_fk jiveobjpermlvlext.extender jiveextcontext.contextid Restrict delete 
jvobjprmlvlxt_prmlvlid_fk jiveobjpermlvlext.objpermlevelid jiveobjpermlvl.objpermlevelid Restrict delete 
jvobjtplvlmsk_ext_fk jiveobjtypemsk.extender jiveextcontext.contextid Restrict delete 
jvobjtplvlmsk_msk_fk jiveobjtypemsk.mask jiveentitlementmsk.mask Restrict delete 
jvown_fk_endpoint jivecnxtsvcowner.serviceid jivecnxtendpoint.endpointid Restrict delete 
jvpjtstat_pjtid_fk jiveprojectstatus.projectid jiveproject.projectid Restrict delete 
jvprmlvlmsk_msk_fk jivepermlvlmsk.mask jiveentitlementmsk.mask Restrict delete 
jvprmlvlmsk_prmlvlid_fk jivepermlvlmsk.permlevelid jivepermlevel.permlevelid Restrict delete 
jvprop_fk_endpoint jivecnxtsvcprop.serviceid jivecnxtendpoint.endpointid Restrict delete 
jvurlst_fk_userid jiveusrrellist.userid jiveuser.userid Restrict delete 
jvurlstlm_fk_lstid jiveusrrellistmap.listid jiveusrrellist.listid Restrict delete 
jvurlstlm_fk_relid jiveusrrellistmap.relationshipid jiveuserrel.relationshipid Restrict delete 
jvusrocbm_fk_usid jiveocbmetadata.userid jiveuser.userid Restrict delete 
jvusrosfi_fk_usid jiveosfileitem.userid jiveuser.userid Restrict delete 
jvusrrel_fk_rlgrid jiveuserrel.graphid jiveuserrelgraph.graphid Restrict delete 
jvusrrel_fk_rlusid jiveuserrel.relateduserid jiveuser.userid Restrict delete 
jvusrrel_fk_usrid jiveuserrel.userid jiveuser.userid Restrict delete 
jvusrrelga_fk_grid jiveusrrelgrapr.graphid jiveuserrelgraph.graphid Restrict delete 
jvusrrelga_fk_usid jiveusrrelgrapr.userid jiveuser.userid Restrict delete 
jvusrrelnt_fk_grid jiveusrrelgrntf.graphid jiveuserrelgraph.graphid Restrict delete 
jvusrrelnt_fk_usid jiveusrrelgrntf.userid jiveuser.userid Restrict delete 
jwfcrstppv_id_fk jivewfcurrstepprev.id jivewfcurrentstep.id Restrict delete 
jwfcrstppv_pid_fk jivewfcurrstepprev.previousid jivewfhistorystep.id Restrict delete 
jwfcs_entid_fk jivewfcurrentstep.entryid jivewfentry.id Restrict delete 
jwfhisstp_entid_fk jivewfhistorystep.entryid jivewfentry.id Restrict delete 
jwfhisstppv_id_pk jivewfhiststepprev.id jivewfhistorystep.id Restrict delete 
jwfhisstppv_pid_fk jivewfhiststepprev.previousid jivewfhistorystep.id Restrict delete 
jwidgetf_wid_fk jivewidgetframe.widgetid jivewidget.widgetid Restrict delete 
jwidgetfp_fid_fk jivewidgetfrmprop.frameid jivewidgetframe.frameid Restrict delete 
oauth2client_fk jiveoauth2client.extensionid jiveextension.extensionid Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected