[dbo].[GroupHistory]

(local) > SupportBridge > Tables > dbo.GroupHistory

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Row Count	116
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)
$Cluster Primary Key pk_groupHistory: groupID\sessionID$	groupID	int	4
	startEpoch	decimal(18,0)	9
	endEpoch	decimal(18,0)	9
$Cluster Primary Key pk_groupHistory: groupID\sessionID$	sessionID	int	4

Indexes

	Name	Columns	Unique
$Cluster Primary Key pk_groupHistory: groupID\sessionID$	pk_groupHistory	groupID, sessionID

SQL Script

CREATE TABLE [dbo].[GroupHistory]
(
[groupID] [int] NOT NULL,
[startEpoch] [decimal] (18, 0) NOT NULL,
[endEpoch] [decimal] (18, 0) NOT NULL,
[sessionID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupHistory] ADD CONSTRAINT [pk_groupHistory] PRIMARY KEY CLUSTERED ([groupID], [sessionID]) ON [PRIMARY]
GO

Uses