Generated using SQL Data Dictionary demo version.

Table dbo.UserPortals (1 row)

Indexes:

• PK_UserPortals

  • (Primary Key)
  • (Clustered)
  
  
  
  • UserId
  • PortalId



• IX_UserPortals

  
  
  
  • PortalId



• IX_UserPortals_PortalId_IsDeleted

  
  
  
  • PortalId
  • IsDeleted



• IX_UserPortals_VanityUrl

  
  
  
  • VanityUrl
  • UserId (Included)
  • PortalId (Included)

References:

• dbo.Portals

  
  
  
  • PortalID (PortalId)
  
  

• dbo.Users

  
  
  
  • UserID (UserId)
  
  

Used by:

• Procedure 

  dbo.AddUser

  
  
  
• Procedure 

  dbo.AddUserPortal

  
  
  
• Procedure 

  dbo.DeleteUserPortal

  
  
  
• Procedure 

  dbo.GetOnlineUsers

  
  
  
• Procedure 

  dbo.GetPortalsByUser

  
  
  
• Procedure 

  dbo.GetUserCountByPortal

  
  
  
• Procedure 

  dbo.GetUsersByRolename

  
  
  
• Procedure 

  dbo.RemoveUser

  
  
  
• Procedure 

  dbo.RestoreUser

  
  
  
• Procedure 

  dbo.UpdateUser

  
  
  
• View 

  dbo.vw_Users