[usmuser].[usm_mr_ievent

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	4
Created	5:48:31 PM Tuesday, December 15, 2009
Last Modified	5:48:32 PM Tuesday, December 15, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

Created

5:48:31 PM Tuesday, December 15, 2009

Last Modified

5:48:32 PM Tuesday, December 15, 2009

	Name	Data Type	Max Length (Bytes)
$Indexes usm_mr_ievent_002203_idx1: bulk_id\time_stamp\account_no\service_code$	bulk_id	int	4
$Indexes usm_mr_ievent_002203_idx3: account_no\service_code\time_stamp$ $Indexes usm_mr_ievent_002203_idx1: bulk_id\time_stamp\account_no\service_code$	account_no	varchar(50)	50
$Indexes usm_mr_ievent_002203_idx2: event_id\time_stamp$	event_id	int	4
$Indexes usm_mr_ievent_002203_idx3: account_no\service_code\time_stamp$ $Indexes usm_mr_ievent_002203_idx1: bulk_id\time_stamp\account_no\service_code$	service_code	int	4
$Indexes usm_mr_ievent_002203_idx3: account_no\service_code\time_stamp$ $Indexes usm_mr_ievent_002203_idx1: bulk_id\time_stamp\account_no\service_code$ $Indexes usm_mr_ievent_002203_idx2: event_id\time_stamp$	time_stamp	datetime	8
	value	float	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Indexes usm_mr_ievent_002203_idx1: bulk_id\time_stamp\account_no\service_code$

bulk_id

int

$Indexes usm_mr_ievent_002203_idx3: account_no\service_code\time_stamp$ $Indexes usm_mr_ievent_002203_idx1: bulk_id\time_stamp\account_no\service_code$

account_no

varchar(50)

$Indexes usm_mr_ievent_002203_idx2: event_id\time_stamp$

event_id

int

$Indexes usm_mr_ievent_002203_idx3: account_no\service_code\time_stamp$ $Indexes usm_mr_ievent_002203_idx1: bulk_id\time_stamp\account_no\service_code$

service_code

int

$Indexes usm_mr_ievent_002203_idx3: account_no\service_code\time_stamp$ $Indexes usm_mr_ievent_002203_idx1: bulk_id\time_stamp\account_no\service_code$ $Indexes usm_mr_ievent_002203_idx2: event_id\time_stamp$

time_stamp

datetime

value

float

Name	Columns
usm_mr_ievent_002203_idx1	bulk_id, time_stamp, account_no, service_code
usm_mr_ievent_002203_idx2	event_id, time_stamp
usm_mr_ievent_002203_idx3	account_no, service_code, time_stamp

Name

Columns

usm_mr_ievent_002203_idx1

bulk_id, time_stamp, account_no, service_code

usm_mr_ievent_002203_idx2

event_id, time_stamp

usm_mr_ievent_002203_idx3

account_no, service_code, time_stamp

SQL Script

CREATE TABLE [usmuser].[usm_mr_ievent_002203]
(
[bulk_id] [int] NULL,
[account_no] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[event_id] [int] NULL,
[service_code] [int] NULL,
[time_stamp] [datetime] NULL,
[value] [float] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_mr_ievent_002203_idx3] ON [usmuser].[usm_mr_ievent_002203] ([account_no], [service_code], [time_stamp]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_mr_ievent_002203_idx1] ON [usmuser].[usm_mr_ievent_002203] ([bulk_id], [time_stamp], [account_no], [service_code]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_mr_ievent_002203_idx2] ON [usmuser].[usm_mr_ievent_002203] ([event_id], [time_stamp]) ON [PRIMARY]
GO