[dbo].[SecurityRequestOrder]

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

Property

Value

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_secrequestorder: toolID\functionID$	toolID	int	4
$Cluster Primary Key pk_secrequestorder: toolID\functionID$	functionID	int	4
	orderbit	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_secrequestorder: toolID\functionID$

toolID

int

$Cluster Primary Key pk_secrequestorder: toolID\functionID$

functionID

int

orderbit

int

	Name	Columns	Unique
$Cluster Primary Key pk_secrequestorder: toolID\functionID$	pk_secrequestorder	toolID, functionID

Name

Columns

Unique

$Cluster Primary Key pk_secrequestorder: toolID\functionID$

pk_secrequestorder

toolID, functionID

Name	Columns
fk_secrequestorder_funcs	functionID->[dbo].[SecurityToolFunctions].[functionID]
fk_secrequestorder_tool	toolID->[dbo].[Tools].[toolID]

Name

Columns

fk_secrequestorder_funcs

functionID->[dbo].[SecurityToolFunctions].[functionID]

fk_secrequestorder_tool

toolID->[dbo].[Tools].[toolID]

SQL Script

CREATE TABLE [dbo].[SecurityRequestOrder]
(
[toolID] [int] NOT NULL,
[functionID] [int] NOT NULL,
[orderbit] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SecurityRequestOrder] ADD CONSTRAINT [pk_secrequestorder] PRIMARY KEY CLUSTERED ([toolID], [functionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SecurityRequestOrder] ADD CONSTRAINT [fk_secrequestorder_funcs] FOREIGN KEY ([functionID]) REFERENCES [dbo].[SecurityToolFunctions] ([functionID])
GO
ALTER TABLE [dbo].[SecurityRequestOrder] ADD CONSTRAINT [fk_secrequestorder_tool] FOREIGN KEY ([toolID]) REFERENCES [dbo].[Tools] ([toolID])
GO