.

Generated using SQL Data Dictionary demo version.

Table dbo.UserRelationships (0 rows)

	Column	Data Type	Identity	Nullable	Default
PK	UserRelationshipID	int	X
UK , FK	UserID	int
UK , FK	RelatedUserID	int
UK , FK	RelationshipID	int
	Status	int
	CreatedByUserID	int
	CreatedOnDate	datetime			getdate()
	LastModifiedByUserID	int
	LastModifiedOnDate	datetime			getdate()

Indexes:

PK_UserRelationships
- (Primary Key)
- (Clustered)
- UserRelationshipID

IX_UserRelationships_UserID_RelatedUserID_RelationshipID
- (Unique)
- UserID
- RelatedUserID
- RelationshipID

IX_UserRelationships_RelatedUserID
- RelatedUserID

IX_UserRelationships_UserID
- UserID

References:

dbo.Relationships
- RelationshipID
dbo.Users
- UserID
dbo.Users
- UserID (RelatedUserID)

Used by:

Function
dbo.Journal_User_Permissions
Procedure
dbo.DeleteUserRelationship
Procedure
dbo.GetUserRelationship
Procedure
dbo.GetUserRelationships
Procedure
dbo.GetUserRelationshipsByMultipleIDs
Procedure
dbo.SaveUserRelationship