[dbo].[RoleQueueJoin]

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

Property

Value

Row Count

Created

12:44:45 PM Thursday, October 04, 2007

Last Modified

12:44:45 PM Thursday, October 04, 2007

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key pk_rolequeuejoin: divisionID\roleID\queueID$	divisionID	int	4
$Cluster Primary Key pk_rolequeuejoin: divisionID\roleID\queueID$	roleID	int	4
$Cluster Primary Key pk_rolequeuejoin: divisionID\roleID\queueID$	queueID	int	4
	isDefault	int	4	((0))

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key pk_rolequeuejoin: divisionID\roleID\queueID$

divisionID

int

$Cluster Primary Key pk_rolequeuejoin: divisionID\roleID\queueID$

roleID

int

$Cluster Primary Key pk_rolequeuejoin: divisionID\roleID\queueID$

queueID

int

isDefault

int

((0))

	Name	Columns	Unique
$Cluster Primary Key pk_rolequeuejoin: divisionID\roleID\queueID$	pk_rolequeuejoin	divisionID, roleID, queueID

Name

Columns

Unique

$Cluster Primary Key pk_rolequeuejoin: divisionID\roleID\queueID$

pk_rolequeuejoin

divisionID, roleID, queueID

Name	Columns
fk_rolequeue_div	divisionID->[dbo].[Divisions].[divisionID]
fk_rolequeue_queue	queueID->[dbo].[Queues].[queueID]
fk_rolequeue_role	roleID->[dbo].[Roles].[roleID]

Name

Columns

fk_rolequeue_div

divisionID->[dbo].[Divisions].[divisionID]

fk_rolequeue_queue

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

fk_rolequeue_role

roleID->[dbo].[Roles].[roleID]

SQL Script

CREATE TABLE [dbo].[RoleQueueJoin]
(
[divisionID] [int] NOT NULL,
[roleID] [int] NOT NULL,
[queueID] [int] NOT NULL,
[isDefault] [int] NULL CONSTRAINT [DF__RoleQueue__isDef__66603565] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RoleQueueJoin] ADD CONSTRAINT [pk_rolequeuejoin] PRIMARY KEY CLUSTERED ([divisionID], [roleID], [queueID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RoleQueueJoin] ADD CONSTRAINT [fk_rolequeue_div] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO
ALTER TABLE [dbo].[RoleQueueJoin] ADD CONSTRAINT [fk_rolequeue_queue] FOREIGN KEY ([queueID]) REFERENCES [dbo].[Queues] ([queueID])
GO
ALTER TABLE [dbo].[RoleQueueJoin] ADD CONSTRAINT [fk_rolequeue_role] FOREIGN KEY ([roleID]) REFERENCES [dbo].[Roles] ([roleID])
GO