Tables [dbo].[QueueHours]
Properties
PropertyValue
Row Count0
Created12:44:46 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key pk_queuehours: queueID\day_of_week\timeValueForeign Keys fk_ueuehours_q: [dbo].[Queues].queueIDqueueIDint4
No
Cluster Primary Key pk_queuehours: queueID\day_of_week\timeValueday_of_weekint4
No
Cluster Primary Key pk_queuehours: queueID\day_of_week\timeValuetimeValueint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_queuehours: queueID\day_of_week\timeValuepk_queuehoursqueueID, day_of_week, timeValue
Yes
Foreign Keys Foreign Keys
NameColumns
fk_ueuehours_qqueueID->[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