[usmuser].[usm_metric

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	3522
Created	6:10:32 AM Monday, July 27, 2009
Last Modified	1:17:01 PM Tuesday, March 30, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

3522

Created

6:10:32 AM Monday, July 27, 2009

Last Modified

1:17:01 PM Tuesday, March 30, 2010

Name	Data Type	Max Length (Bytes)
sm_start_time	datetime	8
sm_end_time	datetime	8
sm_result	float	8
sm_result_status	int	4
sm_exclude	int	4
grouped_by	varchar(64)	64
group_by_type	int	4
metric_instance_id	int	4
maximum	float	8
minimum	float	8
no_of_samples	int	4
reduction_level	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

sm_start_time

datetime

sm_end_time

datetime

sm_result

float

sm_result_status

int

sm_exclude

int

grouped_by

varchar(64)

group_by_type

int

metric_instance_id

int

maximum

float

minimum

float

no_of_samples

int

reduction_level

int

Name	Columns
FK__usm_metri__metri__26B0C1C5	metric_instance_id->[dbo].[usm_metric_instance].[metric_instance_id]

Name

Columns

FK__usm_metri__metri__26B0C1C5

metric_instance_id->[dbo].[usm_metric_instance].[metric_instance_id]

SQL Script

CREATE TABLE [usmuser].[usm_metric_result20110]
(
[sm_start_time] [datetime] NULL,
[sm_end_time] [datetime] NULL,
[sm_result] [float] NULL,
[sm_result_status] [int] NULL,
[sm_exclude] [int] NULL,
[grouped_by] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[group_by_type] [int] NULL,
[metric_instance_id] [int] NOT NULL,
[maximum] [float] NULL,
[minimum] [float] NULL,
[no_of_samples] [int] NULL,
[reduction_level] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [usmuser].[usm_metric_result20110] ADD CONSTRAINT [FK__usm_metri__metri__26B0C1C5] FOREIGN KEY ([metric_instance_id]) REFERENCES [dbo].[usm_metric_instance] ([metric_instance_id])
GO