[dbo].[EventHistoryParams]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	36205
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

36205

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_EventHistoryParams: eventID\paramID$	eventID	decimal(28,0)	13
$Cluster Primary Key pk_EventHistoryParams: eventID\paramID$	paramID	int	4
	paramValue	ntext	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_EventHistoryParams: eventID\paramID$

eventID

decimal(28,0)

$Cluster Primary Key pk_EventHistoryParams: eventID\paramID$

paramID

int

paramValue

ntext

max

	Name	Columns	Unique
$Cluster Primary Key pk_EventHistoryParams: eventID\paramID$	pk_EventHistoryParams	eventID, paramID

Name

Columns

Unique

$Cluster Primary Key pk_EventHistoryParams: eventID\paramID$

pk_EventHistoryParams

eventID, paramID

Name	Columns
fk_EHP_eventID	eventID->[dbo].[EventHistory].[eventID]
fk_EHP_paramID	paramID->[dbo].[EventTypeParams].[paramID]

Name

Columns

fk_EHP_eventID

eventID->[dbo].[EventHistory].[eventID]

fk_EHP_paramID

paramID->[dbo].[EventTypeParams].[paramID]

SQL Script

CREATE TABLE [dbo].[EventHistoryParams]
(
[eventID] [decimal] (28, 0) NOT NULL,
[paramID] [int] NOT NULL,
[paramValue] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventHistoryParams] ADD CONSTRAINT [pk_EventHistoryParams] PRIMARY KEY CLUSTERED ([eventID], [paramID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventHistoryParams] ADD CONSTRAINT [fk_EHP_eventID] FOREIGN KEY ([eventID]) REFERENCES [dbo].[EventHistory] ([eventID])
GO
ALTER TABLE [dbo].[EventHistoryParams] ADD CONSTRAINT [fk_EHP_paramID] FOREIGN KEY ([paramID]) REFERENCES [dbo].[EventTypeParams] ([paramID])
GO