CREATE TABLE [dbo].[usm_rate_plan]
(
[rate_plan_id] [int] NOT NULL,
[rate_plan_name] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[rate_plan_type] [int] NOT NULL,
[selection_type] [int] NOT NULL,
[status] [int] NOT NULL,
[code] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[date_available] [datetime] NULL,
[date_unavailable] [datetime] NULL,
[date_created] [datetime] NOT NULL,
[date_cancelled] [datetime] NULL,
[is_inherited] [int] NOT NULL,
[has_header] [int] NOT NULL,
[total_rows] [int] NOT NULL,
[total_cols] [int] NOT NULL,
[description] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[notes_id] [int] NULL,
[sub_note_control] [int] NULL,
[domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[folder] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sort_order_no] [int] NULL,
[sd_request_area] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[date_last_modified] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_rate_plan] ADD CONSTRAINT [XPKusm_rate_plan] PRIMARY KEY CLUSTERED ([rate_plan_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_rate_plan_idx_02] ON [dbo].[usm_rate_plan] ([rate_plan_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_rate_plan_idx_01] ON [dbo].[usm_rate_plan] ([rate_plan_type], [status]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_rate_plan] ADD CONSTRAINT [XFKusm_rate_plan1] FOREIGN KEY ([domain]) REFERENCES [dbo].[usm_tenant_ext] ([tenant_id])
GO
GRANT SELECT ON  [dbo].[usm_rate_plan] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_rate_plan] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_rate_plan] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_rate_plan] TO [usmgroup]
GO