Generated using SQL Data Dictionary demo version.
| |
Column |
Data Type |
Identity |
Nullable |
Default |
| PK |
ProfileID |
int |
X |
|
|
|
FK
|
UserID |
int |
|
|
|
|
FK
|
PropertyDefinitionID |
int |
|
|
|
|
PropertyValue |
nvarchar(3750) |
|
X |
|
|
PropertyText |
nvarchar(max) |
|
X |
|
|
Visibility |
int |
|
|
0 |
|
LastUpdatedDate |
datetime |
|
|
|
|
ExtendedVisibility |
varchar(400) |
|
X |
|
Indexes:
-
PK_UserProfile
- (Primary Key)
- (Clustered)
-
IX_UserProfile
-
IX_UserProfile_LastUpdatedDate
- LastUpdatedDate
(Descending)
- UserID
(Included)
-
IX_UserProfile_PropertyDefinitionID
- PropertyDefinitionID
- ProfileID
(Included)
- UserID
(Included)
- PropertyValue
(Included)
-
IX_UserProfile_UserID_PropertyDefinitionID
- UserID
- PropertyDefinitionID
-
IX_UserProfile_Visibility
- UserID
- ProfileID
- PropertyDefinitionID
(Included)
- PropertyValue
(Included)
- PropertyText
(Included)
- Visibility
(Included)
- LastUpdatedDate
(Included)
- ExtendedVisibility
(Included)
References:
Used by:
- Procedure
dbo.GetUserProfile
- Procedure
dbo.UpdateUserProfileProperty
- View