Generated using SQL Data Dictionary demo version.
| |
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)
-
IX_UrlTracking
-
IX_UrlTracking_ModuleId
-
IX_UrlTracking_Url_ModuleId
- Url
- ModuleId
- TrackClicks
(Included)
- NewWindow
(Included)
References:
Referenced by:
Used by:
- Procedure
dbo.AddUrlTracking
- Procedure
dbo.DeleteUrlTracking
- Procedure
dbo.GetUrlTracking
- Procedure
dbo.UpdateUrlTracking
- Procedure
dbo.UpdateUrlTrackingStats