CREATE TABLE [dbo].[usm_metric_category]
(
[metric_category_id] [int] NOT NULL,
[metric_type] [int] NULL,
[metric_version] [int] NULL,
[name] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[comment] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[real_time_metric] [int] NULL,
[reporting_interval] [int] NULL,
[sample_interval] [int] NULL,
[threshold] [float] NULL,
[user_dependent] [int] NULL,
[charge_type] [int] NULL,
[meter_gui_config_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[unit_type_id] [int] NULL,
[metric_analyzer_id] [int] NULL,
[comments] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[usm_metric_category] ADD CONSTRAINT [XPKusm_metric_category] PRIMARY KEY CLUSTERED ([metric_category_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_metric_category] ADD CONSTRAINT [$usm_m_r000026b700000000] FOREIGN KEY ([metric_analyzer_id]) REFERENCES [dbo].[usm_metric_analyzer] ([metric_analyzer_id])
GO
ALTER TABLE [dbo].[usm_metric_category] ADD CONSTRAINT [$usm_m_r000026c100000000] FOREIGN KEY ([unit_type_id]) REFERENCES [dbo].[usm_unittype] ([unittype_id])
GO
ALTER TABLE [dbo].[usm_metric_category] ADD CONSTRAINT [$usm_m_r000026cb00000000] FOREIGN KEY ([meter_gui_config_id]) REFERENCES [dbo].[usm_meter_gui_cfg] ([meter_gui_config_id])
GO
GRANT SELECT ON  [dbo].[usm_metric_category] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_metric_category] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_metric_category] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_metric_category] TO [usmgroup]
GO