Tables [dbo].[QueuePresetJoin]
(local) > SupportBridge > Tables > dbo.QueuePresetJoin
Properties
PropertyValue
Row Count0
Created12:44:45 PM Thursday, October 04, 2007
Last Modified12:44:45 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key pk_queuepresetjoin: queueIDForeign Keys fk_queuepreset_queues: [dbo].[Queues].queueIDqueueIDint4
No
Foreign Keys fk_queuepreset_presets: [dbo].[CollabResponses].responseIDresponseIDint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_queuepresetjoin: queueIDpk_queuepresetjoinqueueID
Yes
Foreign Keys Foreign Keys
NameColumns
fk_queuepreset_presetsresponseID->[dbo].[CollabResponses].[responseID]
fk_queuepreset_queuesqueueID->[dbo].[Queues].[queueID]
SQL Script
CREATE TABLE [dbo].[QueuePresetJoin]
(
[queueID] [int] NOT NULL,
[responseID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueuePresetJoin] ADD CONSTRAINT [pk_queuepresetjoin] PRIMARY KEY CLUSTERED ([queueID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueuePresetJoin] ADD CONSTRAINT [fk_queuepreset_presets] FOREIGN KEY ([responseID]) REFERENCES [dbo].[CollabResponses] ([responseID])
GO
ALTER TABLE [dbo].[QueuePresetJoin] ADD CONSTRAINT [fk_queuepreset_queues] FOREIGN KEY ([queueID]) REFERENCES [dbo].[Queues] ([queueID])
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved