[dbo].[RoleToolJoin]

(local) > SupportBridge > Tables > dbo.RoleToolJoin

Properties
Columns
Indexes
Foreign Keys
SQL Script
Uses

Property	Value
Row Count	116
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)	Allow Nulls
$Cluster Primary Key pk_roletooljoin: roleID\toolID$	roleID	int	4
$Cluster Primary Key pk_roletooljoin: roleID\toolID$	toolID	int	4

Indexes

	Name	Columns	Unique
$Cluster Primary Key pk_roletooljoin: roleID\toolID$	pk_roletooljoin	roleID, toolID

Foreign Keys

Name	Columns
fk_roletool_role	roleID->[dbo].[Roles].[roleID]
fk_roletool_tool	toolID->[dbo].[Tools].[toolID]

SQL Script

CREATE TABLE [dbo].[RoleToolJoin]
(
[roleID] [int] NOT NULL,
[toolID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RoleToolJoin] ADD CONSTRAINT [pk_roletooljoin] PRIMARY KEY CLUSTERED ([roleID], [toolID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RoleToolJoin] ADD CONSTRAINT [fk_roletool_role] FOREIGN KEY ([roleID]) REFERENCES [dbo].[Roles] ([roleID])
GO
ALTER TABLE [dbo].[RoleToolJoin] ADD CONSTRAINT [fk_roletool_tool] FOREIGN KEY ([toolID]) REFERENCES [dbo].[Tools] ([toolID])
GO

Uses