[dbo].[HelpDeskHours]

(local) > SupportBridge > Tables > dbo.HelpDeskHours

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_helpdeskhours: divisionID\day_of_week\timeValue$	divisionID	int	4
$Cluster Primary Key pk_helpdeskhours: divisionID\day_of_week\timeValue$	day_of_week	int	4
$Cluster Primary Key pk_helpdeskhours: divisionID\day_of_week\timeValue$	timeValue	int	4

Indexes

	Name	Columns	Unique
$Cluster Primary Key pk_helpdeskhours: divisionID\day_of_week\timeValue$	pk_helpdeskhours	divisionID, day_of_week, timeValue

Foreign Keys

Name	Columns
fk_helpdeskhours_div	divisionID->[dbo].[Divisions].[divisionID]

SQL Script

CREATE TABLE [dbo].[HelpDeskHours]
(
[divisionID] [int] NOT NULL,
[day_of_week] [int] NOT NULL,
[timeValue] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HelpDeskHours] ADD CONSTRAINT [pk_helpdeskhours] PRIMARY KEY CLUSTERED ([divisionID], [day_of_week], [timeValue]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HelpDeskHours] ADD CONSTRAINT [fk_helpdeskhours_div] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO

Uses

[dbo].[Divisions]
dbo