[dbo].[FlowControlRules]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key pk_flowcontrolrules: divisionID\pageName\state$	divisionID	int	4
$Cluster Primary Key pk_flowcontrolrules: divisionID\pageName\state$	pageName	nvarchar(100)	200
$Cluster Primary Key pk_flowcontrolrules: divisionID\pageName\state$	state	nvarchar(100)	200
	directedURL	nvarchar(500)	1000

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_flowcontrolrules: divisionID\pageName\state$

divisionID

int

$Cluster Primary Key pk_flowcontrolrules: divisionID\pageName\state$

pageName

nvarchar(100)

200

$Cluster Primary Key pk_flowcontrolrules: divisionID\pageName\state$

state

nvarchar(100)

200

directedURL

nvarchar(500)

1000

	Name	Columns	Unique
$Cluster Primary Key pk_flowcontrolrules: divisionID\pageName\state$	pk_flowcontrolrules	divisionID, pageName, state

Name

Columns

Unique

$Cluster Primary Key pk_flowcontrolrules: divisionID\pageName\state$

pk_flowcontrolrules

divisionID, pageName, state

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

Name

Columns

fk_flowcontrol_div

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

SQL Script

CREATE TABLE [dbo].[FlowControlRules]
(
[divisionID] [int] NOT NULL,
[pageName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[state] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[directedURL] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FlowControlRules] ADD CONSTRAINT [pk_flowcontrolrules] PRIMARY KEY CLUSTERED ([divisionID], [pageName], [state]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FlowControlRules] ADD CONSTRAINT [fk_flowcontrol_div] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO