[dbo].[RulesConduitRules]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	8
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_rulesconduitrules: divisionID\functionName$	divisionID	int	4
$Cluster Primary Key pk_rulesconduitrules: divisionID\functionName$	functionName	nvarchar(100)	200
	className	nvarchar(100)	200
	methodName	nvarchar(100)	200

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_rulesconduitrules: divisionID\functionName$

divisionID

int

$Cluster Primary Key pk_rulesconduitrules: divisionID\functionName$

functionName

nvarchar(100)

200

className

nvarchar(100)

200

methodName

nvarchar(100)

200

	Name	Columns	Unique
$Cluster Primary Key pk_rulesconduitrules: divisionID\functionName$	pk_rulesconduitrules	divisionID, functionName

Name

Columns

Unique

$Cluster Primary Key pk_rulesconduitrules: divisionID\functionName$

pk_rulesconduitrules

divisionID, functionName

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

Name

Columns

fk_rulesconduit_div

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

SQL Script

CREATE TABLE [dbo].[RulesConduitRules]
(
[divisionID] [int] NOT NULL,
[functionName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[className] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[methodName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RulesConduitRules] ADD CONSTRAINT [pk_rulesconduitrules] PRIMARY KEY CLUSTERED ([divisionID], [functionName]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RulesConduitRules] ADD CONSTRAINT [fk_rulesconduit_div] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO