[dbo].[ca_dscv_class_relationships]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	69
Created	11:07:58 AM Wednesday, March 07, 2007
Last Modified	9:08:01 PM Friday, December 05, 2008

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKca_dscv_class_relationships: dst_class_id\src_class_id\src_hierarchy_id\dst_hierarchy_id$	src_class_id	int	4
$Cluster Primary Key XPKca_dscv_class_relationships: dst_class_id\src_class_id\src_hierarchy_id\dst_hierarchy_id$	dst_class_id	int	4
$Cluster Primary Key XPKca_dscv_class_relationships: dst_class_id\src_class_id\src_hierarchy_id\dst_hierarchy_id$	src_hierarchy_id	int	4
$Cluster Primary Key XPKca_dscv_class_relationships: dst_class_id\src_class_id\src_hierarchy_id\dst_hierarchy_id$	dst_hierarchy_id	int	4
	type	varchar(32)	32

	Name	Columns	Unique
$Cluster Primary Key XPKca_dscv_class_relationships: dst_class_id\src_class_id\src_hierarchy_id\dst_hierarchy_id$	XPKca_dscv_class_relationships	dst_class_id, src_class_id, src_hierarchy_id, dst_hierarchy_id

Name	Columns
$ca_ds_r000018db00000000	dst_hierarchy_id->[dbo].[ca_hierarchy].[hierarchy_id]
$ca_ds_r000018e500000000	src_hierarchy_id->[dbo].[ca_hierarchy].[hierarchy_id]
$ca_ds_r000018ef00000000	dst_class_id->[dbo].[ca_class_def].[class_id]

Type	Action	Owning Principal
Grant	Delete	dscadmin
Grant	Insert	dscadmin
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Delete	uniuser
Grant	Insert	uniuser
Grant	Delete	wvadmin
Grant	Insert	wvadmin
Grant	Select	dscadmin
Grant	Update	dscadmin
Grant	Select	dscuser
Grant	Select	regadmin
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser
Grant	Update	uniuser
Grant	References	wvadmin
Grant	Select	wvadmin
Grant	Update	wvadmin

SQL Script

CREATE TABLE [dbo].[ca_dscv_class_relationships]
(
[src_class_id] [int] NOT NULL,
[dst_class_id] [int] NOT NULL,
[src_hierarchy_id] [int] NOT NULL,
[dst_hierarchy_id] [int] NOT NULL,
[type] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_dscv_class_relationships] ADD CONSTRAINT [XPKca_dscv_class_relationships] PRIMARY KEY CLUSTERED ([dst_class_id], [src_class_id], [src_hierarchy_id], [dst_hierarchy_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_dscv_class_relationships] ADD CONSTRAINT [$ca_ds_r000018db00000000] FOREIGN KEY ([dst_hierarchy_id]) REFERENCES [dbo].[ca_hierarchy] ([hierarchy_id])
GO
ALTER TABLE [dbo].[ca_dscv_class_relationships] ADD CONSTRAINT [$ca_ds_r000018e500000000] FOREIGN KEY ([src_hierarchy_id]) REFERENCES [dbo].[ca_hierarchy] ([hierarchy_id])
GO
ALTER TABLE [dbo].[ca_dscv_class_relationships] ADD CONSTRAINT [$ca_ds_r000018ef00000000] FOREIGN KEY ([dst_class_id]) REFERENCES [dbo].[ca_class_def] ([class_id])
GO
GRANT SELECT ON  [dbo].[ca_dscv_class_relationships] TO [dscadmin]
GRANT INSERT ON  [dbo].[ca_dscv_class_relationships] TO [dscadmin]
GRANT DELETE ON  [dbo].[ca_dscv_class_relationships] TO [dscadmin]
GRANT UPDATE ON  [dbo].[ca_dscv_class_relationships] TO [dscadmin]
GRANT SELECT ON  [dbo].[ca_dscv_class_relationships] TO [dscuser]
GRANT SELECT ON  [dbo].[ca_dscv_class_relationships] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_dscv_class_relationships] TO [uniadmin]
GRANT INSERT ON  [dbo].[ca_dscv_class_relationships] TO [uniadmin]
GRANT DELETE ON  [dbo].[ca_dscv_class_relationships] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ca_dscv_class_relationships] TO [uniadmin]
GRANT SELECT ON  [dbo].[ca_dscv_class_relationships] TO [uniuser]
GRANT INSERT ON  [dbo].[ca_dscv_class_relationships] TO [uniuser]
GRANT DELETE ON  [dbo].[ca_dscv_class_relationships] TO [uniuser]
GRANT UPDATE ON  [dbo].[ca_dscv_class_relationships] TO [uniuser]
GRANT REFERENCES ON  [dbo].[ca_dscv_class_relationships] TO [wvadmin]
GRANT SELECT ON  [dbo].[ca_dscv_class_relationships] TO [wvadmin]
GRANT INSERT ON  [dbo].[ca_dscv_class_relationships] TO [wvadmin]
GRANT DELETE ON  [dbo].[ca_dscv_class_relationships] TO [wvadmin]
GRANT UPDATE ON  [dbo].[ca_dscv_class_relationships] TO [wvadmin]
GO