[dbo].[NotificationValues]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	12:44:46 PM Thursday, October 04, 2007
Last Modified	12:44:46 PM Thursday, October 04, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

12:44:46 PM Thursday, October 04, 2007

Last Modified

12:44:46 PM Thursday, October 04, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK__NotificationValu__64CCF2AE: sequenceID\eventID\paramID\monitorID$	eventID	int	4
$Cluster Primary Key PK__NotificationValu__64CCF2AE: sequenceID\eventID\paramID\monitorID$	sequenceID	int	4
$Cluster Primary Key PK__NotificationValu__64CCF2AE: sequenceID\eventID\paramID\monitorID$ $Foreign Keys FK__NotificationValu__66B53B20: [dbo].[MonitorParams].monitorID\paramID$	monitorID	int	4
$Cluster Primary Key PK__NotificationValu__64CCF2AE: sequenceID\eventID\paramID\monitorID$ $Foreign Keys FK__NotificationValu__66B53B20: [dbo].[MonitorParams].monitorID\paramID$	paramID	int	4
	validParamValue	nvarchar(1024)	2048

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__NotificationValu__64CCF2AE: sequenceID\eventID\paramID\monitorID$

eventID

int

$Cluster Primary Key PK__NotificationValu__64CCF2AE: sequenceID\eventID\paramID\monitorID$

sequenceID

int

$Cluster Primary Key PK__NotificationValu__64CCF2AE: sequenceID\eventID\paramID\monitorID$ $Foreign Keys FK__NotificationValu__66B53B20: [dbo].[MonitorParams].monitorID\paramID$

monitorID

int

$Cluster Primary Key PK__NotificationValu__64CCF2AE: sequenceID\eventID\paramID\monitorID$ $Foreign Keys FK__NotificationValu__66B53B20: [dbo].[MonitorParams].monitorID\paramID$

paramID

int

validParamValue

nvarchar(1024)

2048

	Name	Columns	Unique
$Cluster Primary Key PK__NotificationValu__64CCF2AE: sequenceID\eventID\paramID\monitorID$	PK__NotificationValu__64CCF2AE	sequenceID, eventID, paramID, monitorID

Name

Columns

Unique

$Cluster Primary Key PK__NotificationValu__64CCF2AE: sequenceID\eventID\paramID\monitorID$

PK__NotificationValu__64CCF2AE

sequenceID, eventID, paramID, monitorID

Name	Columns
FK__Notificat__event__65C116E7	eventID->[dbo].[TriggeringEvent].[eventID]
FK__NotificationValu__66B53B20	monitorID->[dbo].[MonitorParams].[monitorID] paramID->[dbo].[MonitorParams].[paramID]

Name

Columns

FK__Notificat__event__65C116E7

eventID->[dbo].[TriggeringEvent].[eventID]

FK__NotificationValu__66B53B20

monitorID->[dbo].[MonitorParams].[monitorID]
paramID->[dbo].[MonitorParams].[paramID]

SQL Script

CREATE TABLE [dbo].[NotificationValues]
(
[eventID] [int] NOT NULL,
[sequenceID] [int] NOT NULL,
[monitorID] [int] NOT NULL,
[paramID] [int] NOT NULL,
[validParamValue] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NotificationValues] ADD CONSTRAINT [PK__NotificationValu__64CCF2AE] PRIMARY KEY CLUSTERED ([sequenceID], [eventID], [paramID], [monitorID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NotificationValues] ADD CONSTRAINT [FK__Notificat__event__65C116E7] FOREIGN KEY ([eventID]) REFERENCES [dbo].[TriggeringEvent] ([eventID])
GO
ALTER TABLE [dbo].[NotificationValues] ADD CONSTRAINT [FK__NotificationValu__66B53B20] FOREIGN KEY ([monitorID], [paramID]) REFERENCES [dbo].[MonitorParams] ([monitorID], [paramID])
GO