[dbo].[usm_collection_profile

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:08:08 AM Wednesday, March 07, 2007
Last Modified	1:17:01 PM Tuesday, March 30, 2010

Name	Data Type	Max Length (Bytes)
collection_profile_metric_id	int	4
collection_profile_id	int	4
metric_id	int	4
agent_host_id	int	4
description	nvarchar(128)	256

	Name	Columns	Unique
	XPKusm_collection_profile_metric	collection_profile_metric_id

Name	Columns
$usm_c_r0000213f00000000	agent_host_id->[dbo].[usm_slm_server].[server_id]
$usm_c_r0000214900000000	metric_id->[dbo].[usm_metric].[metric_id]
$usm_c_r0000215300000000	collection_profile_id->[dbo].[usm_collection_profile].[collection_profile_id]

Type	Action	Owning Principal
Grant	Delete	usmgroup
Grant	Insert	usmgroup
Grant	Select	usmgroup
Grant	Update	usmgroup

SQL Script

CREATE TABLE [dbo].[usm_collection_profile_metric]
(
[collection_profile_metric_id] [int] NOT NULL,
[collection_profile_id] [int] NULL,
[metric_id] [int] NULL,
[agent_host_id] [int] NULL,
[description] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_collection_profile_metric] ADD CONSTRAINT [XPKusm_collection_profile_metric] PRIMARY KEY CLUSTERED ([collection_profile_metric_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_collection_profile_metric] ADD CONSTRAINT [$usm_c_r0000213f00000000] FOREIGN KEY ([agent_host_id]) REFERENCES [dbo].[usm_slm_server] ([server_id])
GO
ALTER TABLE [dbo].[usm_collection_profile_metric] ADD CONSTRAINT [$usm_c_r0000214900000000] FOREIGN KEY ([metric_id]) REFERENCES [dbo].[usm_metric] ([metric_id])
GO
ALTER TABLE [dbo].[usm_collection_profile_metric] ADD CONSTRAINT [$usm_c_r0000215300000000] FOREIGN KEY ([collection_profile_id]) REFERENCES [dbo].[usm_collection_profile] ([collection_profile_id])
GO
GRANT SELECT ON  [dbo].[usm_collection_profile_metric] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_collection_profile_metric] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_collection_profile_metric] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_collection_profile_metric] TO [usmgroup]
GO