.

Generated using SQL Data Dictionary demo version.

Table dbo.EventLogConfig (119 rows)

	Column	Data Type	Identity	Nullable	Default
PK	ID	int	X
UK , FK	LogTypeKey	nvarchar(35)		X
UK	LogTypePortalID	int		X
	LoggingIsActive	bit
	KeepMostRecent	int
	EmailNotificationIsActive	bit
	NotificationThreshold	int		X
	NotificationThresholdTime	int		X
	NotificationThresholdTimeType	int		X
	MailFromAddress	nvarchar(50)
	MailToAddress	nvarchar(50)

Indexes:

PK_EventLogConfig
- (Primary Key)
- (Clustered)
- ID

IX_LogTypeKey_LogTypePortalID
- (Unique)
- LogTypeKey
- LogTypePortalID

References:

dbo.EventLogTypes
- LogTypeKey

Referenced by:

dbo.EventLog
- LogConfigID (ID)

Used by:

Procedure
dbo.AddEventLog
Procedure
dbo.AddEventLogConfig
Procedure
dbo.DeleteEventLogConfig
Procedure
dbo.GetEventLogConfig
Procedure
dbo.GetEventLogPendingNotifConfig
Procedure
dbo.PurgeEventLog
Procedure
dbo.SaveCoreAuditTypes
Procedure
dbo.UpdateEventLogConfig