.

Generated using SQL Data Dictionary demo version.

Table dbo.UserProfile (6 rows)

	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)
- ProfileID

IX_UserProfile
- UserID

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:

dbo.ProfilePropertyDefinition
- PropertyDefinitionID
dbo.Users
- UserID

Used by:

Procedure
dbo.GetUserProfile
Procedure
dbo.UpdateUserProfileProperty
View
dbo.vw_Profile