[dbo].[WaitComponents]

(local) > SupportBridge > Tables > dbo.WaitComponents

Properties
Columns
Foreign Keys
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	9
Created	12:44:45 PM Thursday, October 04, 2007
Last Modified	12:44:45 PM Thursday, October 04, 2007

Columns

Name	Data Type	Max Length (Bytes)	Default
divisionID	int	4
queueID	int	4
waitURL	nvarchar(300)	600
isExternal	int	4	((0))
pageType	int	4	((0))

Foreign Keys

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

SQL Script

CREATE TABLE [dbo].[WaitComponents]
(
[divisionID] [int] NOT NULL,
[queueID] [int] NULL,
[waitURL] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[isExternal] [int] NULL CONSTRAINT [DF__WaitCompo__isExt__7B264821] DEFAULT ((0)),
[pageType] [int] NULL CONSTRAINT [DF__WaitCompo__pageT__7C1A6C5A] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WaitComponents] ADD CONSTRAINT [fk_waitcomps_div] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO

Uses

[dbo].[Divisions]
dbo