[dbo].[ca_dscv_class_combo

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKca_dscv_class_combo_rules: combination_id\class_id\hierarchy_id$	combination_id	varchar(32)	32
$Cluster Primary Key XPKca_dscv_class_combo_rules: combination_id\class_id\hierarchy_id$	class_id	int	4
$Cluster Primary Key XPKca_dscv_class_combo_rules: combination_id\class_id\hierarchy_id$	hierarchy_id	int	4
	required_result	tinyint	1

	Name	Columns	Unique
$Cluster Primary Key XPKca_dscv_class_combo_rules: combination_id\class_id\hierarchy_id$	XPKca_dscv_class_combo_rules	combination_id, class_id, hierarchy_id

Name	Columns
$ca_ds_r0000189f00000000	hierarchy_id->[dbo].[ca_hierarchy].[hierarchy_id]
$ca_ds_r000018b300000000	combination_id->[dbo].[ca_dscv_class_rules].[classify_id]

Type	Action	Owning Principal
Grant	Insert	uniuser
Grant	Delete	wvadmin
Grant	Insert	wvadmin
Grant	Delete	dscadmin
Grant	Insert	dscadmin
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Delete	uniuser
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_combo_rules]
(
[combination_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[class_id] [int] NOT NULL,
[hierarchy_id] [int] NOT NULL,
[required_result] [tinyint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_dscv_class_combo_rules] ADD CONSTRAINT [XPKca_dscv_class_combo_rules] PRIMARY KEY CLUSTERED ([combination_id], [class_id], [hierarchy_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_dscv_class_combo_rules] ADD CONSTRAINT [$ca_ds_r0000189f00000000] FOREIGN KEY ([hierarchy_id]) REFERENCES [dbo].[ca_hierarchy] ([hierarchy_id])
GO
ALTER TABLE [dbo].[ca_dscv_class_combo_rules] ADD CONSTRAINT [$ca_ds_r000018b300000000] FOREIGN KEY ([combination_id]) REFERENCES [dbo].[ca_dscv_class_rules] ([classify_id])
GO
GRANT SELECT ON  [dbo].[ca_dscv_class_combo_rules] TO [dscadmin]
GRANT INSERT ON  [dbo].[ca_dscv_class_combo_rules] TO [dscadmin]
GRANT DELETE ON  [dbo].[ca_dscv_class_combo_rules] TO [dscadmin]
GRANT UPDATE ON  [dbo].[ca_dscv_class_combo_rules] TO [dscadmin]
GRANT SELECT ON  [dbo].[ca_dscv_class_combo_rules] TO [dscuser]
GRANT SELECT ON  [dbo].[ca_dscv_class_combo_rules] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_dscv_class_combo_rules] TO [uniadmin]
GRANT INSERT ON  [dbo].[ca_dscv_class_combo_rules] TO [uniadmin]
GRANT DELETE ON  [dbo].[ca_dscv_class_combo_rules] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ca_dscv_class_combo_rules] TO [uniadmin]
GRANT SELECT ON  [dbo].[ca_dscv_class_combo_rules] TO [uniuser]
GRANT INSERT ON  [dbo].[ca_dscv_class_combo_rules] TO [uniuser]
GRANT DELETE ON  [dbo].[ca_dscv_class_combo_rules] TO [uniuser]
GRANT UPDATE ON  [dbo].[ca_dscv_class_combo_rules] TO [uniuser]
GRANT REFERENCES ON  [dbo].[ca_dscv_class_combo_rules] TO [wvadmin]
GRANT SELECT ON  [dbo].[ca_dscv_class_combo_rules] TO [wvadmin]
GRANT INSERT ON  [dbo].[ca_dscv_class_combo_rules] TO [wvadmin]
GRANT DELETE ON  [dbo].[ca_dscv_class_combo_rules] TO [wvadmin]
GRANT UPDATE ON  [dbo].[ca_dscv_class_combo_rules] TO [wvadmin]
GO