[dbo].[AgentAvailability]

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

Property

Value

Row Count

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)
	divisionID	int	4
$Cluster Primary Key pk_agentavail: agentID\queueID$	agentID	int	4
$Cluster Primary Key pk_agentavail: agentID\queueID$	queueID	int	4
	status	int	4
	availEpoch	decimal(18,0)	9
	clientID	int	4
	matchEpoch	decimal(38,0)	17
	groupID	int	4
	incidentCount	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

divisionID

int

$Cluster Primary Key pk_agentavail: agentID\queueID$

agentID

int

$Cluster Primary Key pk_agentavail: agentID\queueID$

queueID

int

status

int

availEpoch

decimal(18,0)

clientID

int

matchEpoch

decimal(38,0)

groupID

int

incidentCount

int

	Name	Columns	Unique
$Cluster Primary Key pk_agentavail: agentID\queueID$	pk_agentavail	agentID, queueID

Name

Columns

Unique

$Cluster Primary Key pk_agentavail: agentID\queueID$

pk_agentavail

agentID, queueID

Name	Columns
fk_agentavail_queue	queueID->[dbo].[Queues].[queueID]
fk_agentavail_user	agentID->[dbo].[Users].[userID]

Name

Columns

fk_agentavail_queue

queueID->[dbo].[Queues].[queueID]

fk_agentavail_user

agentID->[dbo].[Users].[userID]

SQL Script

CREATE TABLE [dbo].[AgentAvailability]
(
[divisionID] [int] NULL,
[agentID] [int] NOT NULL,
[queueID] [int] NOT NULL,
[status] [int] NULL,
[availEpoch] [decimal] (18, 0) NULL,
[clientID] [int] NULL,
[matchEpoch] [decimal] (38, 0) NULL,
[groupID] [int] NULL,
[incidentCount] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AgentAvailability] ADD CONSTRAINT [pk_agentavail] PRIMARY KEY CLUSTERED ([agentID], [queueID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AgentAvailability] ADD CONSTRAINT [fk_agentavail_queue] FOREIGN KEY ([queueID]) REFERENCES [dbo].[Queues] ([queueID])
GO
ALTER TABLE [dbo].[AgentAvailability] ADD CONSTRAINT [fk_agentavail_user] FOREIGN KEY ([agentID]) REFERENCES [dbo].[Users] ([userID])
GO