CREATE TABLE [dbo].[usm_metric_instance]
(
[metric_instance_id] [int] NOT NULL,
[comment] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[destination] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[enable] [int] NULL CONSTRAINT [DF__usm_metri__enabl__216CB7F1] DEFAULT ((0)),
[end_time] [datetime] NULL,
[full_detail] [int] NULL CONSTRAINT [DF__usm_metri__full___2260DC2A] DEFAULT ((0)),
[group_id] [int] NULL,
[metric_category_id] [int] NULL,
[metric_version] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[operator] [int] NULL,
[real_time_metric] [int] NULL CONSTRAINT [DF__usm_metri__real___23550063] DEFAULT ((0)),
[report_interval] [int] NULL,
[requestor] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[request_type] [int] NULL,
[sample_interval] [int] NULL,
[start_time] [datetime] NULL,
[status] [int] NULL,
[threshold] [float] NULL,
[unittype_id] [int] NULL,
[user_dependent] [int] NULL,
[report_interval_unit] [int] NULL,
[schema_id] [int] NULL,
[server_id] [int] NULL,
[created] [int] NULL,
[created_by] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_modified] [int] NULL,
[last_modified_by] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[source_analyze_job_id] [int] NULL,
[source_metric_instance_id] [int] NULL,
[comments] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[analyzed_report_group_id] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_metric_instance] ADD CONSTRAINT [XPKusm_metric_instance] PRIMARY KEY CLUSTERED ([metric_instance_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_metric_instance] ADD CONSTRAINT [$usm_m_r000026df00000000] FOREIGN KEY ([source_metric_instance_id]) REFERENCES [dbo].[usm_metric_instance] ([metric_instance_id])
GO
ALTER TABLE [dbo].[usm_metric_instance] ADD CONSTRAINT [$usm_m_r000026e900000000] FOREIGN KEY ([source_analyze_job_id]) REFERENCES [dbo].[usm_analyze_job] ([analyze_job_id])
GO
ALTER TABLE [dbo].[usm_metric_instance] ADD CONSTRAINT [$usm_m_r000026f300000000] FOREIGN KEY ([server_id]) REFERENCES [dbo].[usm_slm_server] ([server_id])
GO
ALTER TABLE [dbo].[usm_metric_instance] ADD CONSTRAINT [$usm_m_r000026fd00000000] FOREIGN KEY ([unittype_id]) REFERENCES [dbo].[usm_unittype] ([unittype_id])
GO
ALTER TABLE [dbo].[usm_metric_instance] ADD CONSTRAINT [$usm_m_r0000270700000000] FOREIGN KEY ([schema_id]) REFERENCES [dbo].[usm_schema] ([schema_id])
GO
ALTER TABLE [dbo].[usm_metric_instance] ADD CONSTRAINT [$usm_m_r0000271100000000] FOREIGN KEY ([metric_category_id]) REFERENCES [dbo].[usm_metric_category] ([metric_category_id])
GO
ALTER TABLE [dbo].[usm_metric_instance] ADD CONSTRAINT [XFK01usm_metric_instance] FOREIGN KEY ([analyzed_report_group_id]) REFERENCES [dbo].[usm_report_group] ([report_group_id])
GO
GRANT REFERENCES ON  [dbo].[usm_metric_instance] TO [usmgroup]
GRANT SELECT ON  [dbo].[usm_metric_instance] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_metric_instance] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_metric_instance] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_metric_instance] TO [usmgroup]
GO