[dbo].[GroupToolInvocations]

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

306

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_GpToolInv: groupID\toolID\toolInstanceID\toolStartEpoch$	groupID	int	4
$Cluster Primary Key pk_GpToolInv: groupID\toolID\toolInstanceID\toolStartEpoch$	toolID	int	4
$Cluster Primary Key pk_GpToolInv: groupID\toolID\toolInstanceID\toolStartEpoch$	toolInstanceID	int	4
$Cluster Primary Key pk_GpToolInv: groupID\toolID\toolInstanceID\toolStartEpoch$	toolStartEpoch	decimal(13,0)	9
	toolStartTime	nvarchar(50)	100
	toolInstanceLogID	int	4
	extraData	nvarchar(100)	200

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_GpToolInv: groupID\toolID\toolInstanceID\toolStartEpoch$

groupID

int

$Cluster Primary Key pk_GpToolInv: groupID\toolID\toolInstanceID\toolStartEpoch$

toolID

int

$Cluster Primary Key pk_GpToolInv: groupID\toolID\toolInstanceID\toolStartEpoch$

toolInstanceID

int

$Cluster Primary Key pk_GpToolInv: groupID\toolID\toolInstanceID\toolStartEpoch$

toolStartEpoch

decimal(13,0)

toolStartTime

nvarchar(50)

100

toolInstanceLogID

int

extraData

nvarchar(100)

200

	Name	Columns	Unique
$Cluster Primary Key pk_GpToolInv: groupID\toolID\toolInstanceID\toolStartEpoch$	pk_GpToolInv	groupID, toolID, toolInstanceID, toolStartEpoch

Name

Columns

Unique

$Cluster Primary Key pk_GpToolInv: groupID\toolID\toolInstanceID\toolStartEpoch$

pk_GpToolInv

groupID, toolID, toolInstanceID, toolStartEpoch

SQL Script

CREATE TABLE [dbo].[GroupToolInvocations]
(
[groupID] [int] NOT NULL,
[toolID] [int] NOT NULL,
[toolInstanceID] [int] NOT NULL,
[toolStartEpoch] [decimal] (13, 0) NOT NULL,
[toolStartTime] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[toolInstanceLogID] [int] NULL,
[extraData] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupToolInvocations] ADD CONSTRAINT [pk_GpToolInv] PRIMARY KEY CLUSTERED ([groupID], [toolID], [toolInstanceID], [toolStartEpoch]) ON [PRIMARY]
GO