[dbo].[QueueHours]

(local) > SupportBridge > Tables > dbo.QueueHours

Properties
Columns
Indexes
Foreign Keys
SQL Script
Uses

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

Columns

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key pk_queuehours: queueID\day_of_week\timeValue$	queueID	int	4
$Cluster Primary Key pk_queuehours: queueID\day_of_week\timeValue$	day_of_week	int	4
$Cluster Primary Key pk_queuehours: queueID\day_of_week\timeValue$	timeValue	int	4

Indexes

	Name	Columns	Unique
$Cluster Primary Key pk_queuehours: queueID\day_of_week\timeValue$	pk_queuehours	queueID, day_of_week, timeValue

Foreign Keys

Name	Columns
fk_ueuehours_q	queueID->[dbo].[Queues].[queueID]

SQL Script

CREATE TABLE [dbo].[QueueHours]
(
[queueID] [int] NOT NULL,
[day_of_week] [int] NOT NULL,
[timeValue] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueueHours] ADD CONSTRAINT [pk_queuehours] PRIMARY KEY CLUSTERED ([queueID], [day_of_week], [timeValue]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueueHours] ADD CONSTRAINT [fk_ueuehours_q] FOREIGN KEY ([queueID]) REFERENCES [dbo].[Queues] ([queueID])
GO

Uses

[dbo].[Queues]
dbo