Skip to main content

Foreign Key Reference

Complete Foreign Key Listing

FK NameParent TableParent ColumnsReferenced TableReferenced ColumnsOn Delete
FK_SA_FSAA_ImportHistory_HOSTSA_FSAA_ImportHistoryHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAA_Trustees_HOSTSA_FSAA_TrusteesHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAA_LocalTrustees_IDSA_FSAA_LocalTrusteesHOST, IDSA_FSAA_TrusteesHOST, IDCASCADE
FK_SA_FSAA_TrusteeEquivalence_TrusteeIDSA_FSAA_TrusteeEquivalenceHOST, TrusteeIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAA_TrusteeEquivalence_EquivalentTrusteeIDSA_FSAA_TrusteeEquivalenceHOST, EquivalentTrusteeIDSA_FSAA_LocalTrusteesHOST, IDCASCADE
FK_SA_FSAA_Rights_TrusteeIDSA_FSAA_RightsHOST, TrusteeIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAA_Tags_HOSTSA_FSAA_TagsHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAA_TagKeys_HOSTSA_FSAA_TagKeysHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAA_TagProxies_HOSTSA_FSAA_TagProxiesHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAA_TagProxies_TagProxyIDSA_FSAA_TagProxiesHOST, TagProxyIDSA_FSAA_TagKeysHOST, TagProxyIDNO ACTION
FK_SA_FSAA_TagProxies_TagIDSA_FSAA_TagProxiesHOST, TagIDSA_FSAA_TagsHOST, TagIDNO ACTION
FK_SA_FSAA_Resources_HOSTSA_FSAA_ResourcesHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAA_Resources_ParentResourceIDSA_FSAA_ResourcesHOST, ParentResourceIDSA_FSAA_ResourcesHOST, IDNO ACTION
FK_SA_FSAA_Resources_OwnerIDSA_FSAA_ResourcesHOST, OwnerIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAA_UnixRights_ResourceIDSA_FSAA_UnixRightsHOST, ResourceIDSA_FSAA_ResourcesHOST, IDCASCADE
FK_SA_FSAA_UnixRights_OwnerIDSA_FSAA_UnixRightsHOST, OwnerIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAA_UnixRights_GroupIDSA_FSAA_UnixRightsHOST, GroupIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAA_Gates_HOSTSA_FSAA_GatesHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAA_Gates_ShareIDSA_FSAA_GatesHOST, ShareIDSA_FSAA_ResourcesHOST, IDNO ACTION
FK_SA_FSAA_Gates_FolderIDSA_FSAA_GatesHOST, FolderIDSA_FSAA_ResourcesHOST, IDNO ACTION
FK_SA_FSAA_Gates_PolicyIDSA_FSAA_GatesHOST, PolicyIDSA_FSAA_GatesHOST, IDNO ACTION
FK_SA_FSAA_GatesProxy_GateIDSA_FSAA_GatesProxyHOST, GateIDSA_FSAA_GatesHOST, IDCASCADE
FK_SA_FSAA_Policies_PolicyIDSA_FSAA_PoliciesHOST, PolicyIDSA_FSAA_GatesHOST, IDCASCADE
FK_SA_FSAA_Policies_TrusteeIDSA_FSAA_PoliciesHOST, TrusteeIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAA_Exceptions_HOSTSA_FSAA_ExceptionsHOSTSA_FSAA_HostsIDNO ACTION
FK_SA_FSAA_Exceptions_GateIDSA_FSAA_ExceptionsHOST, GateIDSA_FSAA_GatesHOST, IDCASCADE
FK_SA_FSAA_Exceptions_ResourceIDSA_FSAA_ExceptionsHOST, ResourceIDSA_FSAA_ResourcesHOST, IDNO ACTION
FK_SA_FSAA_Exceptions_TrusteeIDSA_FSAA_ExceptionsHOST, TrusteeIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAA_Exceptions_SourceTrusteeIDSA_FSAA_ExceptionsHOST, SourceTrusteeIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAA_ExceptionTypes_HOSTSA_FSAA_ExceptionTypesHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAA_ProbableOwners_HOSTSA_FSAA_ProbableOwnersHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAA_ProbableOwners_ResourceIDSA_FSAA_ProbableOwnersHOST, ResourceIDSA_FSAA_ResourcesHOST, IDNO ACTION
FK_SA_FSAA_ProbableOwners_OwnerIDSA_FSAA_ProbableOwnersHOST, OwnerIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAA_FileSizes_ResourceIDSA_FSAA_FileSizesHOST, ResourceIDSA_FSAA_ResourcesHOST, IDCASCADE
FK_SA_FSAA_FileTypes_ResourceIDSA_FSAA_FileTypesHOST, ResourceIDSA_FSAA_ResourcesHOST, IDCASCADE
FK_SA_FSAA_FileAges_ResourceIDSA_FSAA_FileAgesHOST, ResourceIDSA_FSAA_ResourcesHOST, IDCASCADE
FK_SA_FSAA_FileTags_ResourceIDSA_FSAA_FileTagsHOST, ResourceIDSA_FSAA_ResourcesHOST, IDCASCADE
FK_SA_FSAA_FileTags_TagProxyIDSA_FSAA_FileTagsHOST, TagProxyIDSA_FSAA_TagKeysHOST, TagProxyIDNO ACTION
FK_SA_FSAC_ProcessNames_HOSTSA_FSAC_ProcessNamesHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAC_ActivityEvents_HOSTSA_FSAC_ActivityEventsHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAC_ActivityEvents_PathIDSA_FSAC_ActivityEventsHOST, PathIDSA_FSAA_ResourcesHOST, IDNO ACTION
FK_SA_FSAC_ActivityEvents_ProcessIDSA_FSAC_ActivityEventsHOST, ProcessIDSA_FSAC_ProcessNamesHOST, IDNO ACTION
FK_SA_FSAC_ActivityEvents_TrusteeIDSA_FSAC_ActivityEventsHOST, TrusteeIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAC_PermissionChanges_HOSTSA_FSAC_PermissionChangesHOSTSA_FSAA_HostsIDNO ACTION
FK_SA_FSAC_PermissionChanges_ActivityIDSA_FSAC_PermissionChangesHOST, ActivityIDSA_FSAC_ActivityEventsHOST, IDNO ACTION
FK_SA_FSAC_PermissionChanges_TrusteeIDSA_FSAC_PermissionChangesHOST, TrusteeIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAC_OwnerChanges_HOSTSA_FSAC_OwnerChangesHOSTSA_FSAA_HostsIDNO ACTION
FK_SA_FSAC_OwnerChanges_ActivityIDSA_FSAC_OwnerChangesHOST, ActivityIDSA_FSAC_ActivityEventsHOST, IDNO ACTION
FK_SA_FSAC_OwnerChanges_PreviousOwnerIDSA_FSAC_OwnerChangesHOST, PreviousOwnerIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAC_OwnerChanges_NewOwnerIDSA_FSAC_OwnerChangesHOST, NewOwnerIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAC_DailyActivity_HOSTSA_FSAC_DailyActivityHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAC_DailyActivity_FolderIDSA_FSAC_DailyActivityHOST, FolderIDSA_FSAA_ResourcesHOST, IDNO ACTION
FK_SA_FSAC_DailyActivity_TrusteeIDSA_FSAC_DailyActivityHOST, TrusteeIDSA_FSAA_TrusteesHOST, IDNO ACTION
FK_SA_FSAC_RenameTargets_HOSTSA_FSAC_RenameTargetsHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSAC_RenameTargets_ActivityIDSA_FSAC_RenameTargetsHOST, ActivityIDSA_FSAC_ActivityEventsHOST, IDNO ACTION
FK_SA_FSAC_RenameTargets_TargetPathIDSA_FSAC_RenameTargetsHOST, TargetPathIDSA_FSAA_ResourcesHOST, IDNO ACTION
FK_SA_FSDLP_ImportHistory_HOSTSA_FSDLP_ImportHistoryHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSDLP_Criteria_HOSTSA_FSDLP_CriteriaHOSTSA_FSAA_HostsIDCASCADE
FK_SA_FSDLP_Matches_CriteriaIdSA_FSDLP_MatchesHOST, CriteriaIdSA_FSDLP_CriteriaHOST, IDCASCADE
FK_SA_FSDLP_MatchHits_MatchSA_FSDLP_MatchHitsHOST, FileId, CriteriaIdSA_FSDLP_MatchesHOST, FileId, CriteriaIdCASCADE
FK_SA_FSDLP_MatchHits_SubjectProfileSA_FSDLP_MatchHits_SubjectProfileHOST, FileId, CriteriaId, IDSA_FSDLP_MatchHitsHOST, FileId, CriteriaId, IDCASCADE
FK_SA_FSDLP_MatchHits_SubjectProfile_SourceSA_FSDLP_MatchHits_SubjectProfileSourceIdSA_SubjectProfile_SourcesIdNO ACTION
FK_SA_FSDLP_MatchHits_SubjectProfile_IdentitySA_FSDLP_MatchHits_SubjectProfileIdentityIdSA_SubjectProfile_IdentitiesIdNO ACTION
FK_SA_FSDLP_MatchHits_SubjectProfile_AttributeSA_FSDLP_MatchHits_SubjectProfileIdentityId, AttributeId, OrderSA_SubjectProfile_AttributeValuesIdentityId, AttributeId, OrderCASCADE
FK_SA_FSDFS_Namespaces_HostsSA_FSDFS_NamespacesRootHostIDSA_FSAA_HostsIDCASCADE
FK_SA_FSDFS_Namespaces_GateIDSA_FSDFS_NamespacesRootHostID, RootGateIDSA_FSAA_GatesHOST, IDNO ACTION
FK_SA_FSDFS_Links_NamespaceIDSA_FSDFS_LinksNamespaceIDSA_FSDFS_NamespacesIDCASCADE
FK_SA_FSDFS_Links_TargetHostIDSA_FSDFS_LinksTargetHostIDSA_FSAA_HostsIDNO ACTION
FK_SA_FSDFS_Links_TargetGateIDSA_FSDFS_LinksTargetHostID, TargetGateIDSA_FSAA_GatesHOST, IDNO ACTION
FK_SA_FSDFS_Links_TargetResourceIDSA_FSDFS_LinksTargetHostID, TargetResourceIDSA_FSAA_ResourcesHOST, IDNO ACTION
FK_SA_FSDFS_Links_DfsResourceIDSA_FSDFS_LinksDfsHostID, DfsResourceIDSA_FSAA_ResourcesHOST, IDNO ACTION