Generated using SQL Data Dictionary demo version.
| |
Column |
Data Type |
Identity |
Nullable |
Default |
| PK |
SiteLogId |
int |
X |
|
|
|
DateTime |
smalldatetime |
|
|
|
|
FK
|
PortalId |
int |
|
|
|
|
UserId |
int |
|
X |
|
|
Referrer |
nvarchar(255) |
|
X |
|
|
Url |
nvarchar(255) |
|
X |
|
|
UserAgent |
nvarchar(255) |
|
X |
|
|
UserHostAddress |
nvarchar(255) |
|
X |
|
|
UserHostName |
nvarchar(255) |
|
X |
|
|
TabId |
int |
|
X |
|
|
AffiliateId |
int |
|
X |
|
Indexes:
-
PK_SiteLog
- (Primary Key)
- (Clustered)
-
IX_SiteLog
References:
Used by:
- Procedure
dbo.AddSiteLog
- Procedure
dbo.DeleteSiteLog
- Procedure
dbo.GetSiteLog1
- Procedure
dbo.GetSiteLog12
- Procedure
dbo.GetSiteLog2
- Procedure
dbo.GetSiteLog3
- Procedure
dbo.GetSiteLog4
- Procedure
dbo.GetSiteLog5
- Procedure
dbo.GetSiteLog6
- Procedure
dbo.GetSiteLog7
- Procedure
dbo.GetSiteLog8
- Procedure
dbo.GetSiteLog9