.

Generated using SQL Data Dictionary demo version.

Table dbo.UserRelationshipPreferences (0 rows)

	Column	Data Type	Identity	Nullable	Default
PK	PreferenceID	int	X
FK	UserID	int
PK, FK	RelationshipID	int
	DefaultResponse	int
	CreatedByUserID	int
	CreatedOnDate	datetime			getdate()
	LastModifiedByUserID	int
	LastModifiedOnDate	datetime			getdate()

Indexes:

PK_UserRelationshipPreferences
- (Primary Key)
- (Clustered)
- PreferenceID
- RelationshipID

References:

dbo.Relationships
- RelationshipID
dbo.Users
- UserID

Used by:

Procedure
dbo.DeleteUserRelationshipPreference
Procedure
dbo.GetUserRelationshipPreference
Procedure
dbo.GetUserRelationshipPreferenceByID
Procedure
dbo.SaveUserRelationshipPreference