[dbo].[ToolInstanceLogEventJoin]

(local) > SupportBridge > Tables > dbo.ToolInstanceLogEventJoin

Properties
Columns
Indexes
SQL Script
Uses

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

Columns

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key pk_TILEventJoin: toolInstanceLogID\eventID$	toolInstanceLogID	int	4
$Cluster Primary Key pk_TILEventJoin: toolInstanceLogID\eventID$	eventID	decimal(28,0)	13

Indexes

	Name	Columns	Unique
$Cluster Primary Key pk_TILEventJoin: toolInstanceLogID\eventID$	pk_TILEventJoin	toolInstanceLogID, eventID

SQL Script

CREATE TABLE [dbo].[ToolInstanceLogEventJoin]
(
[toolInstanceLogID] [int] NOT NULL,
[eventID] [decimal] (28, 0) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ToolInstanceLogEventJoin] ADD CONSTRAINT [pk_TILEventJoin] PRIMARY KEY CLUSTERED ([toolInstanceLogID], [eventID]) ON [PRIMARY]
GO

Uses