[dbo].[HYBRID_PERMISSIONS]

(local) > catalystdb > Tables > dbo.HYBRID_PERMISSIONS

Properties
Columns
Indexes
SQL Script
Uses
Used By

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

Columns

Name	Data Type	Max Length (Bytes)	Identity
ID	int	4	1 - 1
RESOURCE_ID	varchar(255)	255
ACTION	varchar(255)	255

Indexes

	Name	Columns	Unique
	PK__HYBRID_PERMISSIO__1FCDBCEB	ID

SQL Script

CREATE TABLE [dbo].[HYBRID_PERMISSIONS]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[RESOURCE_ID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ACTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HYBRID_PERMISSIONS] ADD CONSTRAINT [PK__HYBRID_PERMISSIO__1FCDBCEB] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO

Uses

Used By

[dbo].[HYBRID_ROLE_PERMISSIONS]
[dbo].[HYBRID_USER_PERMISSIONS]