CREATE TABLE [dbo].[usm_rate_definition]
(
[item_id] [int] NOT NULL,
[rate_plan_id] [int] NULL,
[base_id] [int] NOT NULL,
[association_id] [int] NOT NULL,
[rate_row] [int] NOT NULL,
[rate_col] [int] NOT NULL,
[code] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status] [int] NOT NULL,
[item_text] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[item_type] [int] NOT NULL,
[is_hidden] [int] NOT NULL,
[notes_id] [int] NULL,
[info_link] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[currency_1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[currency_2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[date_available] [datetime] NULL,
[date_unavailable] [datetime] NULL,
[effective] [int] NULL,
[changeto_item_id] [int] NULL,
[enum_1] [int] NULL,
[enum_2] [int] NULL,
[enum_3] [int] NULL,
[enum_4] [int] NULL,
[enum_5] [int] NULL,
[enum_6] [int] NULL,
[enum_7] [int] NULL,
[enum_8] [int] NULL,
[enum_9] [int] NULL,
[enum_10] [int] NULL,
[enum_11] [int] NULL,
[enum_12] [int] NULL,
[enum_13] [int] NULL,
[enum_14] [int] NULL,
[numeric_1] [float] NULL,
[numeric_2] [float] NULL,
[text_1] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[text_2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_3] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_4] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_5] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[date_1] [datetime] NULL,
[date_2] [datetime] NULL,
[sub_note_control] [int] NULL,
[category] [int] NULL,
[external_id] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[approval_level] [int] NOT NULL CONSTRAINT [DF__usm_rate___appro__7DEE718A] DEFAULT ((0)),
[approval_process] [int] NULL,
[category_class] [int] NULL,
[category_subclass] [int] NULL,
[track_as_asset] [int] NULL CONSTRAINT [DF__usm_rate___track__7EE295C3] DEFAULT ((0)),
[sd_request_area] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[enum_15] [int] NULL,
[allowed_cancellation_state] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_rate_definition] ADD CONSTRAINT [XPKusm_rate_definition] PRIMARY KEY CLUSTERED ([item_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_rate_definition_idx_03] ON [dbo].[usm_rate_definition] ([base_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_rate_definition_idx_01] ON [dbo].[usm_rate_definition] ([rate_plan_id], [rate_row], [rate_col], [status]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_rate_definition_idx_02] ON [dbo].[usm_rate_definition] ([status], [changeto_item_id], [item_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usm_rate_definition] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_rate_definition] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_rate_definition] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_rate_definition] TO [usmgroup]
GO