.

Generated using SQL Data Dictionary demo version.

Table dbo.UrlTracking (0 rows)

	Column	Data Type	Identity	Nullable	Default
PK	UrlTrackingID	int	X
UK , FK	PortalID	int		X
UK	Url	nvarchar(255)
	UrlType	char(1)
	Clicks	int
	LastClick	datetime		X
	CreatedDate	datetime
	LogActivity	bit
	TrackClicks	bit			1
UK	ModuleId	int		X
	NewWindow	bit			0

Indexes:

PK_UrlTracking
- (Primary Key)
- (Clustered)
- UrlTrackingID

IX_UrlTracking
- (Unique)
- PortalID
- Url
- ModuleId

IX_UrlTracking_ModuleId
- ModuleId

IX_UrlTracking_Url_ModuleId
- Url
- ModuleId
- TrackClicks (Included)
- NewWindow (Included)

References:

dbo.Portals
- PortalID

Referenced by:

dbo.UrlLog
- UrlTrackingID

Used by:

Procedure
dbo.AddUrlTracking
Procedure
dbo.DeleteUrlTracking
Procedure
dbo.GetUrlTracking
Procedure
dbo.UpdateUrlTracking
Procedure
dbo.UpdateUrlTrackingStats