[dbo].[HYBRID_USER_PERMISSIONS]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	1:08:00 AM Thursday, September 10, 2009
Last Modified	1:08:00 AM Thursday, September 10, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

1:08:00 AM Thursday, September 10, 2009

Last Modified

1:08:00 AM Thursday, September 10, 2009

	Name	Data Type	Max Length (Bytes)	Identity
	ID	int	4	1 - 1
$Indexes UQ__HYBRID_USER_PERM__267ABA7A: PERMISSION_ID\USER_ID$	PERMISSION_ID	int	4
$Indexes UQ__HYBRID_USER_PERM__267ABA7A: PERMISSION_ID\USER_ID$	USER_ID	varchar(255)	255
	IS_ALLOWED	smallint	2

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

Cluster Primary Key PK__HYBRID_USER_PERM__25869641: ID

int

1 - 1

$Indexes UQ__HYBRID_USER_PERM__267ABA7A: PERMISSION_ID\USER_ID$

PERMISSION_ID

int

$Indexes UQ__HYBRID_USER_PERM__267ABA7A: PERMISSION_ID\USER_ID$

USER_ID

varchar(255)

255

IS_ALLOWED

smallint

	Name	Columns	Unique
	PK__HYBRID_USER_PERM__25869641	ID
	UQ__HYBRID_USER_PERM__267ABA7A	PERMISSION_ID, USER_ID

Name

Columns

Unique

PK__HYBRID_USER_PERM__25869641

UQ__HYBRID_USER_PERM__267ABA7A

PERMISSION_ID, USER_ID

Name	Delete	Columns
FK__HYBRID_US__PERMI__276EDEB3	Cascade	PERMISSION_ID->[dbo].[HYBRID_PERMISSIONS].[ID]

Name

Delete

Columns

FK__HYBRID_US__PERMI__276EDEB3

Cascade

PERMISSION_ID->[dbo].[HYBRID_PERMISSIONS].[ID]

SQL Script

CREATE TABLE [dbo].[HYBRID_USER_PERMISSIONS]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[PERMISSION_ID] [int] NOT NULL,
[USER_ID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IS_ALLOWED] [smallint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HYBRID_USER_PERMISSIONS] ADD CONSTRAINT [PK__HYBRID_USER_PERM__25869641] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HYBRID_USER_PERMISSIONS] ADD CONSTRAINT [UQ__HYBRID_USER_PERM__267ABA7A] UNIQUE NONCLUSTERED ([PERMISSION_ID], [USER_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HYBRID_USER_PERMISSIONS] ADD CONSTRAINT [FK__HYBRID_US__PERMI__276EDEB3] FOREIGN KEY ([PERMISSION_ID]) REFERENCES [dbo].[HYBRID_PERMISSIONS] ([ID]) ON DELETE CASCADE
GO