[dbo].[ca_dscv_method

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKca_dscv_method_instances: classify_id\method_id$	classify_id	varchar(32)	32
$Cluster Primary Key XPKca_dscv_method_instances: classify_id\method_id$	method_id	varchar(32)	32
	filter	varchar(1024)	1024
	filter_type	varchar(32)	32
	filter_len	int	4
	filter_startbyte	int	4
	required_result	tinyint	1

	Name	Columns	Unique
$Cluster Primary Key XPKca_dscv_method_instances: classify_id\method_id$	XPKca_dscv_method_instances	classify_id, method_id

Name	Columns
$ca_ds_r0000188b00000000	method_id->[dbo].[ca_dscv_class_methods].[method_id]
$ca_ds_r0000189500000000	classify_id->[dbo].[ca_dscv_class_rules].[classify_id]

Type	Action	Owning Principal
Grant	Delete	uniuser
Grant	Insert	uniuser
Grant	Delete	wvadmin
Grant	Insert	wvadmin
Grant	Delete	dscadmin
Grant	Insert	dscadmin
Grant	Delete	uniadmin
Grant	Insert	uniadmin
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_method_instances]
(
[classify_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[method_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[filter] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[filter_type] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[filter_len] [int] NULL,
[filter_startbyte] [int] NULL,
[required_result] [tinyint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_dscv_method_instances] ADD CONSTRAINT [XPKca_dscv_method_instances] PRIMARY KEY CLUSTERED ([classify_id], [method_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_dscv_method_instances] ADD CONSTRAINT [$ca_ds_r0000188b00000000] FOREIGN KEY ([method_id]) REFERENCES [dbo].[ca_dscv_class_methods] ([method_id])
GO
ALTER TABLE [dbo].[ca_dscv_method_instances] ADD CONSTRAINT [$ca_ds_r0000189500000000] FOREIGN KEY ([classify_id]) REFERENCES [dbo].[ca_dscv_class_rules] ([classify_id])
GO
GRANT SELECT ON  [dbo].[ca_dscv_method_instances] TO [dscadmin]
GRANT INSERT ON  [dbo].[ca_dscv_method_instances] TO [dscadmin]
GRANT DELETE ON  [dbo].[ca_dscv_method_instances] TO [dscadmin]
GRANT UPDATE ON  [dbo].[ca_dscv_method_instances] TO [dscadmin]
GRANT SELECT ON  [dbo].[ca_dscv_method_instances] TO [dscuser]
GRANT SELECT ON  [dbo].[ca_dscv_method_instances] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_dscv_method_instances] TO [uniadmin]
GRANT INSERT ON  [dbo].[ca_dscv_method_instances] TO [uniadmin]
GRANT DELETE ON  [dbo].[ca_dscv_method_instances] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ca_dscv_method_instances] TO [uniadmin]
GRANT SELECT ON  [dbo].[ca_dscv_method_instances] TO [uniuser]
GRANT INSERT ON  [dbo].[ca_dscv_method_instances] TO [uniuser]
GRANT DELETE ON  [dbo].[ca_dscv_method_instances] TO [uniuser]
GRANT UPDATE ON  [dbo].[ca_dscv_method_instances] TO [uniuser]
GRANT REFERENCES ON  [dbo].[ca_dscv_method_instances] TO [wvadmin]
GRANT SELECT ON  [dbo].[ca_dscv_method_instances] TO [wvadmin]
GRANT INSERT ON  [dbo].[ca_dscv_method_instances] TO [wvadmin]
GRANT DELETE ON  [dbo].[ca_dscv_method_instances] TO [wvadmin]
GRANT UPDATE ON  [dbo].[ca_dscv_method_instances] TO [wvadmin]
GO