[dbo].[EventHistory]

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

Property

Value

Row Count

13907

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)	Identity
	eventID	decimal(28,0)	13	1 - 1
$Indexes EventHistory2: eventType\eventEpoch$	eventEpoch	decimal(18,0)	9
$Indexes EventHistory2: eventType\eventEpoch$	eventType	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

eventID

decimal(28,0)

1 - 1

$Indexes EventHistory2: eventType\eventEpoch$

eventEpoch

decimal(18,0)

$Indexes EventHistory2: eventType\eventEpoch$

eventType

int

	Name	Columns	Unique
	pk_EventHistory	eventID
	EventHistory1	eventEpoch
	EventHistory2	eventType, eventEpoch

Name

Columns

Unique

pk_EventHistory

eventID

EventHistory1

eventEpoch

EventHistory2

eventType, eventEpoch

Name	Columns
fk_EventHistory	eventType->[dbo].[EventTypes].[eventType]

Name

Columns

fk_EventHistory

eventType->[dbo].[EventTypes].[eventType]

SQL Script

CREATE TABLE [dbo].[EventHistory]
(
[eventID] [decimal] (28, 0) NOT NULL IDENTITY(1, 1),
[eventEpoch] [decimal] (18, 0) NOT NULL,
[eventType] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventHistory] ADD CONSTRAINT [pk_EventHistory] PRIMARY KEY CLUSTERED ([eventID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [EventHistory1] ON [dbo].[EventHistory] ([eventEpoch]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [EventHistory2] ON [dbo].[EventHistory] ([eventType], [eventEpoch]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventHistory] ADD CONSTRAINT [fk_EventHistory] FOREIGN KEY ([eventType]) REFERENCES [dbo].[EventTypes] ([eventType])
GO