.

Generated using SQL Data Dictionary demo version.

Table dbo.Relationships (2 rows)

	Column	Data Type	Identity	Nullable	Default
PK	RelationshipID	int	X
FK	RelationshipTypeID	int
	Name	nvarchar(50)
	Description	nvarchar(500)		X
FK	PortalID	int		X
FK	UserID	int		X
	DefaultResponse	int
	CreatedByUserID	int
	CreatedOnDate	datetime			getdate()
	LastModifiedByUserID	int
	LastModifiedOnDate	datetime			getdate()

Indexes:

PK_Relationships
- (Primary Key)
- (Clustered)
- RelationshipID

IX_Relationships_UserID
- UserID

References:

dbo.Portals
- PortalID
dbo.RelationshipTypes
- RelationshipTypeID
dbo.Users
- UserID

Referenced by:

dbo.UserRelationshipPreferences
- RelationshipID
dbo.UserRelationships
- RelationshipID

Used by:

Function
dbo.Journal_User_Permissions
Procedure
dbo.DeleteRelationship
Procedure
dbo.GetRelationship
Procedure
dbo.GetRelationshipsByPortalID
Procedure
dbo.GetRelationshipsByUserID
Procedure
dbo.SaveRelationship