[dbo].[discoveryvariable]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:08:06 AM Wednesday, March 07, 2007
Last Modified	5:37:45 PM Monday, May 04, 2009

	Name	Data Type	Max Length (Bytes)
$Foreign Keys $disco_r000015d400000000: [dbo].[mibstructure].mibidx\oididxformib$	mibidx	int	4
	typeid	int	4
$Foreign Keys $disco_r000015d400000000: [dbo].[mibstructure].mibidx\oididxformib$	oididxformib	int	4
	discget	char(1)	1
	discresplocation	char(1)	1
	discrespvalue	varchar(32)	32
	oper	char(1)	1
	description	varchar(128)	128

	Name	Columns	Unique
	$disco_u0000157000000000	mibidx

Name	Columns
$disco_r000015c000000000	typeid->[dbo].[mibvariabletype].[typeid]
$disco_r000015ca00000000	mibidx->[dbo].[mibdefinition].[mibidx]
$disco_r000015d400000000	mibidx->[dbo].[mibstructure].[mibidx] oididxformib->[dbo].[mibstructure].[oididxformib]

Type	Action	Owning Principal
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser

SQL Script

CREATE TABLE [dbo].[discoveryvariable]
(
[mibidx] [int] NOT NULL,
[typeid] [int] NOT NULL,
[oididxformib] [int] NOT NULL,
[discget] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[discresplocation] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[discrespvalue] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[oper] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[discoveryvariable] ADD CONSTRAINT [$disco_u0000157000000000] PRIMARY KEY CLUSTERED ([mibidx]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[discoveryvariable] ADD CONSTRAINT [$disco_r000015c000000000] FOREIGN KEY ([typeid]) REFERENCES [dbo].[mibvariabletype] ([typeid])
GO
ALTER TABLE [dbo].[discoveryvariable] ADD CONSTRAINT [$disco_r000015ca00000000] FOREIGN KEY ([mibidx]) REFERENCES [dbo].[mibdefinition] ([mibidx])
GO
ALTER TABLE [dbo].[discoveryvariable] ADD CONSTRAINT [$disco_r000015d400000000] FOREIGN KEY ([mibidx], [oididxformib]) REFERENCES [dbo].[mibstructure] ([mibidx], [oididxformib])
GO
GRANT SELECT ON  [dbo].[discoveryvariable] TO [uniadmin]
GRANT INSERT ON  [dbo].[discoveryvariable] TO [uniadmin]
GRANT DELETE ON  [dbo].[discoveryvariable] TO [uniadmin]
GRANT UPDATE ON  [dbo].[discoveryvariable] TO [uniadmin]
GRANT SELECT ON  [dbo].[discoveryvariable] TO [uniuser]
GO