[dbo].[DataRoutingServers]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

12:44:47 PM Thursday, October 04, 2007

Last Modified

12:44:47 PM Thursday, October 04, 2007

Name	Data Type	Max Length (Bytes)	Identity
drServerID	int	4	1 - 1
divisionID	int	4
label	nvarchar(100)	200
host	nvarchar(100)	200
port	int	4
cssURL	nvarchar(150)	300
enabled	bit	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

drServerID

int

1 - 1

divisionID

int

label

nvarchar(100)

200

host

nvarchar(100)

200

port

int

cssURL

nvarchar(150)

300

enabled

bit

	Name	Columns	Unique
	PK__DataRoutingServe__592635D8	drServerID

Name

Columns

Unique

PK__DataRoutingServe__592635D8

drServerID

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

Name

Columns

FK__DataRouti__divis__5A1A5A11

divisionID->[dbo].[Divisions].[divisionID]

SQL Script

CREATE TABLE [dbo].[DataRoutingServers]
(
[drServerID] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[label] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[host] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[port] [int] NOT NULL,
[cssURL] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[enabled] [bit] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataRoutingServers] ADD CONSTRAINT [PK__DataRoutingServe__592635D8] PRIMARY KEY CLUSTERED ([drServerID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataRoutingServers] ADD CONSTRAINT [FK__DataRouti__divis__5A1A5A11] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO