[dbo].[HARITEMACCESS]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	58
Created	4:59:52 AM Monday, March 02, 2009
Last Modified	5:00:27 AM Monday, March 02, 2009

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key HARITEMACCESS_PK: ITEMOBJID\USRGRPOBJID$	ITEMOBJID	int	4
$Cluster Primary Key HARITEMACCESS_PK: ITEMOBJID\USRGRPOBJID$ $Indexes HARITEMACCESS_VIEW: VIEWACCESS\USRGRPOBJID$	USRGRPOBJID	int	4
$Indexes HARITEMACCESS_VIEW: VIEWACCESS\USRGRPOBJID$	VIEWACCESS	char(1)	1	('Y')

	Name	Columns
$Cluster Primary Key HARITEMACCESS_PK: ITEMOBJID\USRGRPOBJID$	HARITEMACCESS_PK	ITEMOBJID, USRGRPOBJID
	HARITEMACCESS_USRGRP	USRGRPOBJID
	HARITEMACCESS_VIEW	VIEWACCESS, USRGRPOBJID

Name	Delete	Columns
HARITEMACCESS_ITEMID_FK	Cascade	ITEMOBJID->[dbo].[HARITEMS].[ITEMOBJID]
HARITEMACCESS_USRGRPID_FK	Cascade	USRGRPOBJID->[dbo].[HARUSERGROUP].[USRGRPOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARITEMACCESS table stores the definition of security for a CA SCM item.
Caption	COLUMN	ITEMOBJID	Object ID of item
Caption	COLUMN	USRGRPOBJID	Object ID of user group
Caption	COLUMN	VIEWACCESS	View item access (Y/N)

SQL Script

CREATE TABLE [dbo].[HARITEMACCESS]
(
[ITEMOBJID] [int] NOT NULL,
[USRGRPOBJID] [int] NOT NULL,
[VIEWACCESS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARITEMAC__VIEWA__6C190EBB] DEFAULT ('Y')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARITEMACCESS] ADD CONSTRAINT [HARITEMACCESS_PK] PRIMARY KEY CLUSTERED ([ITEMOBJID], [USRGRPOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARITEMACCESS_USRGRP] ON [dbo].[HARITEMACCESS] ([USRGRPOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARITEMACCESS_VIEW] ON [dbo].[HARITEMACCESS] ([VIEWACCESS], [USRGRPOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARITEMACCESS] ADD CONSTRAINT [HARITEMACCESS_ITEMID_FK] FOREIGN KEY ([ITEMOBJID]) REFERENCES [dbo].[HARITEMS] ([ITEMOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARITEMACCESS] ADD CONSTRAINT [HARITEMACCESS_USRGRPID_FK] FOREIGN KEY ([USRGRPOBJID]) REFERENCES [dbo].[HARUSERGROUP] ([USRGRPOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARITEMACCESS table stores the definition of security for a CA SCM item. ', 'SCHEMA', N'dbo', 'TABLE', N'HARITEMACCESS', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of item', 'SCHEMA', N'dbo', 'TABLE', N'HARITEMACCESS', 'COLUMN', N'ITEMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user group', 'SCHEMA', N'dbo', 'TABLE', N'HARITEMACCESS', 'COLUMN', N'USRGRPOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'View item access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARITEMACCESS', 'COLUMN', N'VIEWACCESS'
GO