.

Generated using SQL Data Dictionary demo version.

Table dbo.UserAuthentication (0 rows)

	Column	Data Type	Identity	Nullable	Default
PK	UserAuthenticationID	int	X
UK , FK	UserID	int
UK	AuthenticationType	nvarchar(100)
	AuthenticationToken	nvarchar(1000)
	CreatedByUserID	int		X
	CreatedOnDate	datetime		X
	LastModifiedByUserID	int		X
	LastModifiedOnDate	datetime		X

Indexes:

PK_UserAuthentication
- (Primary Key)
- (Clustered)
- UserAuthenticationID

IX_UserAuthentication
- (Unique)
- UserID
- AuthenticationType

References:

dbo.Users
- UserID

Used by:

Procedure
dbo.AddUserAuthentication
Procedure
dbo.DeleteAuthentication
Procedure
dbo.GetUserAuthentication
Procedure
dbo.GetUserByAuthToken