Generated using SQL Data Dictionary demo version.
| |
Column |
Data Type |
Identity |
Nullable |
Default |
| PK |
UserID |
int |
X |
|
|
|
UK
|
Username |
nvarchar(100) |
|
|
|
|
FirstName |
nvarchar(50) |
|
|
|
|
LastName |
nvarchar(50) |
|
|
|
|
IsSuperUser |
bit |
|
|
0 |
|
AffiliateId |
int |
|
X |
|
|
Email |
nvarchar(256) |
|
X |
|
|
DisplayName |
nvarchar(128) |
|
|
'' |
|
UpdatePassword |
bit |
|
|
0 |
|
LastIPAddress |
nvarchar(50) |
|
X |
|
|
IsDeleted |
bit |
|
|
0 |
|
CreatedByUserID |
int |
|
X |
|
|
CreatedOnDate |
datetime |
|
X |
|
|
LastModifiedByUserID |
int |
|
X |
|
|
LastModifiedOnDate |
datetime |
|
X |
|
|
PasswordResetToken |
uniqueidentifier |
|
X |
|
|
PasswordResetExpiration |
datetime |
|
X |
|
|
LowerEmail |
nvarchar(256) |
|
X |
|
Indexes:
-
PK_Users
- (Primary Key)
- (Clustered)
-
IX_Users
-
IX_Users_Email
-
IX_Users_IsDeleted_DisplayName
- IsDeleted
- DisplayName
- UserID
(Included)
- IsSuperUser
(Included)
- Email
(Included)
-
IX_Users_LastModifiedOnDate
- LastModifiedOnDate
(Descending)
- UserID
(Included)
- IsSuperUser
(Included)
-
IX_Users_LowerEmail
Referenced by:
Used by:
- Function
dbo.Journal_User_Permissions
- Function
dbo.UserDisplayName
- Procedure
dbo.AddUser
- Procedure
dbo.ChangeUsername
- Procedure
dbo.DeleteUserPortal
- Procedure
dbo.GetAllHtmlText
- Procedure
dbo.GetBanner
- Procedure
dbo.GetFoldersByPermissions
- Procedure
dbo.GetHtmlText
- Procedure
dbo.GetHtmlTextLog
- Procedure
dbo.GetOnlineUser
- Procedure
dbo.GetServices
- Procedure
dbo.GetSiteLog2
- Procedure
dbo.GetSiteLog3
- Procedure
dbo.GetTopHtmlText
- Procedure
dbo.GetUsersByRolename
- Procedure
dbo.GetVendor
- Procedure
dbo.Journal_Comment_Get
- Procedure
dbo.Journal_Comment_List
- Procedure
dbo.Journal_Comment_ListByJournalIds
- Procedure
dbo.Journal_Get
- Procedure
dbo.Journal_GetByKey
- Procedure
dbo.Journal_GetSearchItems
- Procedure
dbo.Journal_LikeList
- Procedure
dbo.Journal_ListForGroup
- Procedure
dbo.Journal_ListForProfile
- Procedure
dbo.Journal_ListForSummary
- Procedure
dbo.Messaging_Save_Message
- Procedure
dbo.RemoveUser
- Procedure
dbo.RestoreUser
- Procedure
dbo.UpdateOnlineUser
- Procedure
dbo.UpdateUser
- View
- View
- View
- View
- View
- View
- View
- View