.

Generated using SQL Data Dictionary demo version.

Table dbo.EventLog (25 rows)

	Column	Data Type	Identity	Nullable	Default
	LogGUID	varchar(36)
FK	LogTypeKey	nvarchar(35)
FK	LogConfigID	int		X
	LogUserID	int		X
	LogUserName	nvarchar(50)		X
	LogPortalID	int		X
	LogPortalName	nvarchar(100)		X
	LogCreateDate	datetime
	LogServerName	nvarchar(50)
	LogProperties	ntext
	LogNotificationPending	bit		X
PK	LogEventID	bigint	X

Indexes:

PK_EventLogMaster
- (Primary Key)
- (Clustered)
- LogEventID

IX_EventLog_LogConfigID
- LogConfigID
- LogNotificationPending
- LogCreateDate
- LogEventID (Included)

IX_EventLog_LogCreateDate
- LogCreateDate
- LogConfigID (Included)

IX_EventLog_LogGUID
- LogGUID

IX_EventLog_LogType
- LogTypeKey
- LogPortalID

References:

dbo.EventLogConfig
- ID (LogConfigID)
dbo.EventLogTypes
- LogTypeKey

Used by:

Procedure
dbo.AddEventLog
Procedure
dbo.DeleteEventLog
Procedure
dbo.GetEventLog
Procedure
dbo.GetEventLogByLogGUID
Procedure
dbo.GetEventLogPendingNotif
Procedure
dbo.GetEventLogPendingNotifConfig
Procedure
dbo.PurgeEventLog
Procedure
dbo.UpdateEventLogPendingNotif