[dbo].[VirtualSessions]

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

Property

Value

Row Count

150

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
virtualSessionID	int	4	1 - 1
queueID	int	4
userID	int	4
sessionID	int	4
queuedEpoch	decimal(28,0)	13
handledEpoch	decimal(28,0)	13
endEpoch	decimal(28,0)	13
waitTime	decimal(28,0)	13
handledTime	decimal(28,0)	13
abandonFlag	int	4
firstFlag	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

virtualSessionID

int

1 - 1

queueID

int

userID

int

sessionID

int

queuedEpoch

decimal(28,0)

handledEpoch

decimal(28,0)

endEpoch

decimal(28,0)

waitTime

decimal(28,0)

handledTime

decimal(28,0)

abandonFlag

int

firstFlag

int

	Name	Columns	Unique
	pk_virtualSessions	virtualSessionID

Name

Columns

Unique

pk_virtualSessions

virtualSessionID

SQL Script

CREATE TABLE [dbo].[VirtualSessions]
(
[virtualSessionID] [int] NOT NULL IDENTITY(1, 1),
[queueID] [int] NULL,
[userID] [int] NULL,
[sessionID] [int] NULL,
[queuedEpoch] [decimal] (28, 0) NULL,
[handledEpoch] [decimal] (28, 0) NULL,
[endEpoch] [decimal] (28, 0) NULL,
[waitTime] [decimal] (28, 0) NULL,
[handledTime] [decimal] (28, 0) NULL,
[abandonFlag] [int] NULL,
[firstFlag] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VirtualSessions] ADD CONSTRAINT [pk_virtualSessions] PRIMARY KEY CLUSTERED ([virtualSessionID]) ON [PRIMARY]
GO