Generated using SQL Data Dictionary demo version.
| |
Column |
Data Type |
Identity |
Nullable |
Default |
| PK,
FK
|
UserId |
int |
|
|
|
| PK,
FK
|
PortalId |
int |
|
|
|
|
UserPortalId |
int |
X |
|
|
|
CreatedDate |
datetime |
|
|
getdate() |
|
Authorised |
bit |
|
|
1 |
|
IsDeleted |
bit |
|
|
0 |
|
RefreshRoles |
bit |
|
|
0 |
|
VanityUrl |
nvarchar(100) |
|
X |
|
Indexes:
-
PK_UserPortals
- (Primary Key)
- (Clustered)
-
IX_UserPortals
-
IX_UserPortals_PortalId_IsDeleted
-
IX_UserPortals_VanityUrl
- VanityUrl
- UserId
(Included)
- PortalId
(Included)
References:
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