[dbo].[AgentStatusChangeHistory]

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

406

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_AgentStatusHist: agentSessionID\newStatus\statusChangeEpoch$	agentSessionID	int	4
$Cluster Primary Key pk_AgentStatusHist: agentSessionID\newStatus\statusChangeEpoch$	newStatus	int	4
$Cluster Primary Key pk_AgentStatusHist: agentSessionID\newStatus\statusChangeEpoch$	statusChangeEpoch	decimal(13,0)	9
	agentUserID	int	4
	statusChangeTime	nvarchar(50)	100
	nextStatusChangeEpoch	decimal(13,0)	9
	nextStatusChangeTime	nvarchar(50)	100

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_AgentStatusHist: agentSessionID\newStatus\statusChangeEpoch$

agentSessionID

int

$Cluster Primary Key pk_AgentStatusHist: agentSessionID\newStatus\statusChangeEpoch$

newStatus

int

$Cluster Primary Key pk_AgentStatusHist: agentSessionID\newStatus\statusChangeEpoch$

statusChangeEpoch

decimal(13,0)

agentUserID

int

statusChangeTime

nvarchar(50)

100

nextStatusChangeEpoch

decimal(13,0)

nextStatusChangeTime

nvarchar(50)

100

	Name	Columns	Unique
$Cluster Primary Key pk_AgentStatusHist: agentSessionID\newStatus\statusChangeEpoch$	pk_AgentStatusHist	agentSessionID, newStatus, statusChangeEpoch

Name

Columns

Unique

$Cluster Primary Key pk_AgentStatusHist: agentSessionID\newStatus\statusChangeEpoch$

pk_AgentStatusHist

agentSessionID, newStatus, statusChangeEpoch

Name	Columns
fk_AgentStatus	newStatus->[dbo].[AgentStatuses].[status]

Name

Columns

fk_AgentStatus

newStatus->[dbo].[AgentStatuses].[status]

SQL Script

CREATE TABLE [dbo].[AgentStatusChangeHistory]
(
[agentSessionID] [int] NOT NULL,
[newStatus] [int] NOT NULL,
[statusChangeEpoch] [decimal] (13, 0) NOT NULL,
[agentUserID] [int] NULL,
[statusChangeTime] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nextStatusChangeEpoch] [decimal] (13, 0) NULL,
[nextStatusChangeTime] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AgentStatusChangeHistory] ADD CONSTRAINT [pk_AgentStatusHist] PRIMARY KEY CLUSTERED ([agentSessionID], [newStatus], [statusChangeEpoch]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AgentStatusChangeHistory] ADD CONSTRAINT [fk_AgentStatus] FOREIGN KEY ([newStatus]) REFERENCES [dbo].[AgentStatuses] ([status])
GO