[dbo].[ToolRolePropertySetting]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key pk_toolrolepropertysetting: toolID\roleID\propertyName$	toolID	int	4
$Cluster Primary Key pk_toolrolepropertysetting: toolID\roleID\propertyName$	roleID	int	4
$Cluster Primary Key pk_toolrolepropertysetting: toolID\roleID\propertyName$	propertyName	nvarchar(255)	510
	propertyValue	nvarchar(255)	510

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_toolrolepropertysetting: toolID\roleID\propertyName$

toolID

int

$Cluster Primary Key pk_toolrolepropertysetting: toolID\roleID\propertyName$

roleID

int

$Cluster Primary Key pk_toolrolepropertysetting: toolID\roleID\propertyName$

propertyName

nvarchar(255)

510

propertyValue

nvarchar(255)

510

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

Name

Columns

Unique

$Cluster Primary Key pk_toolrolepropertysetting: toolID\roleID\propertyName$

pk_toolrolepropertysetting

toolID, roleID, propertyName

Name	Columns
fk_trps_r	roleID->[dbo].[Roles].[roleID]
fk_trps_t	toolID->[dbo].[Tools].[toolID]

Name

Columns

fk_trps_r

roleID->[dbo].[Roles].[roleID]

fk_trps_t

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

SQL Script

CREATE TABLE [dbo].[ToolRolePropertySetting]
(
[toolID] [int] NOT NULL,
[roleID] [int] NOT NULL,
[propertyName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[propertyValue] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ToolRolePropertySetting] ADD CONSTRAINT [pk_toolrolepropertysetting] PRIMARY KEY CLUSTERED ([toolID], [roleID], [propertyName]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ToolRolePropertySetting] ADD CONSTRAINT [fk_trps_r] FOREIGN KEY ([roleID]) REFERENCES [dbo].[Roles] ([roleID])
GO
ALTER TABLE [dbo].[ToolRolePropertySetting] ADD CONSTRAINT [fk_trps_t] FOREIGN KEY ([toolID]) REFERENCES [dbo].[Tools] ([toolID])
GO