Generated using SQL Data Dictionary demo version.
| |
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:
Used by:
- Procedure
dbo.DeleteUserRelationshipPreference
- Procedure
dbo.GetUserRelationshipPreference
- Procedure
dbo.GetUserRelationshipPreferenceByID
- Procedure
dbo.SaveUserRelationshipPreference